Windows Backup failed as another backup or recovery is in progress.
Posted
by remunda
on Server Fault
See other posts from Server Fault
or by remunda
Published on 2010-02-04T08:29:57Z
Indexed on
2010/03/13
8:05 UTC
Read the original article
Hit count: 910
Hi,
i have set up backup schedule on our server. SQL Server 2008 to 01:00am on windows server 2008 R2 to 4:00am. Sql backup runs well, but system backup ends sometimes with error.
The error is : http://technet.microsoft.com/en-us/library/dd364768%28WS.10%29.aspx
I mean, that is caused by SQL Server, because it unexpectedly runs backup.
this is from sql server log (it runs for every database):
Date 4.2.2010 4:00:21 Log SQL Server (Current - 29.1.2010 23:25:00)
Source spid72
Message I/O is frozen on database master. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
and
Date 4.2.2010 4:00:24 Log SQL Server (Current - 29.1.2010 23:25:00)
Source Backup
Message Database backed up. Database: master, creation date(time): 2010/01/29(23:25:32), pages dumped: 370, first LSN: 859:56:37, last LSN: 859:80:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{17B91D5C-9968-4D11-A7F1-1A31523D32F0}25'}). This is an informational message only. No user action is required.
My questions is:
Why runs sql backup with windows backup? How can i dissolve this that errors?
Thank you a lot.
© Server Fault or respective owner