Richard,

thankyou for taking the time to produce these informative articles.

The TSQL code for deleting and modifying the proxy account seems to have gone missing?

It is also worth noting that a...

just check your growth factors so that it doesn't become a problem if there is any likleyhood the log will grow further.

you don't say how big the log file is but 700+ is on the high side.

look at recovery times for the database on a server restart or onlining the database...

thanks for posting, this will get a wider audience if you submit it to the scripts section.

Welsh Corgi (1/20/2012)

I take it that you are going to tell me that it can't be done if the SSIS...

you store your packages in the filesystem don't you?

You can script that job out and edit server details. you just need to separately deploy the SSIS package itself

Unless you have a lot of maint plans I wouldn't bother scripting them out, they are very server specific.

IF you have a DR setup for a server supporting multiple databases...

you haven't specified the full path to the backup so SQL is presuming its in the default directory. I presume its somewhere else.

Are you trying to move the database files...

The resource database is NEVER updated, and is therefore read only. It just contains metadata and system objects.

the only time it ever changes is when you patch SQL, and then...

thats as expected

pleasure

Eric, thats a big question, there are only rules of thumb, but if your recovery times are too long, thats a clue its too high. I would say the number...

IMHO, I think a potential issue with introducing reputation points at this stage, and Gus touches on it, is that people who already have a reputation would naturally garner the...

OK, 8000 vlfs in 2GB is a lot, I suspect your current growth factor for the log is 1MB, leading to fragmentation,

You need to shrink your log file right down,...