July 13, 2006 4:20 AM
by Ed Kisinger
So have you ever had the need to restore a SQL database because someone hit the delete button on a table or the whole Database? Well, my friend I have seen this happen several times. Here is some code to restore your database back to a certain point in time.
Start Server in single user mode : sqlservr -m
RESTORE DATABASE YourDB
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, sup, u
Ed Blankenship is a Product Manager at Microsoft for Visual Studio Online. I am an author of a few books, former Microsoft MVP of the Year, and former ALM consultant. I hold Office Hours each week if you are interested in chatting.
Managed Windows Shared Hosting by OrcsWeb
Site design by Jeremy Kratz