September 2007 - Posts

• TSQL script to do backup like Maintenance Plans

  This is frequently asked question, both in forums, as well as in class: How can I though TSQL create new backup files for each backup and have date and time in the file names? The reason for above is most often that you want a higher degree of customization Read More... Posted Tuesday, September 25, 2007 6:20 PM by TiborKaraszi | 7 Comments Filed under: Backup, Maintenance

• COPY_ONLY backups and SSMS

  Here's a suprising one: SQL Server 2005 introduced the COPY_ONLY option of the BACKUP command. This is relevant for Database backups. The backup will not intervene with your differential backups (will not reset the DCM pages). Log backups. The backup Read More... Posted Saturday, September 15, 2007 9:52 AM by TiborKaraszi | 10 Comments Filed under: Backup