SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio
- by user102718
We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark the "copy-only" flag in Management Studio they will mess up the Tivoli's backups (we are running our databases in FULL-recovery mode).
Is there a way to set the default value of the Copy-Only flag to true in the Management Studio's "Back Up Database"-window?