Veritas Netbackup SQL Server native machine-to-machine backup recovery

Source: Internet
Author: User
Tags sql client mssql mssqlserver

Overview:

This experimental environment uses the VERITAS Netbackup 7.7.3 software Release to backup and restore SQL Server databases.


SQL Server Recovery Experiment Extension map:

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/06/3D/wKiom1m0x6zic1rvAAT_xFl5b7Q744.jpg-wh_500x0-wm_ 3-wmp_4-s_4171470927.jpg "title=" 1504962936 (1). jpg "alt=" wkiom1m0x6zic1rvaat_xfl5b7q744.jpg-wh_50 "/>


Native Recovery SQL database:

    • First configure the hosts resolution on the SQL database natively, install the NetBackup agent client

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M01/06/3D/wKiom1m0yn7CQWH_AABOltBPpFc271.jpg-wh_500x0-wm_ 3-wmp_4-s_2690909265.jpg "title=" 1505020492 (1). jpg "alt=" wkiom1m0yn7cqwh_aaboltbppfc271.jpg-wh_50 "/>

Add the IP address resolution for the nbumaster hostname in the C:\Windows\System32\drivers\etc\hosts file;


650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/06/3D/wKiom1m0yt3wGD4dAACEeu1slwo408.png-wh_500x0-wm_ 3-wmp_4-s_2403978355.png "title=" 1505020590.png "alt=" Wkiom1m0yt3wgd4daaceeu1slwo408.png-wh_50 "/>

In the SQL Client server upload installation NBU client x64, the installation process is relatively simple here omit the installation steps;


    • On the SQL database server, configure the NetBackup MS SQL client to generate the SQL backup script

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/A4/EE/wKioL1m0zUfRZ2IqAABzusfbZkE178.png-wh_500x0-wm_ 3-wmp_4-s_3206983128.png "title=" 9L00AT[L@FOYSBD}CGA (n{e.png "alt=" wkiol1m0zufrz2iqaabzusfbzke178.png-wh_50 "/ >

In the backup client configuration to generate SQL backup script, save the script to the appropriate directory;


    • Backup server server side add hosts address resolution, configure Backup policy policies, manual test backup

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M01/06/3D/wKiom1m00hHBVCRFAABSNnz4X3M792.jpg-wh_500x0-wm_ 3-wmp_4-s_2395634780.jpg "title=" 1505022430 (1). jpg "alt=" wkiom1m00hhbvcrfaabsnnz4x3m792.jpg-wh_50 "/>

In the C:\Windows\System32\drivers\etc\hosts file, add Nbumaster, Nbu client's host name corresponding IP address resolution;


650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M00/06/3D/wKiom1m00ZzwQo8ZAADCDlcGyHk335.jpg-wh_500x0-wm_ 3-wmp_4-s_827930028.jpg "title=" 1505022316 (1). jpg "alt=" wkiom1m00zzwqo8zaadcdlcgyhk335.jpg-wh_50 "/>

Create a new backup policy, make manual backup test backups, and then backup the SQL Server database to complete;


    • Test the native Recovery database on the SQL Server client

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/06/3E/wKiom1m05GnDdE3gAAB0XhkKlc8512.jpg-wh_500x0-wm_ 3-wmp_4-s_1621872594.jpg "title=" 1505027119 (1). jpg "alt=" wkiom1m05gndde3gaab0xhkklc8512.jpg-wh_50 "/>

The SQL Server database client selects the database to be recovered for recovery;


650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/06/3F/wKiom1m05O3g2rxXAADfqJuOgJg098.jpg-wh_500x0-wm_ 3-wmp_4-s_4060097789.jpg "title=" 1505027249 (1). jpg "alt=" wkiom1m05o3g2rxxaadfqjuogjg098.jpg-wh_50 "/>

The process of initiating recovery will be found at the NBU master end;


    • Test the heterogeneous Recovery database on the SQL Server2 client

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/06/45/wKiom1m1R_7jN9vfAACBqQ9vAeA960.png-wh_500x0-wm_ 3-wmp_4-s_689642494.png "title=" S%bji~j95h{69y}007u9_j1.png "alt=" Wkiom1m1r_7jn9vfaacbqq9vaea960.png-wh_50 "/>

Configure the hosts resolution on both SQL Server database servers and NBU master;


650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/A4/F6/wKioL1m1TWWQ1ZxsAACB0KmPtAY237.png-wh_500x0-wm_ 3-wmp_4-s_2862473537.png "title="%q]wgrndl]95kbh@d}ui%6b.png "alt=" wkiol1m1twwq1zxsaacb0kmptay237.png-wh_50 "/ >

Create the Altnames folder in the NBU Master server-side Veritas NetBackup Directory and create the No.restrictions file within the folder;

Specific path C:\Program files\veritas\netbackup\db\altnames;


650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/06/45/wKiom1m1TjWhJXt9AACBYLnfaoo951.png-wh_500x0-wm_ 3-wmp_4-s_2715878859.png "title=" _[xoma01hy]9o_k_kta ' G ' 7.png "alt=" wkiom1m1tjwhjxt9aacbylnfaoo951.png-wh_50 "/ >

Install the NetBackup Client Agent configuration on the CLIENT2 server and choose to create a save recovery heterogeneous database script;


DATABASE "test" move "test" to "C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\data\test.mdf" Move " S "to" C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\data\s.ndf "MOVE" Test_log "to" C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\data\test_log.ldf "

Modify the generated backup script to remove the # comment;


650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M01/06/46/wKiom1m1T5_RLiFnAADjstA40So377.png-wh_500x0-wm_ 3-wmp_4-s_2884096573.png "title=" R{qe{@7jgy9trgv}z ({_S@T.png "alt=" wkiom1m1t5_rlifnaadjsta40so377.png-wh_50 "/ >

In Client2 open client2 Netbackup MS SQL Client, select Manage Scripts Select the script you just saved, select Start recovery;


650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/06/46/wKiom1m1UW7Aq3HqAACOA2Db1HQ169.png-wh_500x0-wm_ 3-wmp_4-s_1860407593.png "title=" C) ' 0] @o%a1]yutr}7ty48uc.png "alt=" wkiom1m1uw7aq3hqaacoa2db1hq169.png-wh_50 "/ >

View status recovery succeeded on CLIENT2 Netbackup MS SQL Client, at which point the SQL Server database was successfully recovered;

This article is from "Sound's blog" blog, please be sure to keep this source http://sound.blog.51cto.com/11960199/1964204

Veritas Netbackup SQL Server native machine-to-machine backup recovery

Related Article

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.