September 23, 2011 at 8:20 am
We use XOsoft for our DR solution.
I was testing 'dbcc checkdb ('dbname') with all_errormsgs,no_infomsgs,physical_only' against one of our databases, when XOsoft issued the following error:
Event Type:Error
Event Source:CAXOsoftEngine
Event Category:Replicator
Event ID:2
Date:23/09/2011
Time:14:39:59
User:N/A
Computer:XXXXXX
Description:
Scenario id:: 468902275
Host:: 2
Host name:: XX.XX.XX.XX
Time:: 09/23/11 14:39:59
Type:: ERROR
Event ID:: ER00059
Message:: Unable to create undo file for remove event k:/folder1/filename.mdf:MSSQL_DBCC33[L:/XOSpool/spool_25000/468902275_2_undo/39184_0/del_39185.tmp]
Is it necessary to stop XOsoft prior to running DBCC CHECKDB?
September 23, 2011 at 8:25 am
You shouldn't have to stop any HA/DR product to run CHECKDB.
This looks like a bug in XOSoft that it doesn't cope with the NTFS alternate streams that CHECKDB uses by default. You should contact XOSoft.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 23, 2011 at 9:21 am
Thanks for the reply Paul.
I have been Googling this scenario for a while now, and I'm surprised that no-one else has mentioned coming across this issue in the past.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply