kalczynski (9/16/2013)
Hi AllI have mirrored database with 2 Databases Motor and one witness. Size of one Database is 467 Mb, but transaction log is 64 GB. Model of backup - FULL
How to shrink this transaction log. Below is my proposal, but Im not a specialist (Is's correct ?):
1. Backup DB and Transaction Log
2. Remove mirroring from this DB
3. Shrink Transaction Log (but I don't know what happend, if I have set backup model to FULL) (change backup model to Simple ?)
4. Turn on mirroring
5. Set new policy in Maintanace Plan to backup Transaction Logs
thx for any help
Is the mirroring synchronized?, if so, just take a manual log backup and shrink it? Why is the log that big? when was the last time you did a log backup?.....you might want to do log backups more often to avoid this again.
Regards,
SQLisAwe5oMe.