ONTAP Discussions

SMSQL Verification - Unable to Mount Database clone

duanebachi1
2,112 Views

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...

 

 

1 REPLY 1

manuelf
1,611 Views

Please check with your storage admin if your snap autodelete is enabled on the volume hosting the DB or LUN. 

 If it is enabled check if there is enough space and in any case disable the feature as it is not supported with snapmanager because: who tells the snapdrive app that the snapshot was autodeleted if the host does not initiate the task?

Snapdrive would still think the Snapshot exists even if i twould be deleted.

Other possible issues could be virus checks for example.

Running the config wizard for a  check is a good option too.

If the Config wizard shows any issues or warnings there might be a hint that helps in resolving this issue.

 

Public