Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 How to transfer one SQL Server DB to another		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

CarKnee
Junior Member

USA
297 Posts
Posted - 16 October 2003 :  12:33:02  Show Profile  Visit CarKnee's Homepage
I need to copy a SQL Server DB to another server in a different facility and this process will need to be done weekly.

I do have Enterprise Manager, but I am not that familiar with its capabilities.

Can anyone suggest the best approach for this?

Thanks,
CarKnee

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 16 October 2003 :  19:01:25  Show Profile  Send ruirib a Yahoo! Message
Two obvious options (there are more, these look the easiest):

1. Backup the DB at one server, restore it at the other.
2. Use DTS to copy the database objects between the DBs, if you can connect to both.

Snitz 3.4 Readme | Like the support? Support Snitz too
Edited by - ruirib on 16 October 2003 19:01:53
Go to Top of Page

pweighill
Junior Member

United Kingdom
453 Posts
Posted - 17 October 2003 :  08:40:03  Show Profile
A thrid option is to "Detach database" and then "Attach Database" at the other server. (SQL Server 2000 Only)
Go to Top of Page

CarKnee
Junior Member

USA
297 Posts
Posted - 23 October 2003 :  11:44:49  Show Profile  Visit CarKnee's Homepage
I ended up creating a DTS package, task scheduler, a dtsrun to do it every night.

Thanks all
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07