Sunday, March 11, 2012

Backup Database at different place

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