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 >