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 |
|
bpgupta
Yak Posting Veteran
75 Posts |
 Posted - 2007-08-20 : 01:50:47
|
| Hi ALL,My sql server is not starting becasue master db got corrupted.I have tried to rebuild the master db with rebuild utility.Now the process of rebuilding taken 6 hours but still the process of rebuild master is going on.Can any body faced this problem why it is not rebuilding the simple master database.Thanks you.BPGEDIT by tkizer: moved to Data Corruption Issues forum |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-08-20 : 15:01:01
|
| Are any applications attempting to connect to this box as administrators while you are rebuilding? That could block the scripts that need to run in single user mode, although the rebuild utility should fail, rather than wait.What caused the original corruption? Were there disk errors in the System Event log? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-08-22 : 00:16:17
|
| Due to power failer server got down and after that it is not starting.After looking into log error file i got to know that master itself not accessed by server.There is no application accessing the database.I have tried the microsoft process to rebuild, while rebuilding it is showing the process is going on,but it has taken too much time , but not rebuilded.What can be other way to up the server.Thanks,BPG |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 15:00:45
|
| Do you have good backup of master db? Restore it if so. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-08-27 : 14:29:54
|
| You may be looking at a full re-install fo SQL Server, if the master rebuild utility is not even running. Can you post any errors from the SQL Errorlog? |
|
|
|
|
|
|
Master db is got corrupted