Subscribe

SMSQL Verification - Unable to Mount Database clone

Good morning,

 

We have a SQL 2014 database server, we run SMSQL 7.2.1. The SMSQL backup runs successfully however the verification, which runs on a dedicated verification server fails. Here is the error I am getting just for one of the database.

 

SRV-SQL-VERIFY] Using existing connection to server [SRV-SQL-VERIFY]...
[SRV-SQL-VERIFY] Checking clone database name...

[SRV-SQL-VERIFY] Attaching database [CART_Dev__Clone]...
[SRV-SQL-VERIFY] CREATE DATABASE [CART_Dev__Clone] ON PRIMARY (NAME = 'tmplt', FILENAME = 'Z:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\CART_Dev.mdf'), FILEGROUP [DocumentRepository] (NAME = 'TMPLT_DocumentRepository1', FILENAME = 'Z:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\CART_Dev_1.ndf') LOG ON (NAME = 'tmplt_log', FILENAME = 'Z:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\CART_Dev_2.ldf') FOR ATTACH
[SRV-SQL-VERIFY] Cannot find server certificate with thumbprint '0x45F30694F2BB0D977F51FB386580D341D7DD693D'.
[SRV-SQL-VERIFY] DBCC CHECKDB (N'CART_Dev__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY
[SRV-SQL-VERIFY] Could not find database 'CART_Dev__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.
[SRV-SQL-VERIFY] WARNING: SQLServer DBCC CHECKDB failed.

[SRV-SQL-VERIFY] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8
[SRV-SQL-VERIFY] Detaching database [CART_Dev__Clone].
[SRV-SQL-VERIFY] WARNING: Unable to detach temporary clone database [CART_Dev__Clone] after backup verification on server [SRV-SQL-VERIFY]. Please close all connections to this database NOW, or backup verification would fail.
[SRV-SQL-VERIFY] Preparing email notification message...
[SRV-SQL-VERIFY] An email notification message was sent.
[00:49:52.385]  [SRV-SQL-VERIFY] ALTER DATABASE [CART_Dev__Clone] SET OFFLINE
[SRV-SQL-VERIFY] User does not have permission to alter database 'CART_Dev__Clone', the database does not exist, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed.
[SRV-SQL-VERIFY] Failed to Detach Database.
[SRV-SQL-VERIFY] Checking clone database name...