Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unanswered: SQL 2K Dumps via Network

    Hi all,

    I've read that the SQL dump can only be done directly into the local server. Is there a way to put directly the dump into another server via the network (not copying it but writing it during the process of backup).
    Any help much apreciate.

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Its not advisable to backup directly to a network share rather take a local backup and copy the file indeed.

    BACKUP DATABASE Foo TO DISK = '\\server\share\file.bak' WITH INIT

    Backup performance tuning : http://www.sql-server-performance.co...ore_tuning.asp
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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