Video Screencast Help

Netbackup for sql recovery

Created: 18 Jan 2014 • Updated: 21 Jan 2014 | 3 comments
Dolly's picture
This issue has been solved. See solution.

Team,

Customer needs to recover crash server/sql DB. customer had ask of me to provide original path od sql db prior the crash as they could not remember.

Is there a way in netbackup to confirm this?

Thank you

Comments 3 CommentsJump to latest comment

Marianne's picture

No Guarantees, but it seems as if 'Create a move template' can be used to find the original path for original database location.

SQL should be up and running when NBU for SQL is opened to browse for SQL backups for this client.

See Browsing for backup images and then how to create the move template under Performing a database move in NBU for SQL Admin Guide:  http://www.symantec.com/docs/DOC3670

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Dolly's picture

Thank you Marianne, I have also thought about this idea too... I will keep you and all posted.

Dolly's picture

I Have been able to retrieve the initial path after the server was rebuild, installed netbackup clients and SQL server. I have put together a simple step by step on how to retrieve the mdf & ldf path. Please see attached for your reference. Thank you.

AttachmentSize
HOW TO RETRIEVE MS SQL DB PATH.pdf 202.39 KB
SOLUTION