SQL Server Performance

Copy-only backup

Discussion in 'SQL Server 2008 General DBA Questions' started by klehonia, Jan 28, 2010.

  1. klehonia New Member

    Hi, i have a sql 2008 server can i schedule a full backup job with copy-only option?
    Thank you in advance.
    klehonia, Jan 28, 2010
    #2

  2. preethi Member

    Create a job from UI (Under SQL Server Agent -> Jobs -> new job) and add a TSQL step with this code
    BACKUP DATABASE Sales TO DISK = 'D:MyDocSales.bak' WITH COPY_ONLY
    Now Schedule the job.
    You may need to add some house keeping tasks of cleaning the old files or add INIT operation.
    For more information on backup, check BOL on BACKUP.
    preethi, Jan 29, 2010
    #3

Share This Page