18 Kasım 2016 Cuma

MS-SQL / delete tempdb file


USE tempdb
GO
DBCC SHRINKFILE (tempdb4, EMPTYFILE);
GO


USE tempdb;
GO
DBCC SHRINKFILE('tempdb4', EMPTYFILE)
GO
USE master;
GO
ALTER DATABASE tempdb
REMOVE FILE tempdb4;
at
Labels:

Hiç yorum yok:

Yorum Gönder

Kaydol: Kayıt Yorumları (Atom)

Problem MS SQL Server instances disappear from SQL Intelligent Policy and previously discovered Availability Groups (AG) in NetBackup. Cause...