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