Francisco Tapia
fhtapia at gmail.com
Thu Sep 9 15:20:24 CDT 2004
my experiance is that the backup file is about 1:1 to the db size. You can however backup to TAPE, that is fully supported by SQL Server. I understand your concerns for database backups.. I believe Light Speed has a product that backups and compresses and works inline w/ SQL Server... here is their URL http://www.imceda.com/default.asp?LeadSource=SQLServerCentralSiteSponsorship On Thu, 09 Sep 2004 13:41:13 -0400, John W. Colby <jwcolby at colbyconsulting.com> wrote: > Can anyone explain to me what SQL Server does when it backs up. I have this > largish database that I need to backup and I need to know if I need the same > amount of room for the backup as is used for the db itself, if compression > is used, how much it helps etc. > > 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 > > -- -Francisco