SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Master db is got corrupted
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bpgupta
Yak Posting Veteran

India
75 Posts

Posted - 08/20/2007 :  01:50:47  Show Profile  Reply with Quote
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.
BPG

EDIT by tkizer: moved to Data Corruption Issues forum

Edited by - tkizer on 08/20/2007 13:47:42

mcrowley
Aged Yak Warrior

771 Posts

Posted - 08/20/2007 :  15:01:01  Show Profile  Reply with Quote
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?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/20/2007 :  15:49:43  Show Profile  Visit SwePeso's Homepage  Reply with Quote
http://msdn2.microsoft.com/en-us/library/aa213831(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa197950(sql.80).aspx
http://support.microsoft.com/kb/298568
http://technet.microsoft.com/en-us/library/ms143269.aspx
http://support.microsoft.com/kb/817232
http://msdn2.microsoft.com/en-us/library/aa173557(SQL.80).aspx


E 12°55'05.25"
N 56°04'39.16"

Edited by - SwePeso on 08/20/2007 15:52:32
Go to Top of Page

bpgupta
Yak Posting Veteran

India
75 Posts

Posted - 08/22/2007 :  00:16:17  Show Profile  Reply with Quote
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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/22/2007 :  15:00:45  Show Profile  Reply with Quote
Do you have good backup of master db? Restore it if so.
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 08/27/2007 :  14:29:54  Show Profile  Reply with Quote
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?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000