Data Backup and Recovery

Clone databases not detaching after verification

GUGGD2868
3,262 Views

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:

SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIOLastBatchProgramNameSPID2RequestIDrundate
63SUSPENDED                    domain\LoginPRESQL01       .Benchmark_Old__CloneDBCC TABLE CHECK55218124427312/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63SUSPENDED                   
PRESQL01       .Benchmark_Old__CloneDBCC TABLE CHECK47012/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63SUSPENDED                   
PRESQL01       .Benchmark_Old__CloneDBCC TABLE CHECK2147483647012/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63SUSPENDED                   
PRESQL01       .Benchmark_Old__CloneDBCC TABLE CHECK62012/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63SUSPENDED                   
PRESQL01       .Benchmark_Old__CloneDBCC TABLE CHECK141012/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63SUSPENDED                   
PRESQL01     63Benchmark_Old__CloneDBCC TABLE CHECK13593221112/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63RUNNABLE                    
PRESQL01       .Benchmark_Old__CloneDBCC TABLE CHECK13753617012/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63SUSPENDED                   
PRESQL01     63Benchmark_Old__CloneDBCC TABLE CHECK12973310612/15/2013 9:44SnapManager for SQL Server                                     63045:10.7
63SUSPENDED                   
PRESQL01     63Benchmark_Old__CloneDBCC TABLE CHECK11253307212/15/2013 9:44SnapManager for SQL Server                                     63045: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

1 REPLY 1

GUGGD2868
3,262 Views

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

Public