Backup Problems SCCM07 + SQL2005sp2
SCCM 2007 SP1 R2 installed on w2k8 x64 Server with SQL 2005 SP2
is it possible youre Backup are not realy finishd, so you have the *.mdf and *.ldf in normal File, but is it possible that dosnt work when you need some restore, so check youre Backup.log
smsbkup.log
After BackupComplete SQL Writer status = FAILED_AT_FREEZE. SMS_SITE_BACKUP 04.05.2010 23:22:11 11480 (0x2CD8)
Error: VSS_E_WRITERERROR_NONRETRYABLE. Error Code = 0×80’042’3f4. SMS_SITE_BACKUP 04.05.2010 23:22:11 11480 (0x2CD8)
After BackupComplete SMS Writer status = STABLE. SMS_SITE_BACKUP 04.05.2010 23:22:11 11480 (0x2CD8)
05/04/10 23:22:11 – backup completed. SMS_SITE_BACKUP 04.05.2010 23:22:11 11480 (0x2CD8)
vssadmin list writers
Writer name: ‘SqlServerWriter’
Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
Writer Instance Id: {fe722e7e-b409-4f2c-be52-39afaa6d0579}
State: [9] Failed
Last error: Non-retryable error
Eventviewer Log:
SQLVDI: Loc=WaitForResource. Desc=Partner process aborted. ErrorCode=(0). Process=2468. Thread=11608. Server. Instance=MSSQLSERVER. VD=Global\{EBC4389F-7BAE-4AB4-BFA3-FC8E51B3A378}1_SQLVDIMemoryName_0.
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2468. Thread=11608. Server. Instance=MSSQLSERVER. VD=Global\{EBC4389F-7BAE-4AB4-BFA3-FC8E51B3A378}1_SQLVDIMemoryName_0.
BACKUP failed to complete the command BACKUP DATABASE SMS_P02. Check the backup application log for detailed messages.
BackupVirtualDeviceFile::PrepareToFreeze: failure on backup device ‘{EBC4389F-7BAE-4AB4-BFA3-FC8E51B3A378}1′. Operating system error 995(error not found).
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Native Client
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3271
Error state: 1, Severity: 16
Source: Microsoft SQL Native Client
Error message: A nonrecoverable I/O error occurred on file “{EBC4389F-7BAE-4AB4-BFA3-FC8E51B3A378}1:” 995(error not found).
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=2936. Thread=3696. Client. Instance=. VD=Global\{EBC4389F-7BAE-4AB4-BFA3-FC8E51B3A378}1_SQLVDIMemoryName_0.
http://support.microsoft.com/kb/934396
