Shrink Database in Availability Group in SQL Server
Mesh
Updated Aug 4, 2023, 03:59 PM
Here's how you shrink a database in AG:
USE master
GO
ALTER AVAILABILITY GROUP AG\_NAME REMOVE DATABASE DB\_NAME;
GO
use "DB\_NAME"
ALTER DATABASE "DB\_NAME"
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE ('DB\_NAME\_log', 1);
GO
-- Reset the database recovery model.
ALTER DATABASE "DB\_NAME"
SET RECOVERY FULL;
GO
BACKUP DATABASE DB\_NAME
TO DISK = '\\\\path\\to\\backup\\location\\DB\_NAME.bak'
WITH FORMAT,
MEDIANAME = 'SQLServerBackups',
NAME = 'Full Backup of DB\_NAME';
GO
USE master
GO
ALTER AVAILABILITY GROUP AG\_NAME ADD DATABASE DB\_NAME;
GO
