Shrinks the current database’s specified data or log file size. You can use it to move data from one file to other files in the same filegroup, which empties the file and allows for its database removal. You can shrink a file to less than its size at creation, resetting the minimum file size to... » read more
Need to create full database backup and transaction log backup on primary server to shrink the log file. The replica server log file will automatically shrink. Might need to backup the transaction log a couple of times and wait a while before the log file will automatically shrink. Sources: https://dba.stackexchange.com/questions/114787/shrink-database-in-always-on-availability https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver15
Error: The log for database ‘xxxxx’ cannot be shrunk until all secondaries have moved past the point where the log was added. Fix: Problem with Always On. One of the secondary was not getting synchronized. Delete the AG and the thing came back to normal. But in production, if you can’t afford to delete and... » read more
Error: Cannot shrink log file XX (XXXXX_LOG) because the logical log file located at the end of the file is in use Always On and Log File You will get this error trying to shrink the log files if the database belongs to Always On. Fix: Preform a full database and log backup. The log... » read more
Creating a custom database backup script to handle your database backup. usp_bu_user_dbs FULL Backup
How do the differential backups work from a restore perspective? Depending on your backup schedule and the time when the failure occurred would dictate the detailed steps that would need to be taken. If you need to have your current SQL Server databases back up and running, then the full backup would be restored followed... » read more
Reducing Size of SQL Backup Is your database in “Simple” recovery mode? If so, it’ll produce a lot less transaction log entries, and the backup will be smaller. Recommended for development – but not for production. If it’s in “FULL” recovery mode – do you do regular transaction log backups? That should limit the growth... » read more
Note Settings Full Backup File Size Original Database Database Size: 1823 MB Recovery model: Full 738 MB After change recovery model to Simple Database Size: 1823 MB Recovery model: Simple 738 MB After shrink log file Database Size: 739 MB Recovery model: Simple 738 MB
Full Database Backup Output 10 percent processed. 20 percent processed. 30 percent processed. 40 percent processed. 50 percent processed. 60 percent processed. 70 percent processed. 80 percent processed. 90 percent processed. Processed 92256 pages for database ‘MyDB’, file ‘MyDB’ on file 1. 100 percent processed. Processed 3 pages for database ‘MyDB’, file ‘MyDB_log’ on file... » read more
https://www.red-gate.com/products/sql-development/sql-search/ Find SQL fast in SQL Server Management Studio and Visual Studio Find fragments of SQL in tables, views, stored procedures, functions, jobs, and more Quickly navigate to objects wherever they happen to be on a server Search across multiple object types and multiple databases Find all references to an object Search with booleans and... » read more