truncate sql log
First off, You CANNOT REVERT this command, so be sure you want to truncate the log! THE QUERY Instructions: Just replace with your DB BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( ”, TRUNCATEONLY)
Tag sql
Howto: Fix (Can’t contact the database server: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) (localhost))
Problem: receiving this error on freebsd 6.1 (Can’t contact the database server: Can’t connect to local MySQL server through socket ” (2) (localhost)) To investigate run this command: # ps xa | grep mysqld If mysql is not running then…
Howto: Fix an oversized modellog.ldf
modellog.ldf too big? First try to figure out what’s using the log file: use [model] select (sum(size) * (8192/1024)) / 1024 from dbo.sysfiles WHERE (status & 0x40) 0 DBCC SQLPERF(LOGSPACE) select ceiling((sum(size) * (8192.0)) / 1024.0) from dbo.sysfiles exec sp_spaceused…