ASP.NET, SQL, XNA and More...
EXEC sp_MSforeachdb @command1 = "BACKUP LOG ? WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( ? ) "
Clearing out data can be done through this method. It depends on how you configure the tool.SEO Philippines
For one database: BACKUP LOG database_name WITH TRUNCATE_ONLYGODBCC SHRINKDATABASE( database_name )GO
Clearing out data can be done through this method. It depends on how you configure the tool.
ReplyDeleteSEO Philippines
For one database:
ReplyDeleteBACKUP LOG database_name WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE( database_name )
GO