On the backup client side, open "NetBackupMSSQLClient" to add verification creden and select setsqlserverconnection. Enter SQLserver information to select the backup Type and object, and then click "backup" to select the Save path, save corner 5.2 create backup policy open the management console and create a new policy. Select backup class
On the backup client side, open "NetBackupMSSQLClient" to add verification creden and select setsqlserverconnection. Enter SQLserver information to select the backup Type and object, and then click "backup" to select the Save path, save corner 5.2 create backup policy open the management console and create a new policy. Select backup class
CreateBackupAngular
InBackupThe client opens the maid ms SQL Client"
Add verification credential
Select set SQL server connection and enter SQL server Information
SelectBackupType and object, and then click "backup"
Select the Save path and save the angular
5.2 createBackupPolicy
Open the management console and create a policy. SelectBackupType and storage location
CreateBackupSchedule, selectBackupPeriod and retention period
SelectBackupClient
SelectBackupObject (created on the clientBackupAngular)
5.3 SQLBackup
SelectBackupPolicy, right-click ManualBackupYou can.
5.4 SQL Local MachineRestore
5.4.1 createRestoreScript
InBackupThe client opens the maid ms SQL Client"
Select Restore SQL Server objects"
After selecting the SQL host, click "OK"
SelectRestorePay attention to the option modification in the red box on the diagram. Generally, follow the option in the diagram.
Select the script storage location and name
5.4.2 runRestoreScript
Through file-> Manage the script file, it will require searching for the script locationRestoreYou can.
Select "yes" to startRestore.
5.5 SQL exceptionRestore
Prerequisites: support for different serversRestoreBut does not supportRestore.RestoreThe database must be online.
RestoreFor the master database, if SQL server is in single-user mode, set the startup parameter "/m" in the management tool service MSSQLServer, and then start the instance. You do not need to switch after 7.0. You can go online.Restore.
AllowRestore, Create C: \ Program Files \ Veritas \ NetBackup \ db \ altnames \ No. restrictions on the backup-ccr1
OpenBackupClient Interface.
First, open the MS SQLClient client interface to configure the new database SQL attributes. For more information, see SQLBackup.
Host: Enter the new database server name (which may be different from the original database server name );
Instance: Enter the database Instance name (same as the original Instance name ).
Click FileRestore SQL server object and select the SQL source (BackupSource, that isBackup).
SQL Host: enter the name of the original database server;
Source Instance: enter the name of the original database Instance;
Time filter: select the Time query range.
SelectRestoreWe recommend that you select create script in scripting for modification. Note the options shown in the figure. For the script, you need to change three items.
DATABASE "test"
// Database name, which cannot be modified
TO "C: \ Program Files \ Microsoft SQL Server \ MSSQL $ CHINAEDUDB \ Data \ my-test.MDF"
// Change the storage location of the database file to the storage location of the new database
TO "C: \ Program Files \ Microsoft SQL Server \ MSSQL $ CHINAEDUDB \ Data \ my-test _ Log. LDF"
// Change the storage location of database logs to the storage location of the new database
Click Filemange script files to read and run the script.
Note:RestoreConsiderations for large databases
When a large database is restored, the "Client Read Timeout" error occurs. The default value of "client read timeout" is 300 seconds (5 minutes ). If you have a client that contains a large SQL Server database, you may need to increase the value significantly.
Select Host Properties> Master Servers and clickBackupServer (NBU), openBackupOn the Server property configuration page, use the Timeouts option to change the Client read timeout and Media mount timeout to a large enough time (we recommend that youRestoreEach 10 Gb database is reserved for 1 hour ).
Select Host Properties> Clients and clickBackupServer (EDUFEDB1), open the Client property configuration interface, and change the Client read timeout in the Timeouts option (recommendedRestoreEach 10 Gb database is reserved for 1 hour ).