Compress Database Backup Files with 7-Zip

7-Zip is a free and open-source file archiver, a utility used to place groups of files within compressed containers known as “archives”. It is developed by Igor Pavlov and was first released in 1999. 7-Zip uses its own 7z archive format, but can read and write several other archive formats. ZipFiles.cmd

Database Backup Log


Database Table Definition List with Extended Property

Get a list of all tables in the database with their extended property value. Adding extended property to table. Update existing extended property to table. Sources:

SQL Server Network Packet Size

The network packet sizeĀ option sets the packet size (in bytes) that is used across the whole network. Packets are the fixed-size chunks of data that transfer requests and results between clients and servers. The default packet size is 4,096 bytes. Note: Do not change the packet size unless you are certain that it will improve... » read more

Check Database Replica Status for Always On

synchronization_state Data-movement state, one of the following values. 0 = Not synchronizing. For a primary database, indicates that the database is not ready to synchronize its transaction log with the corresponding secondary databases. For a secondary database, indicates that the database has not started log synchronization because of a connection issue, is being suspended, or... » read more

Error 9002. The transaction log for database is full due to AVAILABILITY_REPLICA error message in SQL Server

Error: The transaction log for database ***** is full due to ‘AVAILABILITY_REPLICA’ Cause: This occurs when the logged changes at primary replica are not yet hardened on the secondary replica.  Fix: Make sure Always On setup is working properly. Start the SQL services on secondary replica server and resume data movement for the always on... » read more

Remove Database Backup Files

Using SQL Job via Powershell script to remove backup files older than x days. Create the job… Powershell script to remove all .bak files… The following script delete all files… Note: Make sure certain account have modify permission to folder. Server123\Backup Operators SQL Agent Source: