[dba-SQLServer] is restore identical

Francisco Tapia fhtapia at gmail.com
Mon Sep 14 21:54:38 CDT 2009

it's been my experience that if you restore a database with for  
example 1gb of free extra space, the restore will give you that same  
free space, so if you don't have that much free space in the  
destination drive, then you will want to shrink the data files before  
you try your backup.

On Sep 14, 2009, at 11:21 AM, jwcolby wrote:

> When you use a utility to backup / restore, is the restore identical  
> to the backup, byte for byte?
> For example would the restore get rid of the "available free space"  
> or would it just restore that
> free space?
> -- 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com

More information about the dba-SQLServer mailing list