Link to home
Start Free TrialLog in
Avatar of Bestway IT
Bestway ITFlag for United Kingdom of Great Britain and Northern Ireland

asked on

MS Sql Server 2000 Log Shipping - taking too long

I Have Sql server which log ships the transaction log to a standby server used for reporting. I am presented with the following issue the transaction log is not consistent in size its output in between min 5mb to just over 1gb.
When the file is applied by the standby server from Saturday to Weds it extremely slow, but then it happens to speed reducing the out of sync time and by Thursday / Friday is fully operational
This issue is happening on weekly basis.

So far set a trace on DBCC TRACEON (3004, 3605, -1) to determine any errors, but none have been captured.
DBCC Checkdb (DB) takes too long to process in query analyser processed for 30 mins no results returned
DBCC loginfo (db) returns  561 rows which would indicate Vlf may not be an issue
The domain accounts on the server are permissions on the shared drive are correctly assigned, no hardware bottlenecks
The problem has started over the past month .
Any advice is appreciated
Avatar of knightEknight
knightEknight
Flag of United States of America image

Am I to understand that you are only applying the logs twice per week?  If so, can you not speed that up to once per day at least?
Avatar of Bestway IT

ASKER

The transactionlog is shipped on interval of 15 mins every day, the procedure is on a Sat the recovery model on the production server is set to simple then reindex all tables then change the recovery model back to full back up all databases with symantec veritas then start the log shipping on sunday morning at 04:00 from this point onwards the standby server is slow in appying the transaction logs whilst the log shipping is to intervals of 15 mins

 Hope that helps to understand the situation tanks you in advance
 
ASKER CERTIFIED SOLUTION
Avatar of VENKAT KOKULLA
VENKAT KOKULLA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial