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

afsi

Newbie

Join Date: Oct 2009

Posts: 1

#1: Oct 5 '09

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\<database_name> from disk="backup_file_in_Server_2"

can someone help me with the right command?

Thanks a lot,

« previous question | next question »

Similar Microsoft SQL Server bytes

backup/restore of Tables ONLY (please) (answers)
Consolidating MySQL Servers (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.