August 13, 2010 at 2:43 pm
On my client's production SQL-server, I created a small database for a one-time use.
Every day, SQL server generates an event to the Windows event log that this database has been backed up.
I've double checked the maintenance plan.
Any thoughts as to what is going on?
This is the windows event log entry:
Database backed up. Database: db_one, creation date(time): 2010/07/21(20:38:19), pages dumped: 1, first LSN: 11928:18490:37, last LSN: 11928:18506:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{458EDC23-26C2-4231-A005-1CE7BA1B0306}8'}). This is an informational message only. No user action is required.
and the SQL log at the same time-stamp:
Date8/13/2010 12:00:45 PM
LogSQL Server (Current - 8/13/2010 12:27:00 PM)
SourceBackup
Message
Database backed up. Database: dm_EMR, creation date(time): 2010/07/21(20:38:19), pages dumped: 1, first LSN: 11928:18490:37, last LSN: 11928:18506:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{458EDC23-26C2-4231-A005-1CE7BA1B0306}8'}). This is an informational message only. No user action is required.
August 14, 2010 at 12:42 am
And what did you find in the maintenance plan?
If this message is showng up daily in the logs, it means the database is being backed up successfully. Not sure what the problem is as this is just informational.
If the database is not in the maintenance plan, then there must be another job running that is backing it up. Check to see what is running at the time this backup message is logged.
August 16, 2010 at 2:25 am
If I am correct, your issue is as why this test database got backed up. Since you haven't cretaed any backup job/updated MP for this database.
To answer, just check all the Maintenance plans and their will be atleast one MP in which you have selected "All databases" under full backup tab. Thanks.
August 16, 2010 at 2:44 am
The fact that the device type is a virtual device suggests that your database is being backed up with a third-party utility such as DPM or NetBackup. If your server admins have access to SQL Server then it's possible that they have just ticked all boxes when setting up the tasks to back up the server.
John
August 17, 2010 at 2:49 pm
Thank you all for responding and I apologize to you all for being ambiguous.
Yes, I have not created any task/job/m.p. to back up that database and I cannot find one.
But someone at my client site may have enabled some third-party job and I will not look for that.
thanks again.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply