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?