Forum Replies Created

Viewing 15 posts - 451 through 465 (of 629 total)

  • RE: Prevent backups on C:\ drive?

    kevaburg (10/1/2013)


    Kurt W. Zimmerman (10/1/2013)


    I think the resolution is more a function of control. As a DBA restrict access to those developers who don't at by the rules. Make them...

  • RE: Prevent backups on C:\ drive?

    Kurt W. Zimmerman (10/1/2013)


    I think the resolution is more a function of control. As a DBA restrict access to those developers who don't play by the rules. Make them come...

  • RE: Prevent backups on C:\ drive?

    Yelena Varshal (9/30/2013)


    Anyone tried to create a trigger on a system table?

    Could we do Instead of (or other type of) trigger on [msdb].[dbo].[backupmediafamily] ? The backup location is inserted...

  • RE: Prevent backups on C:\ drive?

    kevaburg (9/29/2013)


    Jeffrey Williams 3188 (9/29/2013)


    In addition to which drive backups are performed - I really need to be able to block someone from taking native backups on some of my...

  • RE: Prevent backups on C:\ drive?

    Jeff Moden (9/29/2013)


    andrew gothard (9/27/2013)


    I'm a DBA.

    I'm not paid to solve problems. I'm paid to prevent them.

    I absolutely love that. Well said.

    Cheers mate. I think I'm...

  • RE: Prevent backups on C:\ drive?

    crmitchell (10/1/2013)


    assuming your c: drive is only used for the OS could you use disk quotas in windows to limit the amount of disk space visible such that attempting to...

  • RE: Prevent backups on C:\ drive?

    kevaburg (9/28/2013)


    Kurt W. Zimmerman (9/27/2013)


    I find this question somewhat puzzling. All of my backups go to a designated backups folder. I have never created a backup in an...

  • RE: Prevent backups on C:\ drive?

    kevaburg (9/28/2013)


    Kurt W. Zimmerman (9/27/2013)


    I find this question somewhat puzzling. All of my backups go to a designated backups folder. I have never created a backup in an...

  • RE: Prevent backups on C:\ drive?

    kevaburg (9/28/2013)


    The only thing I can think of off the top of my head this:

    There has to be a user executing the backup job. You could start by preventing...

  • RE: Prevent backups on C:\ drive?

    kevaburg (9/28/2013)


    Kurt W. Zimmerman (9/27/2013)


    I find this question somewhat puzzling. All of my backups go to a designated backups folder. I have never created a backup in an...

  • RE: Prevent backups on C:\ drive?

    Yelena Varshal (9/27/2013)


    Well, if you are not up to chocolate cake and you are paid to prevent problems:

    - send me the name of the company where they do that

    - set...

  • RE: Prevent backups on C:\ drive?

    Yelena Varshal (9/27/2013)


    Andrew,

    SQL Server 2000 does have server traces. "Catch them all..." with setting a trace on Backup Database statement - text data like 'Backup Database". Then charge a chocolate...

  • RE: Prevent backups on C:\ drive?

    Yelena Varshal (9/27/2013)


    Just curious what SQL Server version you are using?

    2008 and 2012 have Policy Management under Management. I am sure you can find something there to limit Backup statement...

  • RE: Prevent backups on C:\ drive?

    Grant Fritchey (9/27/2013)


    Yeah, I think the best mechanism is through security. You can't even set up a trigger on something like this.

    I thought about setting backup operator permissions to disallow...

  • RE: Prevent backups on C:\ drive?

    Kurt W. Zimmerman (9/27/2013)


    I find this question somewhat puzzling. All of my backups go to a designated backups folder. I have never created a backup in an unwanted...

Viewing 15 posts - 451 through 465 (of 629 total)