Viewing 5 posts - 1 through 5 (of 5 total)
The logfile 'was' over 220gb in size. Thankfully, I've managed to shrink it back to 20gb and recovery now occurs in about 60 seconds...quite an improvement!
Next I will look at...
October 16, 2011 at 5:26 pm
About VLF's...frighteningly, I ran dbcc loginfo and it returned over 833,000 rows!
Could this be contributing to recovery times and how do I get it cleaned up??
October 15, 2011 at 11:03 am
That's fantastic! Thanks very much!
October 14, 2011 at 10:28 am
All fantastic replies, thanks very much!
One note kind of irks me though...the one about maintaining the same drive structure
Currently, the SQL server has all its files stored in named junctions....
October 14, 2011 at 9:55 am
About the recovery time, we typically will reboot on the weekend to perform updates when there are no users in the system. However, it always ends up being 2-3 hours...
October 14, 2011 at 9:48 am
Viewing 5 posts - 1 through 5 (of 5 total)