Quick Reminder: How to Truncate a Database




USE [master]
GO
ALTER DATABASE [soapnmteach] SET RECOVERY SIMPLE WITH NO_WAIT
GO

USE [soapnmteach]
DBCC SHRINKFILE (soapnmteach_log, 1)
GO

USE [soapnmteach]
DBCC SHRINKFILE (soapnmteach, 1)
GO

USE [master]
GO
ALTER DATABASE [soapnmteach] SET RECOVERY FULL WITH NO_WAIT
GO

Comments

Popular posts from this blog

Using Reference Aliases

List of Visual Studio Keyboard Shortcuts