Results 1 to 2 of 2

Thread: SQL 2000 backup to a different server

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Question SQL 2000 backup to a different server

    Does anyone know how to save a SQL 2000 backup on another SQL 2000 server?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can run BACKUP to a network share, and that network share can be in another SQL server.

    For this you must run MSSQLSERVER service account with a domain user account with write permission in the share.

Posting Permissions

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