Shrink All Database Logs Files - MSSQL
DECLARE @sqlcommand NVARCHAR(500)
DECLARE @getid CURSOR
SET @getid = CURSOR FOR
SELECT
'USE [' + d.name...
3 posts match your filters.
DECLARE @sqlcommand NVARCHAR(500)
DECLARE @getid CURSOR
SET @getid = CURSOR FOR
SELECT
'USE [' + d.name...
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;...