Answered by:. Archived Forums. Sign in to vote. Hello everyone. Here is a log from said backup Thank you in advance!
Thursday, May 1, AM. Thursday, May 1, PM. Thanks so much for the help. In doing SQL backups So if we have a rogue backup running Additionally, will this profiler setup tell me what user is running said backups?
Any additional feedback? Submit and view feedback for This product This page. View all page feedback. In this article. You either have some third party tool or windows inbuilt backup mechanism running which is taking this backup. Now if you really want to find out the source of backup consult windows team or storage team and you would get a fair idea. If all the stakeholders say they do not have idea about the source of backup which is highly unlikely you can stop such backup from happening by disabling SQL Server VSS writer from Services.
Otherwise you must not and you should consult more regarding this with them. I searched info in Windows System Event log and I found this lines in the temporal period interested by the backup:.
So I guess that software is taking a snapshot of the machine every day I'm not an expert in this domain. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Can't find process that is creating backups Ask Question. Asked 6 years, 4 months ago. Are you sure one of you sysadmins didn't install some backup software that also grabs DB backups?
Perry Whittle. I've got this solved somewhat. Here's the explanation. The backup agent for disk file backups triggered something in the Volumne Shadow Copy VSS service that generates backup commands. Here's more detail. The VSS service can be used to perform live backups of databases or files while they are in use. I noticed that a point in time restore failed because of the Full back that did not have an accessable disk file.
The virtual backups are useless to me and wreak havoc on restores. Our intent is to run normal DB and log backups and move the files offsite using the backup agent.
0コメント