SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Move SQL2000 instance to a SQL2000 Cluster
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

stegib
Starting Member

USA
16 Posts

Posted - 01/29/2013 :  13:19:18  Show Profile  Reply with Quote
Can I restore a master database from a single server to Cluster servers from backups? I have already restored the working databases but the master, msdb, and model also need to be restored so I can have all my permissions and stored procedures also restored. The SQL2000 Cluster servers also has a different SQL instance name. Both the single SQL2000 server and SQL2000 Cluster servers are the same build and same patch level. If it can be done please tell me the procedure.


Edited by - stegib on 01/29/2013 13:29:33

stegib
Starting Member

USA
16 Posts

Posted - 02/12/2013 :  12:12:41  Show Profile  Reply with Quote
Does anyone have an answer to this?
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
797 Posts

Posted - 02/12/2013 :  13:36:08  Show Profile  Reply with Quote
No - even if it were possible I would not recommend it.

Script out all stored procedures that you created in master, script out the logins (sp_help_revlogin is what I would use), export DTS packages and import on the new system, and any other objects that you built in any of the system databases.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000