SQL server
Hi all,
Could any one please help me on below error - Differntial Backup is getting failed.
OS- Windows 2003 Enterprise Edition - 32 bit
Physical server
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 24/11/2009
Time: 12:17:50 AM
User: N/A
Computer: KNPC
Description:
SQL Server Scheduled Job 'Databases - DIFF Backup Plan' (0x6A705D374EBF7142AC99D60D89ED15DF) - Status: Failed - Invoked on: 2009-11-24 00:05:02 - Message: The job failed. The Job was invoked by Schedule 221 (Daily, Except Sunday). The last step to run was step 2 (DIFF Backup of ALL Databases).For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 24/11/2009
Time: 12:17:46 AM
User: KNPC\KNWWsql
Computer: KNPC
Description:
18210 :
BackupMedium::ReportIoError: read failure on backup device 'VDI_F5047433-F004-4C1D-A6C4-F5427DC53656_1'. Operating system error 995(error not found).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 22 47 00 00 10 00 00 00 "G......
0008: 06 00 00 00 4a 00 55 00 ....K.N.
0010: 4d 00 42 00 4f 00 00 00 P..C....
0018: 00 00 00 00 ....
Thanks,
Bala.- 已移動Raymond-LeeMSFT2009年11月26日 上午 08:28Admin issue (From:SQL Server Analysis Services)
解答
From the error message it is evident that you are taking a backup using SQLVDI. Could you please check if the SQLVDI dlls are updated as mentioned in the following articles:
934396 FIX: Error messages and an event may be logged when you use the Virtual
Device Interface in SQL Server 2005 or in SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;934396
935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;935465
If the backup still fails, then try using the SIMPLE.EXE from http://cid-b15bef95ff768c33.skydrive.live.com/self.aspx/.Public/simple%7C_EXEs.zip and check if you can backup a test database on the server. The parameter usage can be found out using:simple /?
This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL- 已提議為解答Sandra Mueller 2009年12月10日 下午 02:36
- 已標示為解答Jonathan KehayiasMVP, 版主2009年12月17日 下午 02:50
所有回覆
- I recommend reposting in the Backup Forum -- http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/threads
- Try out the backup command manually see if works from Command Prompt.
Checkout the related link:
SQL Server 2005 Practical Troubleshooting
http://searchsystemschannel.techtarget.com/generic/0,295582,sid99_gci1247521,00.html
Let us know if helpful.
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com - Thanks i will do that.
Bala. - Have you created a full backup before trying to make the differential backup.
From the error message it is evident that you are taking a backup using SQLVDI. Could you please check if the SQLVDI dlls are updated as mentioned in the following articles:
934396 FIX: Error messages and an event may be logged when you use the Virtual
Device Interface in SQL Server 2005 or in SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;934396
935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;935465
If the backup still fails, then try using the SIMPLE.EXE from http://cid-b15bef95ff768c33.skydrive.live.com/self.aspx/.Public/simple%7C_EXEs.zip and check if you can backup a test database on the server. The parameter usage can be found out using:simple /?
This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL- 已提議為解答Sandra Mueller 2009年12月10日 下午 02:36
- 已標示為解答Jonathan KehayiasMVP, 版主2009年12月17日 下午 02:50
