IT Infrastructure blog

December 3, 2010

Restore MS SQL Database in another server by using Symantec Netbackup Server

Filed under: Symantec Netbackup — Akther @ 8:29 pm

This article will describe how we can restore MS SQL database in to another server.

Important points need to be noted while restoring a database in to another server

1. Login as a user who is having SQL server access permission. If you are login a user who doesn’t have access to database it will throw error while taking Netbackup agent–> Netbackup MS SQL client from start menu ( right click from net backup Ms Sql client and run as administrator will solve this issue some time)

2. Client and server should be same Netbackup version. ( our case 7.0.1 on both end)

Restore process step by step

Go to Destination server –> Start–> Symantec Netbackup–>Netbackup agent –> Netbackup MS SQL client ( right click –> run as administrator if you have permission)

File –> Restore SQL Server Object –>


SQL Host – Where is the original database backup residing ( Source database server)( If SQL server is in cluster you should have given the cluster name)

Source Client – Same as SQL host ( It means the destination server .i.e same server which you login now to restore)

Click –> Ok

It will show you the latest database and log backup

Select latest log file, it will automatically select latest database for this concern log file

Click –> Restore

It will open a window and we need to save a script. give a meaningful name and click save.

It will open a notepad and in this note pad we need to edit below lines

1. DATABASE “Newdatabase”  ——> This is the database will be restore in destination server

2. MOVE  “sourcedb”

TO  “F:\MSSQL10_50.MSSQLSERVER\MSSQL\Data\newdatabase.mdf”

3. MOVE  “Sourcedb_log”  —> This is the source database server
TO  “F:\MSSQL10_50.MSSQLSERVER\MSSQL\Data\newdatabase_log.LDF”

4. RECOVEREDSTATE       RECOVERED  ( This will enable database restore with recovered)
NUMBUFS    1  ( If we see this as 2 for some reason ) there is a chance to fail the restore)

Once it done Go to File –> Manage script file –> select the script file which we saved in the location–> Start

C:\Program Files\Veritas\Netbackup\dbext\MSSQL ( Location of the script file)

Press F9 then you can see the status or Go to NBU server and see the Activity Monitor

It will restore the database with the name of Newdatabase.mdf

Hope it would be helpful for Netbackup administrators around the world

Thanks

Akther


Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: