USE [master]GOALTER DATABASE DB SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DB SET RECOVERY SIMPLE --把数据库设置为简单模式GOUSE DBGODBCC SHRINKFILE (N'DB_log' , 11, TRUNCATEONLY)GO --这里的DN_Log 如...【阅读全文】
Related articles: louisville seeks to end skid vsI believe Madonna is just a talented individual who was trying to have a comeback. She did the Roman 300 thing for shockrock and attention and most assuredly got what she wanted and probably is laughing about all these people thinking it has to...【阅读全文】
还原或删除sql server 2008数据库时,经常烩出现:“因为数据库正在使用,所以无法获得对数据库的独占访问权”,终解决方案如下关键SQL语句: ALTER DATABASE [datebase] SET OFFLINE WITH ROLLBACK IMMEDIATE用完之后再ALTER database [ datebase] set &nb...【阅读全文】