May 20, 2008 at 1:50 pm
Hi All,
I am using SQL Server 2000 database. I have taken individual backup of master, model, msdb, and user databases. I have to restore these backups to a new server. Can someone explain me, how to do the restoration from scartch.
- Vivek
June 4, 2008 at 10:51 am
Vivek,
I think the sequence should be as mentioned below(not sure as I haven't done it so far):
1. Restore all user databases on new server.
2. Restore msdb database(it needs to be restored with agent service stopped during the restoration).
3. Restore model database(actually its not needed unless until you have tempered with original copy of model database).
4. Restore master database(follow from step 15 onwards in http://www.dbarecovery.com/restoremasterdb.html).
5. After restoration make sure there are no orphan users in any of the user database(they shouldn't be as logins will get restored with master database restoration).
6. To make sure servername entry in sysservers table(under master database) is pointing to current server you have to use sp_dropserver and sp_addserver stored procedure (its there in books online).
7. Change server name in any of the connections that are pointing to old server under dts packages.
Manu
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply