...

View Full Version : restoring a sql server database



Bluemonkey
10-15-2003, 04:41 PM
i had a database is my sql sevrer that i backed up and then deleted it. and now i would likt to restore it fom my back up... how can i do this


thank for your help.

ASP-Hosting.ca
10-15-2003, 05:31 PM
Originally posted by Bluemonkey
i had a database is my sql sevrer that i backed up and then deleted it. and now i would likt to restore it fom my back up... how can i do this


thank for your help.

Hi,

First create a new blank database with the same name as your original database. Right-click on the new database -> All Tasks -> Restore Database.

Bluemonkey
10-15-2003, 06:32 PM
i tierd that but it gives an option of restor from first back up but that is blank so i tired to use another backup file option but change the location of the file but that didnt work either.

thanks for the suggestion tho.

allida77
10-15-2003, 08:26 PM
You can find the old .ldb and .mdb(?) and see if you can create a new db and use these as the files. They should be in the Data\ dir under SQLServer.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum