Home Forums Programming General Can you compare an older SQL Server Snapshot to a newer one and recreate any changes made? RE: Can you compare an older SQL Server Snapshot to a newer one and recreate any changes made?

  • If you are restoring over an existing database you need to specify WITH REPLACE. Typically when restoring a database on a different server the RESTORE command will look something like this:

    RESTORE DATABASE [DatabaseName] FROM DISK = 'Backup Path' WITH

    MOVE 'datafile1' TO 'data file path\physical_file_name.mdf',

    MOVE 'logfile' TO 'log file path\physical_file_name.ldf',

    REPLACE /* only needed if the database already exists */

    Thanks I will give this a try. When I type out the MOVE command, do I type the actual name of the datafile and logfile after MOVE or do I type "datafile" like you have above? (might be a dumb question but I am trying to get the game-plan for this migration well documented)