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 |
|
kpatil
Starting Member
1 Post |
 Posted - 2007-08-08 : 06:52:42
|
| We have two sql server database, one is online(say A) and the other is offline(standby database say B).We usually take export of database A apply it on the database B. As both the server are not at same location, the process takes a lot of time. Please tell me way by which i can reduce the time.Also let me know if there is a way by which I can capture the DDL and DML statement executed during the day and then apply these statement on the offline database..Kindly help..Thanks in advance..Kaustubh.. |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-08-08 : 10:01:22
|
| export the DataBase?? Maybe, you are referring to exporting the data?I will use replication to transfer the data.I will use SQL profiler to capture the DDL and DML.=============================http://www.sqlserverstudy.com |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-08 : 10:38:36
|
| Can you get away with differentials instead of full?if not probably log shipping is the easiest solution.Code it yourself rather than the MS version.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Capturing DDL and DML.