3 Replies Latest reply: Dec 16, 2013 8:09 AM by GUGGD2868 RSS

Clone databases not detaching after verification

GUGGD2868
Currently Being Moderated

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.

 

Thank you

  • Re: Clone databases not detaching after verification
    GUGGD2868
    Currently Being Moderated

    So 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?

More Like This

  • Retrieving data ...