Hi
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
