Transaction log backups to device

  • I have created a Backup Device on a separate server to my SQL 7 server. When using a Database Maintainence plan it does not give option to backup to my unc path created backup device. However going through tasks backup database it does. Confusing any ideas? Thanks in advance

  • To make the UNC notation work, you need to run:

    DBCC TRACEON(1807)

    This allows the SQL Server to understand the UNC notation.

    We run our backups to an NAS device and it works fine.

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply