Asger Blond
ab-mi at post3.tele.dk
Mon Jan 18 15:20:11 CST 2010
BACKUP DATABASE <dbname> TO DISK = '<path and file-name for backup>' WITH COMPRESSION Asger -----Oprindelig meddelelse----- Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af jwcolby Sendt: 18. januar 2010 21:40 Til: Dba-Sqlserver; VBA Emne: [dba-SQLServer] 2008 backup / restore scripts I obtained a developer copy of SQL Server 2008, which has full backup / restore with compression if I understand correctly. I had been using Idera's SQL Safe free version but that is no longer free. Of course now all of my backups are locked away in a version of a program that I can no longer use. Free is only free until it's not, whereupon it is a liability. Sigh. Anyway... I am wondering if anyone has a stored procedure that will use the 2008 built-in backup to do a full backup with compression. I built a C# program to use the Idera scripts to do my backups and restores. I am hoping that I can get a similar native 2008 stored procedure that I can call to do the same thing. -- 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