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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-06-29 : 17:45:46
|
| One of my test servers was rebuilt with larger capacity drives. I need to restore my backups back to this test server. I am trying to use rbuildm.exe to restore master first but it seems like it wants the master.mdf and master.ldf which I don't have. I can't find them in the install files either. How do I restore my backups given this situation?Thanks,RaySS2k |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-29 : 17:54:25
|
| I don't understand why you are using the rebuildm utility. To restore the master database, put the server in single user mode via the command prompt:sqlservr.exe -c -mThen run RESTORE DATABASE master...This is documented in SQL Server Books Online.Tara |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-06-29 : 18:06:53
|
| Thanks for the reply Tara. When I try that command I recieve this message:2005-06-29 15:06:27.71 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)2005-06-29 15:06:27.75 server Copyright (C) 1988-2002 Microsoft Corporation.2005-06-29 15:06:27.76 server All rights reserved.2005-06-29 15:06:27.76 server Server Process ID is 4024.2005-06-29 15:06:27.78 server Logging SQL Server messages in file 'e:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.2005-06-29 15:06:27.79 server initconfig: Error 2(The system cannot find the file specified.) opening 'e:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf' for configuration information. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-29 : 18:08:48
|
| Well SQL Server must have been installed differently (paths to data files) on the rebuilt server. Since that is the case, you aren't going to be able to restore the master database.Tara |
|
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-06-29 : 20:44:08
|
| I was able to rebuild the master using rebuildm.exe by finding the master files on our network drive in the x86\data directory. After that I restored the master database. SQL Server kicked me out which is why I am glad I had access to the SA account. I restored the msdb database and the rest of my databases. Everything seems to be okay.I found this site useful:http://www.informit.com/articles/article.asp?p=27566 |
|
|
|
|
|
|
restore DB's to rebuilt test server