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 2008 Forums
 Transact-SQL (2008)
 How to copy database from one server to other

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2013-04-25 : 09:28:07
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-04-25 : 10:25:13
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

567 Posts

Posted - 2013-04-25 : 11:22:00
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
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2013-04-25 : 13:04:53
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
   

- Advertisement -