May 3, 2010 at 2:08 am
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 ?
May 3, 2010 at 5:54 am
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!
May 3, 2010 at 9:14 am
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
May 8, 2010 at 2:48 pm
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" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply