Master database restore
-
how i can restore the sql master database to a different server?
what are the requirment to do this?
Regards,
-
The target server (on which master is to be restored) should ideally be at the same service level as the original. Further problems will be minimised by having SQL executables and data in the same locations too.
Backup your target server's master database first.... just in case.
Backup you original server's master. eg.
BACKUP DATABASE master TO DISK = 'c:\Temp\master.bak' WITH INIT, STATS=20
On the target server, stop SQL Server and then start it in single user mode.
NET STOP MSSQLSERVER /Y
NET START MSSQLSERVER /M
"/Y" stops dependent services too - such as SQLSERVERAGENT. "/M" is the startup switch for single-user mode. (I don't know how M stands for single-user so don't ask
)You can then get an ISQL/OSQL or QA connection and restore the database from the original server's backup. Eg.
RESTORE DATABASE master FROM DISK = '\\OriginalSvr\c$\Temp\master.bak' WITH REPLACE, STATS=20
Cheers,
- Mark -
thanks for replying
actually i do hese procedure but i don't know why usually it is not 100% success sometimes it fail and never restore.
if the collation changed between old server and new server is this will prevent the restore?
-
without researching it... I'd say yes, the change of collation will cause a problem.
Cheers,
- Mark
)Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply