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
- Can you recommend an iPad app for opening Outlook .msg files (other than Klammer)? #twitterbrain - twitted 1 week ago
- #fail for dkk 500.000.000 http://t.co/hlTB5BqK #dkpol - twitted 2 weeks ago
- There's a special place in hell for vendors that returns a laptop after 4 weeks in the repair shop and neither of the issues have been fixed - twitted 2 weeks ago
- So looking forward to a piece of @raspbery_pi . The inner engineer pops up exciting ideas for useful devices. #LEGOv2 - twitted 2 weeks ago
-
Top Posts
Tag Cloud
-
Bookmarked
