SELECT NAME, database_id,create_date 创建时间,is_auto_shrink_on 自动收缩,state_desc 状态,recovery_model_desc 恢复模式,is_published 是否发布库,log_reuse_wait_desc日志重用状态 FROM sys.databases

--修改数据库日志模式：Simple,Full,BULK_LOGGED

ALTER DATABASE [数据库名] SET RECOVERY SIMPLE

--设置自动收缩

ALTER DATABASE [数据库名] SET AUTO_SHRINK ON WITH NO_WAIT

SELECT NAME, database_id,create_date 创建时间,is_auto_shrink_on 自动收缩,state_desc 状态,recovery_model_desc 恢复模式,is_published 是否发布库,log_reuse_wait_desc日志重用状态 FROM sys.databases

--修改数据库日志模式：Simple,Full,BULK_LOGGED

ALTER DATABASE [数据库名] SET RECOVERY SIMPLE

--设置自动收缩

ALTER DATABASE [数据库名] SET AUTO_SHRINK ON WITH NO_WAIT

--收缩日志

DBCC SHRINKFILE (N'DNName_Log' , 1)

--重建索引

USE DNName;

DECLARE @name varchar(100)

DECLARE authors_cursor CURSOR FOR

Select [name]   from sysobjects where xtype='u' order by id

OPEN authors_cursor

FETCH NEXT FROM authors_cursor  INTO @name

WHILE @@FETCH_STATUS = 0

BEGIN    

   DBCC DBREINDEX (@name, '', 90)

   FETCH NEXT FROM authors_cursor

   INTO @name

END

deallocate authors_cursor