July 8, 2009 at 3:55 pm
we have indexing jobs which keeps on increasing the log file for online index maintenance for our sql server 2005 instance , is there any way we can minimize the growth with out taking db in simple recovery mode , currently it is in full , does sort in tempdb option helps?
July 8, 2009 at 6:18 pm
This may not be the answer you are looking for but one solution is to perform log backups more frequently.
July 8, 2009 at 9:56 pm
Hello,
You might also find this thread of interest:-
http://www.sqlservercentral.com/Forums/Topic749688-146-1.aspx
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
July 8, 2009 at 11:25 pm
Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.
If you will put db into simple recovery mode you won't be able to restore point in time as well as in recovery data loss will be more. You will recover db till last full backup only.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:25 pm
Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.
If you will put db into simple recovery mode you won't be able to restore point in time as well as in recovery data loss will be more. You will recover db till last full backup only.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:26 pm
Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.
If you will put db into simple recovery mode you won't be able to restore point in time as well as in recovery data loss will be more. You will recover db till last full backup only.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:26 pm
Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.
If you will put db into simple recovery mode you won't be able to restore point in time as well as in recovery data loss will be more. You will recover db till last full backup only.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply