NBU Backup and restore of SQL

Source: Internet
Author: User
Tags mssql mssql client

Chapter I. MSSQL BACKUP

1. Make sure the MSSQL database can be used normally

2, install the NBU client software on Windows, install the client software will automatically install the MSSQL agent, installation and restart.

3. Set the MSSQL user name and password in the Set server Connections properties property of the client's NetBackup MSSQL clients tool, enter the user name and password, press apply, and then close.

650) this.width=650; "title=" clip_image002 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image002 "src=" http://s3.51cto.com/wyfs02/M01/59/53/ Wkiom1tqlescpmdwaab6trgkz2s096.jpg "" 557 "height=" 327 "/>

650) this.width=650; "title=" clip_image003 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image003 "src=" http://s3.51cto.com/wyfs02/M02/59/53/ Wkiom1tqlewiyfjvaaf8ihq02cw507.jpg "" 480 "height=" 466 "/>

4, generate backup MSSQL various types of backup scripts (full backup/differential backup/log backup, etc.)

On the client open the NetBackup MSSQL Client tool, select Backup SQL server objects

650) this.width=650; "title=" clip_image005 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image005 "src=" http://s3.51cto.com/wyfs02/M00/59/53/ Wkiom1tqleadwjqsaab5o7qvpio626.jpg "" 558 "height=" 328 "/>

Select the database/backup type that you want to back up, choose Save Save, and then click Backup to save the backup script.

650) this.width=650; "title=" clip_image007 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image007 "src=" http://s3.51cto.com/wyfs02/M01/59/53/ Wkiom1tqlefagpv4aadpdmgs7_c378.jpg "" 558 "height=" 327 "/>

650) this.width=650; "title=" clip_image009 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image009 "src=" http://s3.51cto.com/wyfs02/M02/59/53/ Wkiom1tqlemqna2taadpnhyrw0q299.jpg "" 558 "height=" 327 "/>

5, set up backup strategy of MSSQL

Select a policy type of ms-sql-server

650) this.width=650; "title=" clip_image010 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image010 "src=" http://s3.51cto.com/wyfs02/M00/59/53/ Wkiom1tqlerds5ilaanbdf50zo8490.jpg "" 527 "height=" 622 "/>

Add a backup schedule with the backup type selected as automatic backup. Default-application-backup can not be deleted, it is actually back up the MSSQL plan, and its retention data time retention changed to automatic backup retention the same.

650) this.width=650; "title=" clip_image011 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image011 "src=" http://s3.51cto.com/wyfs02/M01/59/53/wKiom1TQLeuxwQJ_ Aaiipgxg1tq156.jpg "" 526 "height=" 621 "/>

Add Client

650) this.width=650; "title=" clip_image012 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image012 "src=" http://s3.51cto.com/wyfs02/M02/59/53/ Wkiom1tqlevj0l88aafhzink1ry397.jpg "" 530 "height=" 621 "/>

Add a backup script created by the client to add only one script.

650) this.width=650; "title=" clip_image013 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image013 "src=" Http://s3.51cto.com/wyfs02/M00/59/53/wKiom1TQLezgk_ 9vaaftkbr9zyi005.jpg "" 527 "height=" 620 "/>

6. Perform a manual backup test

650) this.width=650; "title=" clip_image015 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image015 "src=" http://s3.51cto.com/wyfs02/M01/59/53/ Wkiom1tqle7dhax5aaggwkomht8407.jpg "" 558 "height=" 329 "/>

650) this.width=650; "title=" clip_image017 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image017 "src=" http://s3.51cto.com/wyfs02/M02/59/53/ Wkiom1tqlfdcriscaafaoh0vevg545.jpg "" 557 "height=" 327 "/>

Chapter II SQL Server recovery

When recovering a database, you do not have to stop the MSSQL instance service, and you do not have to remove other normal databases.

1, in the server-side backup/archive and Restore tool specify NetBackup machines and policy type set the source and destination machine, the recovery policy type is Ms-sql-server

650) this.width=650; "title=" clip_image019 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image019 "src=" http://s3.51cto.com/wyfs02/M00/59/53/ Wkiom1tqlfgwhmb8aaflswoziu0181.jpg "" 557 "height=" 327 "/>

650) this.width=650; "title=" clip_image021 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image021 "src=" http://s3.51cto.com/wyfs02/M00/59/53/ Wkiom1tqlfoacigfaaeo4tmf7b4313.jpg "" 557 "height=" 327 "/>

650) this.width=650; "title=" clip_image023 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image023 "src=" http://s3.51cto.com/wyfs02/M02/59/50/ Wkiol1tqlt2z4tsgaaecj3hyu6g195.jpg "" 557 "height=" 327 "/>

650) this.width=650; "title=" clip_image025 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image025 "src=" Http://s3.51cto.com/wyfs02/M00/59/50/wKioL1TQLt_ Illvwaaenj6e1uzq763.jpg "" 557 "height=" 327 "/>

2, on the server side with NetBackup MSSQL client to restore MSSQL

Select Restore SQL Server objects

650) this.width=650; "title=" clip_image027 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image027 "src=" http://s3.51cto.com/wyfs02/M00/59/53/ Wkiom1tqlfirluxvaab599wbfos645.jpg "" 557 "height=" 327 "/>

Select Database

650) this.width=650; "title=" clip_image029 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image029 "src=" http://s3.51cto.com/wyfs02/M01/59/53/ Wkiom1tqlfnijgreaadif3vopsu629.jpg "" 557 "height=" 326 "/>

Select the database you want to recover, only one database at a time. Select Use Replace option (can replace existing database files) and recovered (to automatically recover the database, so that the database is not grayed out after the recovery is complete, the database becomes unavailable), the database check is None, select the launch After immediately, press Restore to recover. You can see the progress of the recovery job in Activity monitor.

650) this.width=650; "title=" clip_image031 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image031 "src=" http://s3.51cto.com/wyfs02/M02/59/53/ Wkiom1tqlfud6t4daaeytanta_g249.jpg "" 558 "height=" 505 "/>

This is a native restore restore, if you need to use a script to restore, the first to make a script, and then modify the script, when making the script, the launch immediately changed to save; And then modify the script (because this document was written by another engineer, I was fully replenished in my test environment, so I saw a different name for the recovery database)

650) this.width=650; "title=" clip_image033 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image033 "src=" http://s3.51cto.com/wyfs02/M00/59/53/ Wkiom1tqlf2qdgavaahrkzdqhki641.jpg "" 580 "height="/>

Attention:

NBU when recovering master datbase, it is not necessary to stop and boot the MSSQL instance into single user mode, but choose Use Replace option (which can replace the existing database file) and recovered (the database is automatically recovered. This will not find the database grayed out after the recovery is complete and the database becomes unavailable. During the recovery process, the MSSQL instance is NBU shut down and then started.

If the entire MSSQL database crashes, restore the master database and restore the other normal databases first.

When recovering a normal database, if the database is grayed out after the recovery is complete and "loading" is displayed, the user is required to enter into the SQL parser with the following command: Restore Database Database-name with recovery

NBU Backup and restore of SQL

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.