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
Hi! I am Ed Blankenship and a Product Manager at Microsoft for Visual Studio Online, Team Foundation Server, and the Application Lifecycle Management family of tools. I am an author of a few books, former Microsoft MVP of the Year, and a former ALM consultant.
Powered by Azure Websites
Site design by Jeremy Kratz