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

    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 = '\\192.168.0.90\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.
    Tommy

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    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
  •