查詢數據庫日志
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
新聞熱點
疑難解答
