SQL SERVER 2008 数据库
USE [master]
GO
ALTER
DATABASE
GPSDB SET
RECOVERY SIMPLE
WITH
NO_WAIT
GO
ALTER
DATABASE
GPSDB
SET
RECOVERY SIMPLE
--简单模式
GO
USE GPSDB
GO
DBCC SHRINKFILE (N
'DNName_Log'
, 11, TRUNCATEONLY)
GO
--------------------------------------------------------------------------------------------------
'DNName_Log 在sys.database_file进行查询
'
USE DNName
'GO
'
SELECT
file_id, nameFROM sys.database_files;
'GO
----------------------------------------------------------------------
USE [master]
GO
ALTER
DATABASE
GPSDB
SET
RECOVERY
FULL
WITH
NO_WAIT
GO
ALTER
DATABASE
GPSDB
SET
RECOVERY
FULL
--还原为完全模式
GO
sqlserver 2005数据库清空删除日志
Backup Log DNName
with
no_log ' DNName是你要收缩的数据库名
go
dump
transaction
DNName
with
no_log
go
USE DNName
DBCC SHRINKFILE (2)
Go