Posted On June 6, 2019

MS SQL: Archive and Shrink Database

kimconnect 0 comments
blog.KimConnect.com >> Database >> MS SQL: Archive and Shrink Database
--Archive Database: with maximum allowed runtime and a set number of records
declare @EndDate datetime, @Recs INT, @maxrunTimeInMinutes INT
SET @maxrunTimeInMinutes = 60
SET @Records = 20000
set @EndDate = dateadd(dd,1,cast(convert(char(10),(select min(logdate) FROM KIMCONNECT.dbo.au_commontable),121) as datetime))
execute [dbo].[pOrccArchive] @maxrunTimeInMinutes = @maxrunTimeInMinutes, @Records = @Records, @EndDate = @EndDate

--Shrink Database:
EXEC pShrinkDatabase 1, 'KIMCONNECT'

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

SQL: Truncate Transaction Logs

Overview: Significance: many small teams lack Database Admin resource to babysit SQL databases; therefore, certain…

SQL: Using PowerShell to Check if a Table, View, or Stored Procedure Exists

#Usage # set variables $sqlServer='sql-server04' $databaseName="Test_Database" $objectType='view' $objectName='[dbo].[Test_View]' $saCred=get-credential # Call function checkDatabaseObject $sqlServer $databaseName…

How to Add Domain Admins to SQL Server

Step 1: Right-click Start > Search > type in 'ssms.exe' > right-click Microsoft SQL Server…
Other project: DragonCoin.com