SQL2005 - Backup

   In 2005 Databases can be backed up without affecting the database, ie not adding the backup into the Restore List etc.

The transaction log is never truncated after a copy-only backup

This can be done using the COPY_ONLY option.

ie. BACKUP DATABASE [test1] TO DISK = 'F:\Backup\test1.bat'  WITH COPY_ONLY

Author	Message Share Topic Printable Version Delicious Digg Facebook Furl Google MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
uselesshippy Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20-January-2008 Online Status: Offline Posts: 2	Post Options Post Reply Quote uselesshippy Report Post Quote Reply Topic: SQL2005 - Backup Posted: 20-January-2008 at 09:54
	In 2005 Databases can be backed up without affecting the database, ie not adding the backup into the Restore List etc. The transaction log is never truncated after a copy-only backup This can be done using the COPY_ONLY option. ie. BACKUP DATABASE [test1] TO DISK = 'F:\Backup\test1.bat' WITH COPY_ONLY