Sean's Blog
A place where I record bits and pieces :)
Friday, June 23, 2023
SQL Server Agent Job Startup to remove a tempdb file
USE [tempdb]
GO
DBCC SHRINKFILE (N'temp5', EMPTYFILE)
GO
ALTER DATABASE [tempdb] REMOVE FILE [temp5]
GO
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment