cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Restore SQL to another server

Brian_Fuller
Not applicable

‎05-26-2005 10:11 AM

I am trying to restore a SQL database to another instance of SQL on another server. When I try to restore the master database using BUExec 10 using the automate master restore option the job runs sucessfully.

However when I go to EM and pull up the instance I can't get the sql service to start.
Both are SQL 2000 SP3

I can restore all of the other databases and have no problems, but not having a master database that matches doesn't really help.

Is there something I am missing here? Does the source and destination server need the same name? Any help is appreciated.

Thanks.
0 Kudos
1 REPLY 1

Renuka_-
Level 6
Employee

‎06-03-2005 08:34 AM

Hello,

Please refer to page 1085 of the administrator's guide to redirect the restore of SQL 2000 master database. Verify that you are following the right steps.


VERITAS Backup Exec (tm) 10.0 for Windows Servers Administrator's Guide (English)

http://support.veritas.com/docs/269777


NOTE : If we do not receive your reply within two business days, this post would be marked assumed answeredand would be moved toanswered questions pool.
0 Kudos