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 |
|
moose051
Starting Member
15 Posts |
 Posted - 2002-04-10 : 21:25:28
|
| Can someone please give me some more information on restoring the master database.Recently we discovered that one of our SQL servers had a corrupt master database. Now after rebuilding it and then trying to restore it was discovered that the master had been corrupt for about a week.We finally were able to restore a copy of the master database from 6 days ago. The user database was alright and seemed to be functioning correctly.My question is: What data/info/settings would I have lost by restoring a master database that is 1 week old assuming that the user database was being used during that time?Any information would be greatly appreciated.Thanks,Matt |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-11 : 11:30:28
|
If you created/deleted any of the following during the last week, you'll have to create/delete them again:- user databases
- linked servers
- server logins
Also if you have played with the file settings for any of your databases (sizes, growth increments etc) recently, you should double check that they are now set to what you want them to be...---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
|
|
|
Master DB Restore.