restoring a sql server database

[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.

[ASP-Hosting.ca]

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]

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]

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.