Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520

    Unanswered: SQL Server BACKUP

    I am trying to create a COPY_ONLY backup of a SQL Server database but have not been able to find how to define the backup device. Here is the syntax from BOL:
    BACKUPDATABASE SAC_PROD TO<backup device>WITH COPY_ONLY
    Where SAC_PROD is the name of my database. But <backup device> needs to be changed to what?
    I have tried \\servername\folder\folder2\sac_prod_copy_only.bak and the same thing inside single quotes. But neither work. Could someone show me what I really need to put there?

    Thanks!
    Vic


  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    BACKUP DATABASE SAC_PROD TO DISK='\\servername\folder\folder2\sac_prod_copy_on ly.bak' WITH COPY_ONLY

  3. #3
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Thank You, Thank You, Thank You!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •