sql « BrakertechBrakertech

truncate sql log

posted this in MSSQL, Software, Windows on September 23rd, 2010

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 <DBNAME> WITH TRUNCATE_ONLY 
DBCC SHRINKDATABASE( '<DBNAME>', TRUNCATEONLY)

1 2	BACKUP LOG <DBNAME> WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( '<DBNAME>', TRUNCATEONLY)

Howto: Fix (Can’t contact the database server: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) (localhost))

posted this in FreeBSD, MYSQL on July 9th, 2010

Problem: receiving this error on freebsd 6.1

(Can't contact the database server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (localhost))

1	(Can't contact the database server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (localhost))

To investigate run this command:

# ps xa | grep mysqld

1	# ps xa \| grep mysqld

If mysql is not running then start it like this:

# /usr/local/etc/rc.d/mysql-server start

1	# /usr/local/etc/rc.d/mysql-server start

Howto: Fix an oversized modellog.ldf

posted this in MSSQL, Scripts, Windows on June 25th, 2010

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 & 0×40) 0 DBCC SQLPERF(LOGSPACE) select ceiling((sum(size) * (8192.0/1024.0)) / 1024.0) from dbo.sysfiles exec sp_spaceused DBCC SQLPERF(LOGSPACE)

It is very unusual that the model database data or log files would . . . → Read More: Howto: Fix an oversized modellog.ldf

Brakertech

truncate sql log

Howto: Fix an oversized modellog.ldf

Search Brakertech

dEFENSE

Hacking

Security

Brakertech

truncate sql log

Howto: Fix (Can’t contact the database server: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) (localhost))

Howto: Fix an oversized modellog.ldf

Search Brakertech

dEFENSE

Hacking

Tags

Security