database logs for sharepoint grows to big in mirroring state
-
I have a sharepoint 2010 platform with Database mirroring. The log files have grown to big in the region of 30GB for 5 of the content databases. is there a script that i can run to bring the database logs sizes down and at thesame time not break the mirroring. my databases are in Full recovery mode already and i make 1 full backup and 2 trans logs backup daily. Regards
-
I have a sharepoint 2010 platform with Database mirroring. The log files have grown to big in the region of 30GB for 5 of the content databases. is there a script that i can run to bring the database logs sizes down and at thesame time not break the mirroring. my databases are in Full recovery mode already and i make 1 full backup and 2 trans logs backup daily. Regards
That's a SQL-Server issue. Set the recovery-modell for each sharepoint databse to simple instead of full. In the full modell every transaction is saved, so you rerole every single action done after the database is set up. That's not nessassary. I backup the databases regularly, so no reverse of every transaction since the initial start of the sharepoint server farm is needed. Ask you SQL-Server guru or chance it yourself in the database-options.
Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.