Home Forums SQL Server 2005 Backups Need info on DB Snapshots -- Restoring Differential Backups and Trans Logs RE: Need info on DB Snapshots -- Restoring Differential Backups and Trans Logs

  • GonnaCatchIT (11/1/2015)


    [Our DB size is 450 GB. Does copy DB copy the data as well or only the database objects.]

    Sorry, poor use of terminology, by "copy-database" I meant a database restored from a backup, so it would be the full database including all data and objects.

    [No , not using compressed backups. We dont have control over the DB servers, there is a different team that handles this]

    I suggest you ask the other team to turn on compressed backups, so that the transfer time, and restore, is as fast as possible.

    Sounds like just re-restoring the Full backup and then the latest Differential is what you need.