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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2004-01-16 : 19:47:23
|
| We have a not so important install of SQL Server running here. The OS crashed and the admin formatted and reinstalled a fresh copy of NT and SQL Server 2k. The problem is that there is not a backup of the MASTER database. We have backups of the DB we created but not the MASTER. We do have the MDF and LDF from the old MASTER DB... is there a way to use them to restore from?Thanks.DanielSQL Server DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-01-17 : 17:54:50
|
| You can simply try stopping the SQL Server service, replacing the MDF and LDF with the originals, and try restarting it. I know I did this once successfully, but it is NOT a recommended practice. Of course if this doesn't work, you'll probably have to resintall SQL Server again.You should avoid adding any critical procedures or data to master directly. Databases are intended to be self-contained units; master, model, and msdb are purely system databases that are intended to function from a fresh install. Your other databases should not rely on a specific version of master in order to function. |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2004-01-20 : 11:56:26
|
quote:
Originally posted by robvolkYou should avoid adding any critical procedures or data to master directly. Databases are intended to be self-contained units; master, model, and msdb are purely system databases that are intended to function from a fresh install. Your other databases should not rely on a specific version of master in order to function.
Yeah, I hear ya. A third party app is on this server and the stupid thing creates a new SQL Server login (standard login) for each user you setup in the application. Lol, then on top of that it attaches database objects to those logins. The objects are "reports" in the application. I would much rather not run an application that does this but I have no choice, so it gets its own little msde server.  DanielSQL Server DBA |
|
|
|
|
|
|
Restoring the Master DB with only MDF and LDF?