Post reply

Can I restore a deleted DB from its backup?

  • February 2, 2004 at 12:24 pm

    #160715

    Hi gurus,

  • February 2, 2004 at 12:29 pm

    #492520

    Sorry, hit the wrong button. For disk space reason, I plan to backup some user DB, then delete these DB. If needed later,is there any way to resore these DB later from the backup? Thanks!

  • February 2, 2004 at 12:53 pm

    #492527

    Run Restore command, you can also move the files to other drives.

  • February 2, 2004 at 1:18 pm

    #492531

    Thanks! Allen, I will backup them to another server or I may move the files to another server.

  • February 2, 2004 at 1:31 pm

    #492535

    Here's where you can find more information on doing the backup and restore.

    In the BOL, use the Index tab and enter BACKUP DATABASE (look for the entry for Transact SQL). After you check out that, enter RESTORE DATABASE.

    -SQLBill

    BOL = Books OnLine = MS SQL Server's Help

    Installed as part of the Client Tools and can be found at Start>Programs>Microsoft SQL Server>Books OnLine.

  • February 2, 2004 at 2:54 pm

    #492556

    Thanks SQLBill

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply