Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stegib
Starting Member
16 Posts |
 Posted - 2013-01-29 : 13:19:18
|
| 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. |
|
|
stegib
Starting Member
16 Posts |
Posted - 2013-02-12 : 12:12:41
|
| Does anyone have an answer to this? |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-02-12 : 13:36:08
|
| 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. |
|
|
|
|
|
|
Move SQL2000 instance to a SQL2000 Cluster