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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment