TDE is used to keep the backup file in unreadable format.

Find below step to enable TDE one server and source backup file can restore in target environment with backup of...

Find below/attached script to get LSN of full, diff and log backup which will help to check the LSN and find the location of adhoc backup while doing restoration.

--LSN Check

--Full...

• This reply was modified 6 months, 2 weeks ago by Srinivas Merugu.

Find below/attached script to get the Always On Latency ,duration to sync Always-ON & data latency on an Always On Availability Group in ASYNC mode

--Always ON****

--Always On Latency -

SELECT getdate()...

• This reply was modified 6 months, 2 weeks ago by Srinivas Merugu.

Find below/attached  script to get the execution plan of stored procedure and execution count.

--get plan handle using below query , passing procedure detail

select DEST.text,DEPS.plan_handle, DEPS.* from sys.dm_exec_procedure_stats as DEPS cross...

• This reply was modified 6 months, 2 weeks ago by Srinivas Merugu.

Find Below/attached script to restore multiple backup files in single shot as per existing Database data and log file location.

Use master

go

DECLARE @date CHAR(8)

SET @date = (SELECT CONVERT(char(8), GETDATE(), 112))

DECLARE @path...

• This reply was modified 6 months, 2 weeks ago by Srinivas Merugu.

Find attached backup script will help to take the backup of multiple databases, specific databases , all user databases.

We can update the parameters based on our requirement. The same script...

• This reply was modified 6 months, 2 weeks ago by Srinivas Merugu.
• This reply was modified 6 months, 2 weeks ago by Srinivas Merugu.

Find attached backup script will help to take the backup of multiple databases, specific databases , all user databases.

We can update the parameters based on our requirement.

****************************

DECLARE @name VARCHAR(50) --...

• This reply was modified 6 months, 2 weeks ago by Srinivas Merugu.

Find the attached backup script will help to take all user Database backup and specified DB backup.

You can modify the script based on your requirement.

Below script will help to get the backup/Restoration % done progress.

----------------

SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete)

AS [Percent Complete],CONVERT(VARCHAR(20),DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time],

CONVERT(NUMERIC(10,2),r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min],

CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0) AS [ETA Min],

CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA Hours],

CONVERT(VARCHAR(1000),(SELECT SUBSTRING(text,r.statement_start_offset/2,

CASE WHEN r.statement_end_offset...

If page size is less than 1000 then no use when rebuild the index.

Will get long duration if run fragmentation script for all tables instead of single problematic table.

Below script...

If page size is less than 1000 then no use when rebuild the index.

Will get long duration if run fragmentation script for all tables instead of single problematic table.

Below script...

Below script will help to get the details of last updated date, modification_counter. if modification count is very huge then need to do update stats with full scan instead of...

Below script will help to get the details of last updated date, row, samples rows and modification_counter. if modification count is very huge then need to do update stats with...