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 |
|
sqldbaa
Starting Member
32 Posts |
 Posted - 2008-02-13 : 05:16:27
|
| Hi,I have two servers, one is a production server and other is a testing server. Both theses server must be in sync.Please can anyone let me know how to synchronize these two servers(automatically) without replication.In particular i want databases, tables, views, users and stored procedures to be same in both the servers. If a table gets added/deleted/update on the production , the same must be done on testing server.Please help on doing this. Can i implement logshipping, will that help me.Please give a best solution.Thanks in advance |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-13 : 05:26:22
|
| Log shipping is practised basically for failover capability. You can schedule a job which will periodically restore backup of Production on Testing server.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sqldbaa
Starting Member
32 Posts |
Posted - 2008-02-13 : 05:38:01
|
| Thanks for the quick reply.Can you please help me in writing the script for backuping all databases and restore it across network. As i know to backup and restore database individually.Thanks in Advance |
|
|
|
|
|
|
Sync. two server(Production and testing)