Truncate Logs
alter database <mydb> set recovery simple go checkpoint go alter database <mydb> set recovery full go backup database pubs to […]
SQL – Find Space Used, Row Count of all tables in a database
SET NOCOUNT ON DBCC UPDATEUSAGE(0) — DB size. EXEC sp_spaceused — Table row counts and sizes. CREATE TABLE #t ( […]
