Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Question Unanswered: [MSSQL7] Backup on network drive

    Hi there,

    Does anyone know if it's possible to perform a MSSQL7 database backup on a network drive instead of the local drives ?

    ...and if yes, how to proceed ?

    It seems to be possible under MSSQL2000.

    Many thanks for your help in advance,

    Matt

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Each MS-SQL device must be know as a local disk to control the IO writes, and a dump device follow this rule

  3. #3
    Join Date
    Feb 2004
    Posts
    7
    many thanks for this answer ;o)

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by fadace
    Each MS-SQL device must be know as a local disk to control the IO writes, and a dump device follow this rule
    It is not a true:

    backup DATABASE database
    to disk ='\\networkserver\BACKUP\database.bak'

  5. #5
    Join Date
    Feb 2004
    Posts
    7
    hu interresting, gonna have a try with this !! thanks !!

    is there no read/write error risks ? I mean, if we exclude the network transmission problems, of course.

  6. #6
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by mattoo
    hu interresting, gonna have a try with this !! thanks !!

    is there no read/write error risks ? I mean, if we exclude the network transmission problems, of course.
    If someone cuts a network cable it should be a problem but no more.

  7. #7
    Join Date
    Feb 2004
    Posts
    7
    Fine. Many thanks again for your help

Posting Permissions

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