Click here to Skip to main content
15,868,340 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
See more:
how to recovered sql server database when sql server is crasss..
Posted
Comments
[no name] 6-May-14 8:22am    
You need to supply way more information than just this.
HuyNTT 6-May-14 10:21am    
What do you mean crash?
Service crash or mdf and log file of database crash?
José Amílcar Casimiro 6-May-14 12:54pm    
How can the mdf and log file crash? Do you mean a physical crash?
HuyNTT 7-May-14 11:25am    
Some how the SQL server stop in midle of saving process ( power supply interrupted).
Or disk error (physical crash)

1 solution

Use restore!
http://technet.microsoft.com/en-us/library/ms186858.aspx

Now you do have backups?

you can try the DBCC CHECKDB to repair it, it often works if the crash isn't too close to the metal.
http://technet.microsoft.com/en-us/library/aa258278(v=sql.80).aspx
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900