Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: how to backup database on linked server?

    Do you know how to back up a database using a linked server? If the name of my linked server is "SERVER1", how would I change the following backup statement to backup the database running on SERVER1, FROM SERVER2?

    BACKUP DATABASE database1 TO DISK = '\\\backup\database1.bak'

    To clarify, I want to run this statement from SERVER2, to backup the database on SERVER1.

    Thanks for any help you can provide.

  2. #2
    Join Date
    Jul 2002
    Village, MD

    Re: how to backup database on linked server?

    You can create stored procedure on linked server and fire it from your server.

Posting Permissions

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