Reduce log files

Sqlserver2005

Backup log Qingpu with no_log;
Backup log Qingpu with truncate_only;
DBCC shrinkdatabase (Qingpu );

 

Sqlserver2008

Use [Master]

Go

Alter database Qingpu set recovery simple with no_wait

Go

Alter database Qingpu set recovery simple -- simple mode

Go

Use Qingpu

Go

DBCC shrinkfile (n' Qingpu _ log', 11, truncateonly)

Go

Use [Master]

Go

Alter database Qingpu set recovery full with no_wait

Go

Alter database Qingpu set recovery full -- restore to full Mode

Go