Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    restoring a sql server database

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

  • #2
    New to the CF scene
    Join Date
    Sep 2003
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: restoring a sql server database

    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.

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Spoooooooon

  • #4
    Regular Coder
    Join Date
    Jun 2002
    Location
    Cincinnati, OH
    Posts
    545
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    does this sig match?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •