Post reply

need to delete the datbase and then restore of the different backup on daily bases

  • July 3, 2013 at 6:40 am

    #276928

    Good Morning I would appreciate if I can get a syntax to run, this is what I need to accomplish,

    Delete the database, (it gives me error with connections open)

    Once it is deleted I want to restore it of .bak file,

    Help is much appreciated,

    Regards,

    Bubby

  • July 3, 2013 at 6:59 am

    #1629510

    Why are you deleting the database before restoring it?

    You can restore with replace, which will overwrite the entire database

  • July 3, 2013 at 7:07 am

    #1629514

    Can I get the syntax for that, it makes sense

  • July 3, 2013 at 7:16 am

    #1629522

    restore database [db_name] from disk = 'location\.bak' with replace

  • July 3, 2013 at 7:20 am

    #1629524

    Please do not worry, thanks anyways, I did the task as below,

    RESTORE DATABASE XYZ FROM DISK = 'C:\XYZ.BAK'

    WITH REPLACE

    GO

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

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