Hi guys,

With respect to both replies, I had a question I needed a straight answer.

To clarify, I have a Windows 2019 Server with two 2.20 GHz processors and eight cores,...

This is a script that I am using:

USE [master]

RESTORE DATABASE [DBName] FROM DISK = N'BackupFile' WITH FILE = 1, MOVE N'DataFile' TO N'MDFFile', MOVE N'LogFile' TO N'LDFFile', NOUNLOAD, STATS =...

To Homebrew01:

I thought so too. And it does. But it releases the used space during restore. I need the mimic of the original database. You would think that restore operation...

I was told by System Admins that not having Certificate installed on SQL Server adds vulnerability to the Server. I cannot find a proof to this statement.

Instead, I believe that...

Hey guys, thank you for your quick responses,

Jeff, unfortunately, I do not have time to create all the functionalities that I found very efficient and DPA is giving me in...

Thanks for your all prompt responses.

I will check all these options and let you know about the output

Thanks again for all responses,

But let me try to clarify something.

According to California Consumer Privacy Act (CCPA) of 2018, that will be in effect on 1/1/2020 the bill "would provide...

Good point oogibah,

Before planning on implementing TDE, we did a lot of restores during pre-prod, testing, qa and other upgrades and never had problems.

With testing TDE encrypted compressed backup file...

Thanks everybody for the valid responses, I really appreciate them.

Sue, LiteSpeed now supports TDE compression on SQL Server 2016 SP2 and higher. But I stuck with AlwaysOn on SQL Server...

Thanks for your response Sue,

But my major question was to DBAs not about using tools. The major question was, does anybody using Transparent Data Encryption in SQL Server 2012 (not...

Hi again,

I know what are the isolation levels, and the differences between them. I was giving exanples for reports that do not need precise accuracy (does not mean that...

Everybody,
Thanks for your thorough and valid advices.
Your help is greatly appreciated.
Alex

Thanks for all your replies.
I know that is not the simple question; that's why I was asking help from DBAs.

I am myself is a production DBA and...

Thanks Perry

Thanks Steve,
But this is still not the answer to my question.

Of course I am not going to do this right away in Production.

I was...