Backup Database using t-SQL
I am trying to backup my databases using T-SQL to a snapserver. However when I use the following
BACKUP DATABASE ca001 TO DISK = '\\snapaztar\sqlbackups\Great Plains'
I get a device error or device offline. I have checked an I can access the snapserver through the unc path specified.
[313 byte] By [
jstephens] at [2007-11-20 1:36:33]
# 2 Re: Backup Database using t-SQL
Thanks exterminator but I found out the problem. I didn't specifiy a backup name.
BACKUP DATABASE ca002 TO DISK '\\snapaztar\sqlbackups\greatplains\ca002.bak' WITH INIT
worked like a charm.
