Comments
Sort by recent activity
Hi,
When you're in the bulk-logged model, I think I'm right in saying that a log backup contains not only the transaction log entries that have occurred since the last log backup, but also any data pages that have been modified by bulk-logged operations.
This is necessary for log shipping to work - the point of bulk-logged is to allow some operations to happen without logging all the information needed to reconstruct them in the transaction log. Therefore, in order to be able to restore from such a system, you also need to back up that extra information (as determined by the BCM - bulk change map(s)).
In your case, I suspect you're changing ~58GB of data pages between backups, which accounts for the majority of the large transaction log.
Hope that helps,
Robert / comments
Hi,
When you're in the bulk-logged model, I think I'm right in saying that a log backup contains not only the transaction log entries that have occurred since the last log backup, but also any data...
Brian's KB suggestion of forcing 32-bit (even on a 32-bit server) I believe should fix it, though I haven't tried this myself for a while.
Rob / comments
Brian's KB suggestion of forcing 32-bit (even on a 32-bit server) I believe should fix it, though I haven't tried this myself for a while.
Rob
Hi,
The issue in the KB article Brian referenced does actually apply to 32-bit editions of Windows 2003 as well, so hopefully that should still solve your problem.
Thanks,
Robert / comments
Hi,
The issue in the KB article Brian referenced does actually apply to 32-bit editions of Windows 2003 as well, so hopefully that should still solve your problem.
Thanks,
Robert
I think technically we didn't need to, but the logic is - from what I remember - "If it's not explicitly running in WOW64 mode (i.e. forced to 32-bit), disable folder redirection".
I guess it's a slight bug, but not one that appears unless you're pre-SP1.
Rob / comments
I think technically we didn't need to, but the logic is - from what I remember - "If it's not explicitly running in WOW64 mode (i.e. forced to 32-bit), disable folder redirection".
I guess it's a s...
Hi,
I'm guessing you're running on Windows 2003 Server there, in which case could you check you have at least Service Pack 1 installed?
Thanks,
Rob / comments
Hi,
I'm guessing you're running on Windows 2003 Server there, in which case could you check you have at least Service Pack 1 installed?
Thanks,
Rob
Very well spotted - you're entirely correct there :-).
I've logged it as a bug, so hopefully that should get fixed before release.
Thanks,
Robert / comments
Very well spotted - you're entirely correct there :-).
I've logged it as a bug, so hopefully that should get fixed before release.
Thanks,
Robert
Hi,
I'm afraid it's not possible to change this at the moment, though it is something we've considered as a possible enhancement in the future.
The reason we haven't implemented this yet is that in a lot of the tests we've done, we're actually limited by the disk speed on both the SQL Server and the machine running data compare, so increasing the level of parallelism probably wouldn't help too much (and might even slow it down by causing the disk head to have to seek around a lot).
Thanks,
Robert / comments
Hi,
I'm afraid it's not possible to change this at the moment, though it is something we've considered as a possible enhancement in the future.
The reason we haven't implemented this yet is that in...
Now there's something I never knew you could do before! :-)
I also found I needed to unregister shfusion.dll (in C:\Windows\Microsoft.NET\Framework\v1.1.4322) before it took effect...
Cheers,
Rob / comments
Now there's something I never knew you could do before! :-)
I also found I needed to unregister shfusion.dll (in C:\Windows\Microsoft.NET\Framework\v1.1.4322) before it took effect...
Cheers,
Rob
Hi,
It's certainly something we'll consider for the future, but in SDC 6 you'll now be able to use the mappings you set up in the GUI projects - so you can set up the mappings there, then use them on the command line.
Hope that helps,
Robert / comments
Hi,
It's certainly something we'll consider for the future, but in SDC 6 you'll now be able to use the mappings you set up in the GUI projects - so you can set up the mappings there, then use them ...
Hi,
Thanks for the post - you can reverse the direction by double clicking on the arrow at the top of the main screen.
Thanks,
Robert / comments
Hi,
Thanks for the post - you can reverse the direction by double clicking on the arrow at the top of the main screen.
Thanks,
Robert