Monthly Archives: June 2009

Copy only backups another great addition

Posted on June 9, 2009 by

A welcome addition to SQL 2005 and above is the inclusion of the COPY_ONLY clause to the BACKUP statement. http://msdn.microsoft.com/en-us/library/ms191495(SQL.90).aspx This overcomes the long time problem of breaking the backup chain for your automated backup jobs when taking adhoc backups. … Continue reading →

Posted in backup, sql, SQLServerPedia Syndication