rashian
Contributor
Contributor

SQL error while creating snapshot

My ESX cluster is on V3.5.0, build 130756 and my SQL VMs are on MS SQL2005 32bit system. I notice some SQL errors in event log as below. Check the time and found I was creating snapshot. I have 5 SQL servers and 2 of them have this error but 3 are OK. I have run DB check and SQL is fine. It looks like SQL failed to access/write to disk I/Q, to VMs. Any body can help on this?

Thanks

Chris

"2009-02-25 21:00:09.30 spid3s Error: 17053, Severity: 16, State: 1.

2009-02-25 21:00:09.30 spid3s LogWriter: Operating system error 1784(error not found) encountered.

2009-02-25 21:00:09.32 spid3s Write error during log flush.

2009-02-25 21:00:09.32 spid52 Error: 9001, Severity: 21, State: 4.

2009-02-25 21:00:09.32 spid52 The log for database 'SCCM' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

2009-02-25 21:00:11.28 spid20s SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

2009-02-25 21:00:13.86 spid20s SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

2009-02-25 21:00:13.87 spid20s SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

2009-02-25 21:00:13.92 spid20s Starting up database 'SCCM'.

2009-02-25 21:00:15.61 spid20s 1459 transactions rolled forward in database 'SCCM' (6). This is an informational message only. No user action is required.

2009-02-25 21:00:16.14 spid20s 0 transactions rolled back in database 'SCCM' (6). This is an informational message only. No user action is required.

2009-02-25 21:00:16.14 spid20s Recovery is writing a checkpoint in database 'SCCM' (6). This is an informational message only. No user action is required.

2009-02-25 21:00:16.31 spid20s CHECKDB for database 'SCCM' finished without errors on 2009-01-19 16:41:44.850 (local time). This is an informational message only; no user action is required."

0 Kudos
1 Reply
Lightbulb
Virtuoso
Virtuoso

If not already applied you may want to install the post SP2 VSS rollup package

http://support.microsoft.com/kb/940349

Fixes a number of VSS issues on Windows 2003 post Service pack 2. The Snapshot process uses OS VSS subsystem (SQL has it own VSS writter also)

0 Kudos