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 |
|
Sammcgold
Starting Member
5 Posts |
 Posted - 2006-02-22 : 18:07:28
|
| Hello,I am trying to investigate a way of applying transactions to a secondary database. My primary database server is a SQL 7.0, and I am wanting to apply all changes from this database to the secondary database server (SQL 2005). Am I best to use a restore (on the secondary) from a backup (of the primary)? Or is there a way of shipping the transaction logs from the primary -> secondary? Or is there a better way? (From what i have read / experimented, DTS on each version cannot connect with each other).Bear in mind that the size of data to be sent to the secondary server needs to be minimal as this is over an international (limited) connection.Any help would be much appreciated,Cheers |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-22 : 18:10:17
|
| In order to apply transaction logs, you must first start with a full backup of the primary. Once you have this starting point, you can then apply tlogs.Keep in mind that you must use WITH NORECOVERY or STANDBY modes to apply tlogs. When you are done applying them, then you can recover the database using WITH RECOVERY option.I would not use DTS to sync up a secondary server. Applying tlogs is the way to go.Tara Kizeraka tduggan |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-22 : 18:32:28
|
| if you could upgrade your SQL 7 system to SQL2K5 you could possibly use the database mirroring capability.-ec |
|
|
|
Sammcgold
Starting Member
5 Posts |
Posted - 2006-02-22 : 19:05:07
|
| Thanks Tara,That'll do the trick for me, much appreciated.Cheers,Sam |
|
|
|
|
|
|
Restore vs Transaction Log Shipping