No worries, and no hurry on this stuff.

I'll likely review it next week and get you feedback.

No hurry.

If you want to write a separate one for a checklist, a short list that references the logs article, that's fine as well. Could always use more info here...

I tend to agree with Harry. You need to check how your hardware supports the additon.

For R5, it starts to add in the data and rebalance across all disks, which...

You should not need to shrink, as noted above. Set the log to the size that is needed between checkpoints, or for your largest transaction.

If it grows, check the replication...

sqldba_icon (12/29/2010)

---

Can you please give me some details like what performance hits will we come across or if you can point me to a article that would also be helpful....

Steve doesn't have horses. Steve's wife has horses, Steve loves...

Congrats, Gus

Good luck in the playoffs! I'll get prizes ready next week (or the next), depending on my schedule.

You want to set a specific size for your data files that allows for growth. You DO NOT want to depend on autogrowth as it creates physical fragmentation. Shrink created...

How are you logging into SQL Server (which account) and what are you running to unlock the account?

You might like to read this: http://www.mssqltips.com/tip.asp?tip=1175

Paging takes a little work in SQL Server

First, don't shrink. Not needed, reduces performance.

Second, the t-log backup schedule should be driven but your data loss/downtime SLA, and not necessarily be a once a day item in your...

Was this a PM or email from the SSC system? If so, please send me the account name.

It's junk mail, but there's nothing we can do but delete the account. If they want to keep adding them, we can only kill them when they are reported. I'll...

Joe,

enjoy the weekend.

Might be the end for me too, since a storm is forecast. Not sure we'll get it, but I'll be loading up stuff early today in case we...