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 |
|
Mateusz
Starting Member
2 Posts |
 Posted - 2011-05-25 : 09:54:23
|
| Hello,I would like to rebuild (because of collation) master database (which is as I can see simple operation), but after that I would like to restore all (or almost all) objects in database (all my tables, logins, procedures, linked servers). Is it possible (after rebuilding master database) to simply restore model and msdb databases (as other databases?)Is there any scripts which will speed up this operation? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-05-25 : 14:38:49
|
| Just so I can be clear - do you want to restore msdb as another database , with another name, so you can extract the data?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Mateusz
Starting Member
2 Posts |
Posted - 2011-05-26 : 07:06:55
|
| Hello,I want to restore whole databases object on my server (not only msdb - I am only wondering if it is possible to rebuild master database and simply restore every object which exist on this server before this operation - as it was before this - so msdb will be msdb, model will be model).Some people tell me that it will be much easier to backup whole database object, reinstall SQL Server 2000 and then restore it.I am still not sure - is it possible and which way is faster (not complicated)? |
|
|
|
|
|
|
SQL - whole database copy