144 reputation
6
bio website troymi.gov
location Troy, MI
age 38
visits member for 4 years, 10 months
seen Sep 5 at 13:11
.Net Programmer / DBA for the City of Troy, MI

Feb
16
awarded  Critic
Feb
16
accepted Prevent Non Copy Only Backups on SQL Server
Feb
16
comment Prevent Non Copy Only Backups on SQL Server
I'm liking this idea... so, make them not a backup operator, but have the script impersonate a backup operator and perform the backup for them.. I guess this is probably the best solution..
Feb
16
comment Prevent Non Copy Only Backups on SQL Server
Indeed... so, if we have issues with out database that a vendor needs to look at, it is very common for the vendor to request a backup. it <does> tax the server, but it is an acceptable slowdown for the /possibility/ of whatever issue we're working with to get fixed. (: I agree that in an ideal world I'd only let the DBA take backups, but I'm not always available to do that.
Feb
15
asked Prevent Non Copy Only Backups on SQL Server
Aug
23
comment SQL Server 2008 Policies: Email on Failure
Thanks... here's an article about it: msdn.microsoft.com/en-us/library/bb510667.aspx
Aug
23
accepted SQL Server 2008 Policies: Email on Failure
Aug
23
asked SQL Server 2008 Policies: Email on Failure
Apr
15
awarded  Supporter
Apr
15
accepted SQL Server Log File Size Management
Apr
15
awarded  Student
Apr
15
awarded  Editor
Apr
15
comment SQL Server Log File Size Management
I read that blog entry. They didn't really address the issue of whether or not a big log file is necessarily bad. I know that shrinking is a very expensive operation and this would be done during "downtime" or at least slow time..
Apr
15
revised SQL Server Log File Size Management
added 77 characters in body
Apr
15
asked SQL Server Log File Size Management
Apr
14
awarded  Scholar
Apr
14
accepted Changing Recovery Model in Replicated Database
Nov
18
asked Changing Recovery Model in Replicated Database
Nov
18
awarded  Autobiographer