https://www.microsoft.com/en-us/sql-server/blog/2025/05/19/announcing-sql-server-2025-preview-the-ai-ready-enterprise-database-from-ground-to-cloud/
Thursday, May 22, 2025
Wednesday, May 21, 2025
How to apply patches on SQL Database Mirror Servers
The following list of steps can be performed against Database Mirror servers to apply patches
1. Take backup of all dbs in Principal Database Server
2. Pause Mirroring on Principal Database Server for all mirrored dbs
3. The Principal server databases becomes (Principal,Suspended)
3. Stop all SQL services on Mirror Database Server (Including WMI service)
4. Apply CU patch on mirrored servers
5. Unpause Mirrors (wait for them to catch up)
6. Failover the databases (the mirror server becomes Principal)
7. Pause Mirroring
8. Hand-over to Application users to test and wait for their confirmation to proceed.
9. Stop all SQL services on Mirror Server (Including WMI service)
10. Apply CU patch on Principal Database servers
11. Unpause mirrors
12. Failback databases.
Tuesday, April 08, 2025
Find Backup History from SQL Server Database Server
The below scripts which allow you to find SQL Server Database Last night backup history. If you want see more files in this list please change date.
SELECT
[Server_name],
[Database_name],
[Type] AS Backup_type,
case
when [type]= 'D' THEN 'Full Backup'
when [type]= 'I' THEN 'Incremental Backup'
when [type]= 'L' THEN 'Log Backup'
end as Backup_types ,
CAST(backup_size /1048576 AS DECIMAL (10,2)) AS [Backup_Size (MB)],
CAST(compressed_backup_size/1048576 AS DECIMAL (10,2))
AS [Compressed_Backup_Size (MB)],
CAST(compressed_backup_size/1048576 AS DECIMAL (10,2))/1024 AS [Compressed_Backup_Size (GB)],
100- ((compressed_backup_size/backup_size)*100) AS 'Compressed%',
[backup_start_date],
[backup_finish_date]
FROM msdb.dbo.backupset
WHERE [Type]='D'
and backup_finish_date> getdate()-1 -- '2025-04-01 00:00:00.000'
ORDER BY backup_set_id desc
Wednesday, April 02, 2025
Could not find the Database Engine startup handle. Error code: 0x851A0019
Installing SQL Server 2022 on Azure Virtual machine I have encountered an issue
Action required:
Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Feature failure reason:
An error occurred during the setup process of the feature.
Error details:
§ Error installing SQL Server Database Engine Services Instance Features
Could not find the Database Engine startup handle.
Error code: 0x851A0019
Run cmd prompt on this below command check Drive sectorinfo
C:\Fsutil fsinfo sectorinfo E:
Make sure to have 512 bytes to 4096 bytes allocated for the Drive which master.mdf file is installed
Friday, March 21, 2025
Shrining Database Transaction Log file is not working Transaction Log file size from 42 GB to 100MB
It is interesting to fix one of major database issue which causing a problem to reduce Transaction Log file size from 42 GB to 100MB.
Database file (MDF) 760MB
Database Log file (LDF) 42GB
-- STEP 1
DBCC Shrinkfile ('Adventuredb_Log', 100)
GO
-- not working above statement as we expected
I took database backup followed by Transaction Log backup then again tried not working neither T-SQL nor SSMS.
What a day
DBCC Shrinkfile ('Adventuredb_Log', 100)
GO
-- STEP 2
DBCC OPENTRAN()
Transaction information for database 'Adventuredb'.
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (73283:414:1)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
-- STEP 3
select log_reuse_wait_desc,* from sys.databases where name = 'Adventuredb'
log_reuse_wait_desc
REPLICATION
EXEC sp_removedbreplication 'Adventuredb'
--Commands completed successfully.
select log_reuse_wait_desc from sys.databases where name = 'Adventuredb'
log_reuse_wait_desc
NOTHING
Finally i have managed shrink the log file to 100MB
Monday, February 17, 2025
Microsoft SQL Server 2025
Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground to cloud
Monday, January 06, 2025
Scripting All Agent Jobs Using SQL Server Management Studio
You have to Press the F7 key so the Object Explorer Details window appears like below. Select jobs you want to scripts and Right click to Generate scripts.