Hi All!
I know that if is want to backup my db on the c: drive i do this
BACKUP DATABASE DBName
TO DISK = 'c:\isl_fs1\DBName.bak'
BUT HOW do I take this to the network. I tried
BACKUP DATABASE DBName
TO DISK = '\\isl_fs1\DBName.bak'
it doesn't work please helpIt'll be longer, slower, at risk of network blips, not portable
Dump locally, then copy...
What, you're drive is out of space?
That's a different problem...|||I agree
typically i would back up to disk and then use network backup software to come get it out of the shared folder that i backed it up into
however to directly backup to a network address
One method is to map a drive to a network location
ex
NET USE X: \\Server\Share
and then use sql backup.
Backup database northwind to disk=x:\backup.bkf
you should however use sp_adddumpdevice to map a backup location to a permanent device it cleans up the backup processes and gives you a fixed location to find all of your backups instead of temporary ones
No comments:
Post a Comment