DB Snapshot on TDE Enabled Database

  • GonnaCatchIT

    SSCrazy

    Points: 2775

    Dear All,

    I have a DB on which TDE is enabled. When trying to make a snapshot of this DB we get an error:

    Error id: 33118

    Error: cannot enable or modify database encryption on a database that is read only,has read-only files or is recovered.

    However, I observed the Snapshot has been created & I am able to query the DB etc...

    Questions:

    1. Can I Ignore this error as just an Warning?
    2. Is there no way we can create Snapshot on TDE DB's ?. I dont want to disable it due to security requirements.
  • Site Owners

    SSC Guru

    Points: 80385

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • GonnaCatchIT

    SSCrazy

    Points: 2775

    Any pointers on this would be helpful.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715095

    That's strange. How did you create this (code?). I have a TDE database that I set to read only. I then ran this:

    CREATE DATABASE tdesnapshot 
    ON (NAME = tde_primer, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\DATA\tdess.ss')
    AS SNAPSHOT OF TDE_Primer;

    No error, snapshot created.

  • GonnaCatchIT

    SSCrazy

    Points: 2775

    Thanks for the response Steve.

    FYI, I am trying this on SQL Server 2016 Dev edition.

    Here is the command I use:

    CREATE DATABASE [TEST_SNAPSHOT] ON

    (NAME = N'TEST_DB', FILENAME = N'C:\DBFolder\TEST_SNAP.snap'),

    (NAME = N'TEST_DB_1', FILENAME = N'C:\DBFolder\TEST_SNAP_1.snap'),

    (NAME = N'TEST_DB_2', FILENAME = N'C:\DBFolder\TEST_SNAP_2.snap'),

    (NAME = N'TEST_DB_3', FILENAME = N'C:\DBFolder\TEST_SNAP_3.snap'),

    (NAME = N'TEST_DB_4', FILENAME = N'C:\DBFolder\TEST_SNAP_4.snap'),

    (NAME = N'TEST_DB_IDX', FILENAME = N'C:\DBFolder\TEST_SNAP_IDX.snap'),

    (NAME = N'TEST_DB_log2', FILENAME = N'C:\DBFolder\TEST_SNAP_LOG2.snap')

    AS SNAPSHOT OF [SOURCEDB]

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715095

    Are you sure this is the only code that was run? I did this twice in a TDE database that was set to read only with no error or warning.

  • GonnaCatchIT

    SSCrazy

    Points: 2775

    Yes, this is the only code.. Could this be SQL Management studio issue as well ?.

    FYI.. & DB is SQL Server 2016 Developer Edition

    Microsoft SQL Server Management Studio 14.0.17119.0

    Microsoft Analysis Services Client Tools 14.0.608.142

    Microsoft Data Access Components (MDAC) 10.0.16299.15

    Microsoft MSXML 3.0 6.0

    Microsoft Internet Explorer 9.11.16299.0

    Microsoft .NET Framework 4.0.30319.42000

    Operating System 6.3.16299

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply