if database crashes how to recover in sql server 2008
-
Hi.. i am using sql server 2008.. if suddenly database crashes then how to recover it? what about data?
Restore a backup Reload the log file
Never underestimate the power of human stupidity RAH
-
Restore a backup Reload the log file
Never underestimate the power of human stupidity RAH
Thanks for reply.. i have an old backup consider for ex on 01-02-2011 after the backup i have added some entries into the table.. now my database is crashed if i restore the old backup only the old data will be restored .. but how to retrive the new data that i have entered after the old backup.. help me...
-
Thanks for reply.. i have an old backup consider for ex on 01-02-2011 after the backup i have added some entries into the table.. now my database is crashed if i restore the old backup only the old data will be restored .. but how to retrive the new data that i have entered after the old backup.. help me...
See if you can backup the transition log and apply that. Let this be a lesson that you need to back up more often.
-
See if you can backup the transition log and apply that. Let this be a lesson that you need to back up more often.
Good advice to the original OP. Depending on how his transaction logging is done, hopefully it is possible.
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!" — Hunter S. Thompson
-
Hi.. i am using sql server 2008.. if suddenly database crashes then how to recover it? what about data?
There's an article in CP which could be benefitial for you. Even though the article has some issues there are mechanisms you could try if the problem is still relevant: Point In Time Restore[^]
The need to optimize rises from a bad design.My articles[^]