Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71

    Unanswered: 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 help

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It'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...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    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
    Last edited by Ruprect; 03-11-04 at 12:56.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •