After backing up the log files on a SQL server, the logs are truncated and you might want to reclaim the disk space held by those empty log files. This little Transact-SQL script will do just that. DBCC SQLPERF(logspace) GO DECLARE @logsize AS INT = 256; — MB DECLARE @databasename AS VARCHAR(256); DECLARE @filename VARCHAR(256); […]
About
Klinkby
- RT @codylindley: JavaScript Is Eating the World slashdot.org/topic/bi/javas… - twitted 1 day ago
- RT @gumball3000: COPENHAGEN ARE YOU READY? Supercar display - Saturday 18th from 10am. The Starting grid - Sunday 19th from 9am! http://t.c… - twitted 4 days ago
- RT @fernandoagomezf: Thats a low punch // "@SharePoint: Don't fall for the #googlegamble. Use Microsoft Office. bit.ly/10noOyH #Why… - twitted 1 week ago
- RT @ToniFrankola: So how often does @office365 index new #SharePoint content? It seems >1h /cc @molnaragnes @magrom - twitted 1 week ago
Top Posts
Tag Cloud
Bookmarked
