# Wednesday, July 12, 2006
SQL Restore

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

FROM YourBackUpDevice
  WITH NORECOVERY
GO
 
-- If you have diff backups here is where you can add, since we are using WITH NORECOVERY
-- Remeber to restore them in order :)

RESTORE LOG YourDB
   FROM YourBackUpDevice
   WITH RECOVERY, STOPAT = 'Jul 12, 2006 10:00 AM'   <------- what ever time before the mishap
GO
 
Of course you can do all this fun stuff via the GUI (and have the EM "not responding") but keep it real and use SQL statements in QA; if you really want to keep it real, use osql to run your statements:)
 
Ed K.
AKA
Eddie Kisinger
Edward Kisinger
CodeMonkey
 
SQL 2000
posted on Wednesday, July 12, 2006 10:20:48 PM (Central Standard Time, UTC-06:00)  #    Comments [0] Trackback
Related posts:
 Tracked by:
"los angeles mortgage" (los angeles mortgage) [Trackback]
"atlanta ebony escorts that fuck" (atlanta ebony escorts that fuck) [Trackback]
"precious metals prices" (precious metals prices) [Trackback]
"Ford C6 Transmission Shifter Parts" (Ford C6 Transmission Shifter Parts) [Trackback]
"Sydney Bristow" (Sydney Bristow) [Trackback]
"mangosteen caplets" (mangosteen caplets) [Trackback]
"www.derma-smoothe%2Ffs eczema oil" (www.derma-smoothe%2Ffs eczema oil) [Trackback]
"FM Jammer Rf" (FM Jammer Rf) [Trackback]
"us state department" (us state department) [Trackback]
"service desk software" (service desk software) [Trackback]
"psychic network" (psychic network) [Trackback]
"celtic sea salt" (celtic sea salt) [Trackback]
"generator wheel kit" (generator wheel kit) [Trackback]
"40-Hour External Li-ion Battery for iPod" (40-Hour External Li-ion Battery for ... [Trackback]
"Phone Number for Symantec Customer Service" (Phone Number for Symantec Customer... [Trackback]
"Wedding event" (Wedding event) [Trackback]
"Ohio liver damage lawsuit attorneys" (Ohio liver damage lawsuit attorneys) [Trackback]
"difference brand synthroid vs generic synthroid" (difference brand synthroid vs... [Trackback]
"What Is Vasotec Used for" (What Is Vasotec Used for) [Trackback]
"lynn daily item" (lynn daily item) [Trackback]
"realestate listings" (realestate listings) [Trackback]
"fax cover sheet" (fax cover sheet) [Trackback]
"central oregon" (central oregon) [Trackback]
"supper solutions" (supper solutions) [Trackback]
"alabama secretary of state" (alabama secretary of state) [Trackback]
"air reserve personnel center" (air reserve personnel center) [Trackback]
"George Washington High School Guam deca" (George Washington High School Guam de... [Trackback]
"acne remedies" (acne remedies) [Trackback]
"vacuum cleaner bags" (vacuum cleaner bags) [Trackback]
"copywriter vancouver BC" (copywriter vancouver BC) [Trackback]
"Float Sink Submarine" (Float Sink Submarine) [Trackback]
"bartender guide" (bartender guide) [Trackback]
"womens lingerie online shopping" (womens lingerie online shopping) [Trackback]
"surgical treatment of obesity" (surgical treatment of obesity) [Trackback]
"kauai accommodation" (kauai accommodation) [Trackback]
"sex rpg games" (sex rpg games) [Trackback]
"Spongebob Squarepants Screensaver" (Spongebob Squarepants Screensaver) [Trackback]
"liquid siding" (liquid siding) [Trackback]
"direct mail magazine insert printing" (direct mail magazine insert printing) [Trackback]
"georgia tech football" (georgia tech football) [Trackback]
"los angeles jail twin towers" (los angeles jail twin towers) [Trackback]
"Bernardo Miami Sandals" (Bernardo Miami Sandals) [Trackback]
"numb linkin park" (numb linkin park) [Trackback]
Comments are closed.

Page rendered at Friday, December 05, 2008 4:04:35 AM (Central Standard Time, UTC-06:00)