Nbu 5 (Nbu Backup Recovery MicrosoftSQL)

Source: Internet
Author: User
Tags sql client
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 ).

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.