SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to copy database from one server to other
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cplusplus
Aged Yak Warrior

540 Posts

Posted - 04/25/2013 :  09:28:07  Show Profile  Reply with Quote
How to copy database from one server(server1) to other(Server2).

In both places database exists, i want to over write.

Since teh db1 is available on both servers.

Server1.db1 is production based, server2.db1 is dev based.

They both are on different servers.

Thanks a lot for the helpful info.

James K
Flowing Fount of Yak Knowledge

3706 Posts

Posted - 04/25/2013 :  10:25:13  Show Profile  Reply with Quote
The simplest and most straightforward would be to backup the database on the source server and restore it overwriting the existing one on the target server.
Go to Top of Page

cplusplus
Aged Yak Warrior

540 Posts

Posted - 04/25/2013 :  11:22:00  Show Profile  Reply with Quote
I can manually do that, but is there a way to automate the process, to copy the db on a weekly basis via sql agent?

Thanks a lot for the helpful info.
Go to Top of Page

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 04/25/2013 :  13:04:53  Show Profile  Reply with Quote
One of the best as fastest ways to do this, if you have the infrastructure, is to use VSS (Volume Shadow Copy Service) to shapshot the disk. This is like five clicks and done.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000