Recentemente trabalhando em um dos clientes foi preciso remover um dos arquivos do tempdb, ao apagar o arquivo recebi o erro tempdb cannot be removed.
Msg 5042, Level 16, State 1, Line 1
The file ‘tempdev2′ cannot be removed because it is not empty.
Como resolver isso? Da seguinte forma:
USE tempdb;
GO
DBCC SHRINKFILE('tempdev2', EMPTYFILE)
GO
USE master;
GO
ALTER DATABASE tempdb
REMOVE FILE tempdev2;
Pronto, problema resolvido.
Port video games have actually long been a popular type of entertainment, providing exhilarating gameplay…
When it pertains to online gambling, safety needs to be a top issue for every…
There are many reasons to play no-cost online casino games in the coming year. The…
On the internet casinos have acquired tremendous appeal in recent times, offering gamers with the…
Welcome to our useful post concerning the very best casino site game! Whether you're a…
The random number generator (or RNG) is the program that generates the outcome of every…