Passos per esborrar un fitxer de dades de la base de dades temporal:
USE tempdb GO DBCC SHRINKFILE (tempdev12, EMPTYFILE); -- to empty "tempdev12" data file GO
ALTER DATABASE tempdb REMOVE FILE tempdev12; --to delete "tempdev12" data file GO
-- Use ALTER DATABASE if the target file size is greater than the current file size USE [master] GO ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev', SIZE = 3072000KB ) --grow to 3000 MB GO --Use DBCC SHRINKFILE if the target file size is less than the current file size USE [tempdb] GO DBCC SHRINKFILE (N'tempdev' , 3000) --shrink to 3000 MB GO
Si no es pot esborrar el fitxer:
DBCC DROPCLEANBUFFERS GO DBCC FREEPROCCACHE GO DBCC FREESESSIONCACHE GO DBCC FREESYSTEMCACHE ('ALL') GO