Post reply

DB Snapshot on TDE Enabled Database

  • July 21, 2019 at 10:50 am

    #3664839

    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.

  • July 22, 2019 at 11:10 am

    #3665003

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

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

  • July 24, 2019 at 2:35 pm

    #3665767

    Any pointers on this would be helpful.

  • July 25, 2019 at 1:34 pm

    #3666062

    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.

  • July 26, 2019 at 1:13 am

    #3666230

    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]

  • August 16, 2019 at 12:49 pm

    #3671818

    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.

  • August 16, 2019 at 1:41 pm

    #3671846

    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 6 (of 6 total)

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