How can I restore a database remotely from a different server?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • afsi
    New Member
    • Oct 2009
    • 1

    How can I restore a database remotely from a different server?

    Hi All,

    I have space issue in one of SERVER_1 in which i need to refresh a database.

    I need to run the restore command from SERVER_2 and be able to refresh my database in SERVER_1.

    How can I use the command of:

    Restore database "\\Server_1\<da tabase_name> from disk="backup_fi le_in_Server_2"

    can someone help me with the right command?

    Thanks a lot,
Working...