Sql databse restore to another server

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

Sql databse restore to another server

Author

Topic

kidaduo
Starting Member

45 Posts

Posted - 2008-05-22 : 10:30:21

Hi all,

I am planning to restore of a SQL 2000 Database on another server
can you folks tip me in the right direction with the SQL script to be used.

any help much appreciated

Much thanks in advance

Josephine

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-22 : 10:41:39

Check restore command in Books online. Use MOVE option.

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-05-22 : 11:22:38

Simply copy your backup file to the other server and restore, either via script or using enterprise manager, taking into consideration sodeep's suggestion.

Terry

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-22 : 23:12:07

Use 'with replace' option if target db name is different from source one.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-05-23 : 07:24:33

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101995

--
Lumbago

kidaduo
Starting Member

45 Posts

Posted - 2008-05-23 : 16:47:40

Thank you all for your suggestion.

Josephine