Moving a Database using code - 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

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Moving a Database using code

Author

Topic

StevenP
Starting Member

2 Posts

Posted - 2005-10-27 : 07:04:24

Hi All

Apologies for joining and instantly bothering you with a question but I am a bit stumped. I've searched the forums and haven't been able to find exactly what I need.

I have a Database on server 1 and I need to move it (or copy and delete the source) to server 2. I need to be able to do all of this, automatically using scripts that can be called from a C# application.

Is there any (easy-ish) way this can be achieved? I'm using Sql Server 2000 on Windows 2003 server machines.

Thanks in advance
Steven

nr
SQLTeam MVY

12543 Posts

Posted - 2005-10-27 : 11:56:27

Easiest is a backup, copy backup file and restore.
see http://www.mindsdoor.net/#Administration

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

StevenP
Starting Member

2 Posts

Posted - 2005-10-27 : 17:18:59

Thanks for your help nr. I will give it a go tomorrow.

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-28 : 07:13:28

Hi,

[url]http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9258[/url]

[url]http://vyaskn.tripod.com/moving_sql_server.htm[/url]

[url]http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7528[/url]

[url]http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6491[/url]

HTH

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources