Clota Blog

Category: Security

  • Important SQL Server Scripts…

    Restore Progress Check… ========================================================================== DECLARE @DBName VARCHAR(64) = ‘ODS’ DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX)) INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery of database’, @DBName INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery completed’, @DBName SELECT TOP 1     @DBName AS [DBName]    ,[LogDate]    ,CASE       WHEN…

  • Important PS (Power shell) Scripts

    $a = get-eventlog -logname system -message *SQL* -newest 1 $a | select-object -property * ————————————————————————————————————- EventID            : 7036 MachineName        : ABCD Data               : {83, 0, 81, 0…} Index              : 4281381 Category         …

  • Update Patch Error: Failed to retrieve data for this request.

    Update Patch Error: Failed to retrieve data for this request. Step: 1– Login to the Primary Server and install Cumulative Update (CU20) on the Server.                 Double click on Cumulative patch Update and Install the update.                 When the Dialog box opens, Click on Yes While installing the Patch in the cluster Environment, if you get the following…