[dba-SQLServer] 2008 backup / restore scripts

jwcolby jwcolby at colbyconsulting.com
Mon Jan 18 14:40:19 CST 2010


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



More information about the dba-SQLServer mailing list