Import Export - 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)

Import Export

Author

Topic

vipulbhandari
Starting Member

2 Posts

Posted - 2006-08-06 : 05:49:44

Hi,

I wanted to have a copy of the database from the client's Server on my server.

what are the necessary steps can you please explain or suggest some tutorials/Links.

Thanks in advance

With Regards,
Vipul Bhandari
India

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-08-06 : 05:52:12

if you want to copy the entire database, just backup the database, copy to the target server and restore it.

Also read here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=How%20Backup%20works,What%20type%20of%20backup%20should%20I%20use,Backup