asked on Logfile too big sql 2008r2
Hi
My logfile on my sql reporting server is 32 gig and causing other things to fail due to lack of disk space,...
What's the best way to approach this as it does need to be shrank very soon but I'm worried about having to do this.
My logfile on my sql reporting server is 32 gig and causing other things to fail due to lack of disk space,...
What's the best way to approach this as it does need to be shrank very soon but I'm worried about having to do this.
Microsoft SQL Server 2008Microsoft SQL ServerSSRS
Last Comment
Scott Pletcher
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Lee's right but why would you have a reporting database with full recovery model? Can't you set it to simple recovery model?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.