SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Preventing NT AUTHORITY\SYSTEM to take backups


Preventing NT AUTHORITY\SYSTEM to take backups

Author
Message
Vasu-709835
Vasu-709835
Old Hand
Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)

Group: General Forum Members
Points: 387 Visits: 818
Hi All,

I gone the through msdb.dbo.backupmediafamily,msdb.dbo.backupset tables ,
I found that some one from NT AUTHORITY\SYSTEM taking backups.

But i cant delete or remove this User ,
How can i prevent "NT AUTHORITY\SYSTEM" to take backups ?
GregoryF
GregoryF
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3108 Visits: 885
Are you running SQL Server using a domain account or a local account?

More than likely you have it running as a local account.

NT Authority\System just does not take backups, you have a job scheduled somewhere to backup, and since SQL is likely running under the local account, that is what you are seeing.

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (52K reputation)

Group: Moderators
Points: 52098 Visits: 1917
Are you using a Symantec/Veritas product to backup the server? If so, it likely recognizes that there is a SQL Server on the system and is using the SQL Server methods to back up the databases (so that they are good backups). The Agent the product installs on said server typically runs as NT Authority\System (Local System if you look in Services). That would be my guess as to where the backups are coming from. And likely then you don't want to disable it without talking to your backup administrator.

K. Brian Kelley
@‌kbriankelley
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (124K reputation)SSC Guru (124K reputation)SSC Guru (124K reputation)SSC Guru (124K reputation)SSC Guru (124K reputation)SSC Guru (124K reputation)SSC Guru (124K reputation)SSC Guru (124K reputation)

Group: General Forum Members
Points: 124749 Visits: 18070
K. Brian Kelley (5/3/2010)
Are you using a Symantec/Veritas product to backup the server? If so, it likely recognizes that there is a SQL Server on the system and is using the SQL Server methods to back up the databases (so that they are good backups). The Agent the product installs on said server typically runs as NT Authority\System (Local System if you look in Services). That would be my guess as to where the backups are coming from. And likely then you don't want to disable it without talking to your backup administrator.


I too have seen this. In my case the backups were failing, the Symantec Management Console has a section for database backups. Ours attempted to backup to default path which didnt exist. We disabled it!!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search