Sqlserver
-
编辑 删除
定时做数据库恢复测试sqlserver
CREATE DATABASE [test20090821] ON PRIMARY (NAME = N'test20090821_Data', FILENAME = N'f:sql_dbtest20090821_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'test20090821_Log', FILENAME = N'f:sql_logtest20090821_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)alter database test20090821 set OFFLINE RESTORE DATABASE test20090821 FROM disk='F:SQL_DBVimicro_Ax30_SP4_FORMAL_02_2300' WITH REPLACE, RECOVERY ,move 'Vimicro_Ax30_SP4_FORMAL_Data' to 'F:SQL_DBtest20090821_Data.MDF', move 'Vimicro_Ax30_SP
-
编辑 删除
缩小日志大小，截断日志；然后shrink
--截断日志backup log test20081208 with NO_LOG backup log test20081127 with NO_LOG --收缩数据库，释放空间给osDBCC SHRINKDATABASE (test20081208)DBCC SHRINKDATABASE (test20081127) [@more@]
