Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

Usage of SQL Server Management studio is obligatory? Prepare a database backup SQL script with all necessary options (BACKUP DATABASE ... WITH COPY_ONLY) and create a shortcut starting sqlcmd utility with this script for this consultant.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.