Yeah let me consider the points which you have informed. I will work on this challenging part and will let you know with update. Thanks for responses.

Thank you for your information and sorry for confusion. Yes, I do know we will encounter datatype issues while downgrading. What my question is what issues do we see when...

Yes it makes sense. Thank you

Thank you so much. I actually need to mask the data. so i found this would be good option.

ok..i was not aware where exactly to post..thanks for info

Thank you. It works

--Finally This query worked out in deteming the tables with compression 🙂

SELECT

SCHEMA_NAME(sys.objects.schema_id) AS [SchemaName]

,OBJECT_NAME(sys.objects.object_id) AS [ObjectName]

,[rows]

,[data_compression_desc]

,[index_id] as [IndexID_on_Table]

FROM sys.partitions ...

dp we have any query which view the list of all page or row compressions

Here is the thing..it got back my deleted data...

-- I am just trying to learn..not for my office purpose..just interested to do things and learn by myself.

--Restore Files if...

Oh ya, so now how can I get the deleted data, can you provide any script for this plz. Thank you

This is how I did and it worked out..

USE master

--Create tail-log backup.

BACKUP LOG TestDB2

TO DISK = 'd:\backups\TailLogTESTDB2.bak'

WITH NORECOVERY;

--FULL DB

RESTORE DATABASE TestDB2

FROM DISK =...

Thank you Linn and Gylla..excellent answers..it helps me.

The data has got deleted with in the time log as mentioned earlier (20 mins) interval. TX log has not backed up. So, how can we get back the deleted...

My question is how can we get the lost data between that time (20mins) interval? Do we have any script for that?

Ok..lets consider I do have mdf and recent ldf files before disaster then how can i get back the data of the time where I lost