FS
Documentation

Backup3G/DA-SQLserver 1.1 Release Notes

This page was last modified 06:37, 25 February 2008.

From Documentation

< Backup3G(Difference between revisions)
Jump to: navigation, search
Revision as of 06:04, 25 February 2008
Moff (Talk | contribs)

← Previous diff
Current revision
Moff (Talk | contribs)
(Installing DA-SQLserver for Windows)
Line 43: Line 43:
<br> <br>
-Installing DA-SQLserver for Windows+== Installing DA-SQLserver for Windows ==
 + 
To install the DA-SQLserver module, you must already have COSmanager and COSbackup installed on your COSbackup Master. Before installing the DA-SQLserver, check the System Requirements to ensure your system has the required resources. To install the DA-SQLserver module, you must already have COSmanager and COSbackup installed on your COSbackup Master. Before installing the DA-SQLserver, check the System Requirements to ensure your system has the required resources.
Line 52: Line 53:
The procedure is: The procedure is:
-#Copy the DA-SQLserver distribution file to your UNIX/Linux COSbackup Master and place it in /tmp+#Copy the DA-SQLserver distribution file to your UNIX/Linux COSbackup Master and place it in <code>/tmp</code>
#Login to COSmanager on the COSbackup Master as a user with the Manager role #Login to COSmanager on the COSbackup Master as a user with the Manager role
#Using the standard COSmanager application installation method, install the DA-SQLserver module. #Using the standard COSmanager application installation method, install the DA-SQLserver module.
Line 59: Line 60:
Now you need to push the client software to the Windows clients: Now you need to push the client software to the Windows clients:
-#Select Config > COSbackup configuration > Initial Configuration from+#Select {{cnav |Config > COSbackup configuration > Initial Configuration}} from the COSmanager buttonbar
-the COSmanager buttonbar+#Select {{cnav |Push SQLserver backup client to Windows clients}}, then select {{cnav |Perform > Selected}}
-#Select "Push SQLserver backup client to Windows clients", then select Perform >+
-Selected+
#Select all the Windows hosts that require the SQLserver backup software and press Accept. #Select all the Windows hosts that require the SQLserver backup software and press Accept.
<br> <br>
 +
== Notes == == Notes ==
Line 71: Line 71:
You must define the backup item Object for a SQL Server online backup as: You must define the backup item Object for a SQL Server online backup as:
-<SQL-Server-name>/<Database-name>+:<code>SQL-Server-name/Database-name</code>
-For example, HR/Payroll+For example, <tt>HR/Payroll</tt>
-By specifying the -s <file pattern> flag in the backup item Options, the SQL Server+ 
-database backup will include files that match <file pattern>. For example, -s “C:/Program+By specifying the '''-s ''<file pattern>''''' flag in the backup item Options, the SQL Server database backup will include files that match '''''<file pattern>'''''.
-Files/Microsoft SQL Server/MSSQL\$HR/Binn/sqlctr.*”.+ 
-Note When specifying addition files to be backed up along with the database backup, the $+For example, <tt>-s “C:/Program Files/Microsoft SQL Server/MSSQL\$HR/Binn/sqlctr.*”</tt>.
-character must be protected by preceeding it with a \, as in the above example.+{{Note |When specifying addition files to be backed up along with the database backup, the $ character must be protected by preceding it with a \, as in the above example.}}
-Simultaneous Backups+ 
 +<br>
 +==== Simultaneous Backups ====
 + 
You cannot run two or more online backup jobs of the same database at the same time. Doing so You cannot run two or more online backup jobs of the same database at the same time. Doing so
will result in errors. will result in errors.
-Recovery to an active SQL Server 2000 database+ 
 +<br>
 +==== Recovery to an active SQL Server 2000 database ====
 + 
