Clone databases not detaching after verification

GUGGD2868 — Thu, 05 Jun 2025 05:47:19 GMT

I'm seeing several warnings that databases are not able to detach after verifications. It seems to happen to random databases, and at random times. Here is a sample of the log:

[04:15:49.996] [PRESQL01] Attaching database [AddressBook__Clone]...

[04:15:49.996] [PRESQL01] CREATE DATABASE [AddressBook__Clone] ON PRIMARY (NAME = 'AddressBook', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk003\AddressBook.mdf') LOG ON (NAME = 'AddressBook_log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk004\AddressBook_1og.ldf') FOR ATTACH

[04:15:51.261] [PRESQL01] Database attached.

[04:15:51.263] [PRESQL01]

[04:15:51.263] [PRESQL01] ALTER DATABASE [AddressBook__Clone] SET AUTO_SHRINK OFF

[04:15:51.292] [PRESQL01]

[04:15:51.293] [PRESQL01] DBCC CHECKDB (N'AddressBook__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[04:15:55.595] [PRESQL01]

[04:15:55.599] [PRESQL01] DBCC CHECKDB completed successfully.

[04:15:55.599] [PRESQL01] Detaching database [AddressBook__Clone].

[04:15:55.700] [PRESQL01] WARNING: Unable to detach temporary clone database [AddressBook__Clone] after backup verification on server [PRESQL01]. Please close all connections to this database NOW, or backup verification would fail.

[04:15:55.700] [PRESQL01] Preparing email notification message...

[04:15:58.705] [PRESQL01] An email notification message was sent.

[04:15:58.706] [PRESQL01] ALTER DATABASE [AddressBook__Clone] SET OFFLINE

[04:15:58.808] [PRESQL01]

[04:15:58.809] [PRESQL01] Drop Database [AddressBook__Clone]

[04:15:58.830] [PRESQL01]

[04:15:58.831] [PRESQL01] Checking clone database name...

Has anyone experienced this before? The message seems to indicate a connection to the database was made, but I can't think of what could be connecting to the database, it was only created for 4 seconds before the detach.

I took a look at sp_who2 while this was running this weekend. I got the following results:

SPID	Status	Login	HostName	BlkBy	DBName	Command	CPUTime	DiskIO	LastBatch	ProgramName	SPID2	RequestID	rundate
63	SUSPENDED	domain\Login	PRESQL01	.	Benchmark_Old__Clone	DBCC TABLE CHECK	55218	1244273	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	SUSPENDED		PRESQL01	.	Benchmark_Old__Clone	DBCC TABLE CHECK	47	0	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	SUSPENDED		PRESQL01	.	Benchmark_Old__Clone	DBCC TABLE CHECK	2147483647	0	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	SUSPENDED		PRESQL01	.	Benchmark_Old__Clone	DBCC TABLE CHECK	62	0	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	SUSPENDED		PRESQL01	.	Benchmark_Old__Clone	DBCC TABLE CHECK	141	0	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	SUSPENDED		PRESQL01	63	Benchmark_Old__Clone	DBCC TABLE CHECK	1359	32211	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	RUNNABLE		PRESQL01	.	Benchmark_Old__Clone	DBCC TABLE CHECK	1375	36170	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	SUSPENDED		PRESQL01	63	Benchmark_Old__Clone	DBCC TABLE CHECK	1297	33106	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7
63	SUSPENDED		PRESQL01	63	Benchmark_Old__Clone	DBCC TABLE CHECK	1125	33072	12/15/2013 9:44	SnapManager for SQL Server	63	0	45:10.7

So is it possible that while this request is being run in parrallel, some threads are being blocked by the others, and those are causing connections to stay open and the database clone is thus unable to detach?

Thank you

Re: Clone databases not detaching after verification

GUGGD2868 — Tue, 31 Dec 2013 14:05:50 GMT

No one has experienced this before? Is there way I can tell SnapManager to run the verification with MaxDOP = 1?

topic Clone databases not detaching after verification in Data Protection

Clone databases not detaching after verification

Re: Clone databases not detaching after verification