Linked Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Linked Server

Author

Topic

msrs

32 Posts

Posted - 2007-07-03 : 04:27:00

Hi all,
Using Linked server how to restore a database from one server to another server.Explain Briefly.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-03 : 04:33:26

Linked server has nothing to do with RESTORE.
You can however use a linked server to select values from another server and use the values to either

1) Create a new table with SELECT INTO
2) UPDATE existing table
3) Insert values in an existing table

Peter Larsson
Helsingborg, Sweden

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-03 : 11:14:06

Get db backup file from source server and restore it with 'restore database' on target server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources