查询数据库日志
USE [数据库名]
GO
select name from SYS.database_files where type_desc='LOG'
清空数据库日志
- USE [master]
- GO
- ALTER DATABASE [数据库名] SET RECOVERY SIMPLE WITH NO_WAIT
- GO
- ALTER DATABASE [数据库名] SET RECOVERY SIMPLE
- GO
- USE [数据库名]
- GO
- DBCC SHRINKFILE (N'[数据库日志文件名称]' , 0,TRUNCATEONLY)
- GO
- USE [master]
- GO
- ALTER DATABASE [数据库名] SET RECOVERY FULL WITH NO_WAIT
- GO
- ALTER DATABASE [数据库名] SET RECOVERY FULL
- GO
- --查询指定数据库的日志文件名称
- USE [数据库名]
- GO
- SELECT name FROM SYS.database_files WHERE type_desc='LOG'
备份数据库
BACKUP LOG qpplatformdb TO DISK='c:\qpplatformdb_log1.bak' WITH FORMAT