Home Forums SQL Server 2012 SQL 2012 - General 92% free space - will shrink result in faster backup/restore RE: 92% free space - will shrink result in faster backup/restore

  • Shrinking the database in this case is ok: you need it, do it.

    Backups do not copy empty pages, so the backup process itself will not be any faster.

    If you need faster backups/restores you have some options:

    * compress it (works also in standard edition)

    * use a different backup strategy (filegroup backups for instance)

    -- Gianluca Sartori