HI, I have a sql 2005 box that needs to be mirrored .The server is configured to take transaction log backup and the file size comes to 2.5 gb to 3 gb and is scheduled once a day. How to calcullate the bandwidth required for this db to be mirrored between sites.Most of the transactions are happen at morning time ie uniform around 5 hours . If we calculate the log creation per minute it comes to 10 MB The calculation is {( 3*1024)/ (60*5) } So we need 10 mb /minute transfer rate .This is we calculate the bandwidth for the connection Thanks
Are you planning to use database mirriring or log shipping? If you are planning to use mirroring, make sure you have the right edition of sql server. In SE, asynchronous mirroring is not available. Why do you take transaction log daily intead of every 15/30/60 minutes?