SQL Server transaction log
I have 2 servers configured in a primary secondary model with transaction logs shipped from the primary to the secondary every 10 minutes. The log file on the primary is 32Gb. Is it possible to reduce this without breaking the log shipping? and if so what is the best way
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Log shipping and shrinking transaction logs
http://sqlblogcasts.com/blogs/davidwimbush/archive/2010/03/04/log-shipping-and-shrinking-transaction-logs.aspx
Log Shipping: question about secondary dB mode?
http://www.eggheadcafe.com/software/aspnet/32159831/log-shipping-question-ab.aspx
http://omaralzabir.com/how_to_setup_sql_server_2005_transaction_log_ship_on_large_database_that_really_works/
Shrinking Log File In Conjuction With Log Shipping
http://www.bigresource.com/MS_SQL-Shrinking-Log-file-in-conjuction-with-Log-Shipping-hpr3AcFP.html
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43966
http://sqlblogcasts.com/blogs/davidwimbush/archive/2010/03/04/log-shipping-and-shrinking-transaction-logs.aspx
Log Shipping: question about secondary dB mode?
http://www.eggheadcafe.com/software/aspnet/32159831/log-shipping-question-ab.aspx
http://omaralzabir.com/how_to_setup_sql_server_2005_transaction_log_ship_on_large_database_that_really_works/
Shrinking Log File In Conjuction With Log Shipping
http://www.bigresource.com/MS_SQL-Shrinking-Log-file-in-conjuction-with-Log-Shipping-hpr3AcFP.html
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43966
truncate does not shink the file size, but marks the space as unused within the file
shrink if your log contains free space and you want to free it
so do one then the other
CHECKPOINT first will make it possible to truncate
shrink if your log contains free space and you want to free it
so do one then the other
CHECKPOINT first will make it possible to truncate
ASKER
deisn't truncating break log shipping though?
You can make a full backup of database then the log file will be truncated after full backup.
ASKER
their is a full backup taken each evening of the datatbase, do i need to take one of the log fil - will this not break the log shipping though?
What's the size of this DB to begin with.. if you have a large Trn every 10 minutes then either there is something wrong or log-shipping is not suitable for this purpose and should choose replication ... if your tables have proper primary keys that are also suitable for replication purposes... otherwise depending upon your bandwidth .. you may not even get a chance copying the first Trn to the second server..
ASKER