The proceedure to recover a database is as follows: The proceedure to recover a database is as follows:
-1. From the SQL Server Enterprise Manager take the database to be recovered offline+#From the SQL Server Enterprise Manager take the database to be recovered offline
-2. If restoring to a different SQL Server, first run New Database ... from SQL Server+#If restoring to a different SQL Server, first run New Database ... from SQL Server Enterprise Manager to create an entry for the database you wish to restore
-Enterprise Manager to create an entry for the database you wish to restore+#Restore from the first backup (typically a full backup)
-3. Restore from the first backup (typically a full backup)+#If appropriate, restore from the last differential backup
-4. If appropriate, restore from the last differential backup+#If appropriate, restore from transaction log backup(s)
-5. If appropriate, restore from transaction log backup(s)+#From the SQL Server Query Analyser, select the Server and select the Database and run the SQL query<br><code>restore database <database> with recovery</code>
-6. From the SQL Server Query Analyser, select the Server and select the Database and run the+ 
-SQL query "restore database <database> with recovery".+The last step is required as COSbackup performs all the SQL Server recoveries without rolling forward. This is necessary because once you roll forward you can not restore any more differential or transaction log backups.
-The last step is required as COSbackup performs all the SQL Server recoveries without rolling+ 
-forward. This is necessary because once you roll forward you can not restore any more differential+<br>
-or transaction log backups.+==== Recovery to an active SQL Server 2005 database ====
-Release Notes for DA-SQLserver 1.1 for Windows—March 2006 Page 5+ 
-Recovery to an active SQL Server 2005 database+
The proceedure to recover a database is as follows: The proceedure to recover a database is as follows:
-1. From the SQL Server Enterprise Management Studio, select the Server and select the Database+#From the SQL Server Enterprise Management Studio, select the Server and select the Database and run the SQL query<br><code>sp_dboption ‘<database>’, ‘offline’, ‘true’</code><br>to take the database to be recovered offline
-and run the SQL query "sp_dboption ‘<database>’, ‘offline’, ‘true’"+#If restoring to a different SQL Server, first run New Database ... from SQL Server Enterprise Management Studio to create an entry for the database you wish to restore
-to take the database to be recovered offline+#Restore from the first backup (typically a full backup)
-2. If restoring to a different SQL Server, first run New Database ... from SQL Server+#If appropriate, restore from the last differential backup
-Enterprise Management Studio to create an entry for the database you wish to restore+#If appropriate, restore from transaction log backup(s)
-3. Restore from the first backup (typically a full backup)+#From the SQL Server Enterprise Management Studio, select the Server and select the Database and run the SQL query<br><code>restore database <database> with recovery</code>
-4. If appropriate, restore from the last differential backup+#From the SQL Server Enterprise Management Studio, select the Server and select the Database and run the SQL query<br><code>sp_dboption ‘<database>’, ‘offline’, ‘false’</code><br>to place the database online.
-5. If appropriate, restore from transaction log backup(s)+ 
-6. From the SQL Server Enterprise Management Studio, select the Server and select the+Step 6 is required as COSbackup performs all the SQL Server recoveries without rolling forward. COSbackup does this because once you roll forward you can not restore any more differential or transaction log backups without starting the whole recovery process from the beginning.
-Database and run the SQL query "restore database <database> with recovery"+ 
-7. From the SQL Server Enterprise Management Studio, select the Server and select the+<br>
-Database and run the SQL query "sp_dboption ‘<database>’, ‘offline’,+== Warnings ==
-‘false’" to place the database online.+ 
-Step 6 is required as COSbackup performs all the SQL Server recoveries without rolling forward.+==== The statement BACKUP LOG is not allowed while the recovery model is SIMPLE ====
-COSbackup does this because once you roll forward you can not restore any more differential or+ 
-transaction log backups without starting the whole recovery process from the beginning.+Transaction Log backups can only be performed for databases whose recovery model is set to Full or Bulk-Logged.
-Release Notes for DA-SQLserver 1.1 for Windows—March 2006 Page 6+ 
-Warnings+To enable Full transaction logging for a specific database, from the SQL Server shell (osql), run {{code |ALTER DATABASE <database> SET RECOVERY FULL}}
-The statement BACKUP LOG is not allowed while the recovery model is SIMPLE:+ 
-Transaction Log backups can only be performed for databases whose recovery model is set to Full+<br>
-or Bulk-Logged.+==== Database backup cannot span more than one tape ====
-To enable Full transaction logging for a specific database run 'ALTER DATABASE <database>+ 
-SET RECOVERY FULL' from the SQL Server shell (osql).+When performing an Online backup an error will occur when end of media is reached. It is recommended that Online backups be the first step in a backup job.
-Database backup cannot span more than one tape: When performing an Online backup an error+ 
-will occur when end of media is reached. It is recommended that Online backups be the first step+<br>
-in a backup job.+==== The TEMPDB database cannot be backed up ====
-The TEMPDB database cannot be backed up: SQL Server doesn't allow the TEMPDB database+ 
-to be backed up.+SQL Server doesn't allow the TEMPDB database to be backed up.
-Transactions Logs cannot be backed up for the MASTER and TEMPDB databases: SQL+ 
-Server doesn't allow the backup of the transaction logs for the MASTER and TEMPDB databases.+<br>
 +==== Transactions Logs cannot be backed up for the MASTER and TEMPDB databases ====
 + 
 +SQL Server doesn't allow the backup of the transaction logs for the MASTER and TEMPDB databases.
<br> <br>
Line 132: Line 140:
| <br>[[#top|^]] | <br>[[#top|^]]
|} |}
 +
== Hardware and OS Dependencies == == Hardware and OS Dependencies ==

Current revision

Contents

Overview and Features

DA-SQLserver for Windows is a backup module for the backup and recovery of Micrsoft™ SQL Server databases. This module has also been certified for use with SQL Server 2000 and 2005.

