NikoRanger的博客

--查询日志文件名称 --DBNAME 数据库名称 --DBNAME_Log 数据库日志名称 USE DBNAME SELECT * FROM sys.database_files USE[master] GO ALTER DATABASE DBNAME SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE DBNAME SET RECOV...

SELECT A.NAME ,B.ROWS FROM sysobjects A JOIN sysindexes B ON A.id = B.id WHERE A.xtype = 'U' AND B.indid IN(0,1) AND B.rows>0 ORDER BY B.ROWS DESC'