摘要: USEDatabaseName Go --Get DB/LOG fileid and name SELECTfile_id,name FROMsys.database_files; GO --Check if there is old active transaction preventing shrinking db log DBCCOPENTRAN(DatabaseName)WITHTabl... 阅读全文
posted @ 2011-04-23 09:41 Allen Xu 阅读(267) 评论(0) 推荐(0) 编辑