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.
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. |
|
|
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. |
|
|
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. |
|
|
|
|
|