Post reply

Updating an existing SQL database with a new backup

  • October 22, 2013 at 1:52 am

    #281601

    Hi all,

    I have a database in SQL SERVER 2012. I receive a daily back up of the full database. My question is how do I update that existing database with the daily updated versions? Can I just go through the restore procedure (Tasks>Restore) and it will do the trick? Or Should I delete my existing database and then proceed to the restore session?

  • October 22, 2013 at 1:56 am

    #1660402

    Just restore over the existing database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 22, 2013 at 3:10 am

    #1660417

    Ok thanks GilaMonster!

  • October 22, 2013 at 4:59 am

    #1660438

    Just know that the restore operation completely replaces the existing database. It doesn't merge the two. If you have changes you've made to your copy of the database, they will be lost by the restore operation.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • October 22, 2013 at 5:08 am

    #1660444

    Thanks for pointing this out, Grant! Indeed, very important to know!

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

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