|
Home > Archive > MS SQL Server > February 2006 > Unexpected Backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| michael 2006-02-09, 8:23 pm |
| Every morning at 8AM, my SQL Server 2005 produces some database backup that
is not a part of any "Job" or "Maintenance Plan". If you look in the Windows
NT Application browser, there is an Event: 1073760088, Source: MSSQLSERVER,
User: NT AUTHORITY\SYSTEM, Category: Backup, which occurs.
I have a few questions since it seems to conflict with some other concurrent
processes.
1) Where is this backup controlled from and how can I control the time that
it occurers?
2) Where does this backup go to and how can I use it?
--
Michael Hockstein
| |
| Andrew J. Kelly 2006-02-09, 8:23 pm |
| Backups don't occur by them selves. You must run a BACKUP command for it to
happen. This can be embedded in a job in SQL Agent or it can come from any
client that has the proper permissions to connect to the db and issue a
backup. Do you have 3rd party backup software such as BackupExec etc? Are
you sure there is no job kicking off at 8:00AM? You can run a trace to see
who is doing it pretty easily.
--
Andrew J. Kelly SQL MVP
"michael" <howlinghound@nospam.nospam> wrote in message
news:53678094-7BA1-40E8-A5F1- 841897E6D740@microso
ft.com...
> Every morning at 8AM, my SQL Server 2005 produces some database backup
> that
> is not a part of any "Job" or "Maintenance Plan". If you look in the
> Windows
> NT Application browser, there is an Event: 1073760088, Source:
> MSSQLSERVER,
> User: NT AUTHORITY\SYSTEM, Category: Backup, which occurs.
>
> I have a few questions since it seems to conflict with some other
> concurrent
> processes.
>
> 1) Where is this backup controlled from and how can I control the time
> that
> it occurers?
>
> 2) Where does this backup go to and how can I use it?
>
>
> --
> Michael Hockstein
| |
| michael 2006-02-10, 7:23 am |
| I do have a copy of Retrospect backup software but it does not backup the SQL
server. How do I run a trace (and of course I could just turn off Retrospect
to see if the unexpected backups stop)
--
Michael Hockstein
"Andrew J. Kelly" wrote:
> Backups don't occur by them selves. You must run a BACKUP command for it to
> happen. This can be embedded in a job in SQL Agent or it can come from any
> client that has the proper permissions to connect to the db and issue a
> backup. Do you have 3rd party backup software such as BackupExec etc? Are
> you sure there is no job kicking off at 8:00AM? You can run a trace to see
> who is doing it pretty easily.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "michael" <howlinghound@nospam.nospam> wrote in message
> news:53678094-7BA1-40E8-A5F1- 841897E6D740@microso
ft.com...
>
>
>
| |
| Andrew J. Kelly 2006-02-10, 9:23 am |
| This link should get you started. It may have more events than you need to
capture but it gives you the idea.
http://www.support.microsoft.com/?id=224587
--
Andrew J. Kelly SQL MVP
"michael" <howlinghound@nospam.nospam> wrote in message
news:79EBAB8C-B37B-4714-A6A6- BEA661F1F4E2@microso
ft.com...[color=darkred]
>I do have a copy of Retrospect backup software but it does not backup the
>SQL
> server. How do I run a trace (and of course I could just turn off
> Retrospect
> to see if the unexpected backups stop)
> --
> Michael Hockstein
>
>
> "Andrew J. Kelly" wrote:
>
|
|
|
|
|