Skip to content
MeshLab
All posts

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

Comments 0

Sign in to join the conversation.

No comments yet. Start the conversation.