But just to be sure, if you have multiple roles checked, db_owner still trumps them all ?

More gas for the fire. Four hour transaction log backups. I am assuming data loss of 4 hours or less is acceptable which is amazing to...

ZZartin, no they are not doing anything for the size to fluctuate or have they even asked or monitored the current machines they are placing these maintenance plans on.

Gila I agree. Unfortunately at this point I am just a cog. Where I was orginally we had many hats and one of mine was SQL DBA. ...

Yes. Its the Shrink Database task under the Maintenance plan.

No rational I can see. Its actually part of a maintenance plan they push out to all the servers. I am trying to get more information on why...

I hope some people were a little tipsy when they got this question wrong. I like the real easy quick questions every once in awhile

Great question and great information. Always good to learn something new or re-learn the forgotten!

Great article and something i need to put in place in my environment. We are using Idera SQL Safe to perform the backups so I know at a moments...

I completely agree with that many users. Completely impractical though it probably could be scripted and not be that painful. 🙂

Groups are definitely the way to go...

I dont exactly agree with you. We have strickly defined groups for our DBA's, developers etc. Users do not go into those groups without upper management...

LOL Are you talking IDERA or Red Gate? My experience with Idera has all been out of Texas and at Tech Ed in New Orleans. Red Gate I...

Understood. Though its my experience that Sharepoint databases do not compress well. It the Office documents etc that just do not compress that Sharepoint stores.. There...

Call who up and why?

Well we did end up purchasing IDERA and I am in the process up setting it up. So far so good with no problems. Interface is intuitive and...