The distribution is generic and will run on all UNIX platforms supported by COSbackup 3.2.6 or newer.


Features in DA-Lotus


Environment

Software Prerequisites

Before you can install DA-SQLserver 1.1, you must have:


Disk Space Required

DA-SQLserver 1.1 is installed in the EWC home directory by pushing the software from the COSbackup Master to the Windows server. It requires less than 200 Kbytes disk space on both servers.


Supported Microsoft™ SQL Server Versions

DA-SQLserver V1.1 supports Microsoft™ SQL Server versions:

and the Windows versions supported are:


Installing DA-SQLserver for Windows

To install the DA-SQLserver module, you must already have COSmanager and COSbackup installed on your COSbackup Master. Before installing the DA-SQLserver, check the System Requirements to ensure your system has the required resources.

You need :

The procedure is:

  1. Copy the DA-SQLserver distribution file to your UNIX/Linux COSbackup Master and place it in /tmp
  2. Login to COSmanager on the COSbackup Master as a user with the Manager role
  3. Using the standard COSmanager application installation method, install the DA-SQLserver module.

The above will install the SQLserver backup format, and backup and recovery methods.

Now you need to push the client software to the Windows clients:

  1. Select Config > COSbackup configuration > Initial Configuration from the COSmanager buttonbar
  2. Select Push SQLserver backup client to Windows clients , then select Perform > Selected
  3. Select all the Windows hosts that require the SQLserver backup software and press Accept.


Notes

Defining Backup Items

You must define the backup item Object for a SQL Server online backup as:

SQL-Server-name/Database-name

For example, HR/Payroll

By specifying the -s <file pattern> flag in the backup item Options, the SQL Server database backup will include files that match <file pattern>.

For example, -s “C:/Program Files/Microsoft SQL Server/MSSQL\$HR/Binn/sqlctr.*”.

Note
Note
When specifying addition files to be backed up along with the database backup, the $ character must be protected by preceding it with a \, as in the above example.


Simultaneous Backups

You cannot run two or more online backup jobs of the same database at the same time. Doing so will result in errors.


Recovery to an active SQL Server 2000 database

The proceedure to recover a database is as follows:

  1. From the SQL Server Enterprise Manager take the database to be recovered offline
  2. If restoring to a different SQL Server, first run New Database ... from SQL Server Enterprise Manager to create an entry for the database you wish to restore
  3. Restore from the first backup (typically a full backup)
  4. If appropriate, restore from the last differential backup
  5. If appropriate, restore from transaction log backup(s)
  6. From the SQL Server Query Analyser, select the Server and select the Database and run the SQL query
    restore database <database> with recovery

The last step is required as COSbackup performs all the SQL Server recoveries without rolling forward. This is necessary because once you roll forward you can not restore any more differential or transaction log backups.


Recovery to an active SQL Server 2005 database

The proceedure to recover a database is as follows:

  1. From the SQL Server Enterprise Management Studio, select the Server and select the Database and run the SQL query
    sp_dboption ‘<database>’, ‘offline’, ‘true’
    to take the database to be recovered offline
  2. If restoring to a different SQL Server, first run New Database ... from SQL Server Enterprise Management Studio to create an entry for the database you wish to restore
  3. Restore from the first backup (typically a full backup)
  4. If appropriate, restore from the last differential backup
  5. If appropriate, restore from transaction log backup(s)
  6. From the SQL Server Enterprise Management Studio, select the Server and select the Database and run the SQL query
    restore database <database> with recovery
  7. From the SQL Server Enterprise Management Studio, select the Server and select the Database and run the SQL query
    sp_dboption ‘<database>’, ‘offline’, ‘false’
    to place the database online.

Step 6 is required as COSbackup performs all the SQL Server recoveries without rolling forward. COSbackup does this because once you roll forward you can not restore any more differential or transaction log backups without starting the whole recovery process from the beginning.


Warnings

The statement BACKUP LOG is not allowed while the recovery model is SIMPLE

Transaction Log backups can only be performed for databases whose recovery model is set to Full or Bulk-Logged.

To enable Full transaction logging for a specific database, from the SQL Server shell (osql), run

code ALTER DATABASE <database> SET RECOVERY FULL


Database backup cannot span more than one tape

When performing an Online backup an error will occur when end of media is reached. It is recommended that Online backups be the first step in a backup job.


The TEMPDB database cannot be backed up

SQL Server doesn't allow the TEMPDB database to be backed up.


Transactions Logs cannot be backed up for the MASTER and TEMPDB databases

SQL Server doesn't allow the backup of the transaction logs for the MASTER and TEMPDB databases.



^

Hardware and OS Dependencies

None known.



March 2006
Copyright © 1990-2024 Functional Software. All rights reserved.