1.如果获得数据库的大小?
exec sp_helpdb
select * from sysfiles
2.查询某个库空间
use dbname
sp_spaceused
3.查某个表空间
sp_spaceused tablename
4.查看日志文件内容
DBCC log(dbname, type=4)
Syntax: DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] ) PARAMETERS: Dbid or dbname - Enter either the dbid or the name of the database in question. type - is the type of output: 0 - minimum information (operation, context, transaction id) 1 - more information (plus flags, tags, row length, description) 2 - very detailed information (plus object name, index name, page id, slot id) 3 - full information about each operation 4 - full information about each operation plus hexadecimal dump of the current transaction log's row. -1 - full information about each operation plus hexadecimal dump of the current transaction log's row, plus Checkpoint Begin, DB Version, Max XDESID by default type = 0 To view the transaction log for the master database, you can run the following command: DBCC log (master)