\u5fa9\u5143\u51e6\u7406\u4e2d\uff64\u5bb9\u91cf\u4e0d\u8db3\u3067\u30a8\u30e9\u30fc\u8868\u793a\uff61<\/p>\n
\u307e\u305a\uff64
\ncompmgmt.msc>\u8a18\u61b6\u57df>\u30c7\u30a3\u30b9\u30af\u7ba1\u7406>C:>\u30dc\u30ea\u30e5\u30fc\u30e0\u306e\u62e1\u5f35
\n\u3092\u5b9f\u65bd(\u74b0\u5883\u306b\u3088\u3063\u3066\uff64\u901a\u5e38\u52b9\u679c\u306f\u306a\u3044)<\/p>\n
\u6b21\u306b\uff642\u56de\u306b\u5206\u3051\u3066\u5fa9\u5143\u3057\uff64\u5727\u7e2e\u3092\u5b9f\u65bd\u3057\u305f\uff61(1\u5ea6\u76ee\u306e\u5fa9\u5143\u5f8c\u306b\u4e0b\u8a18\u5b9f\u65bd\u3057\uff64\u6b8b\u308a\u3092\u5fa9\u5143)<\/p>\n
USE master; -- master \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3002sys.databases \u30d3\u30e5\u30fc\u3092\u53c2\u7167\u3059\u308b\u305f\u3081\u3002\r\nGO\r\n\r\n-- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u683c\u7d0d\u3059\u308b\u5909\u6570\u3092\u5ba3\u8a00\r\nDECLARE @DBName NVARCHAR(MAX);\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u3092\u5ba3\u8a00\u3057\u3066\u3001\u30b7\u30b9\u30c6\u30e0\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9664\u5916\u3057\u305f\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u53d6\u5f97\r\nDECLARE db_cursor CURSOR FOR\r\nSELECT name \r\nFROM sys.databases\r\nWHERE name NOT IN ('master', 'model', 'msdb', 'tempdb') -- \u30b7\u30b9\u30c6\u30e0\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9664\u5916\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u3092\u958b\u304f\uff08\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30ea\u30b9\u30c8\u3092\u6e96\u5099\uff09\r\nOPEN db_cursor;\r\n\r\n-- \u6700\u521d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u30ab\u30fc\u30bd\u30eb\u304b\u3089\u53d6\u5f97\r\nFETCH NEXT FROM db_cursor INTO @DBName;\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u3067\u53d6\u5f97\u3057\u305f\u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u7e70\u308a\u8fd4\u3057\u51e6\u7406\u3092\u5b9f\u884c\r\nWHILE @@FETCH_STATUS = 0\r\nBEGIN\r\n -- \u5727\u7e2e\u30b3\u30de\u30f3\u30c9\u3092\u683c\u7d0d\u3059\u308b\u5909\u6570\u3092\u5ba3\u8a00\r\n DECLARE @SQL NVARCHAR(MAX);\r\n\r\n -- DBCC SHRINKDATABASE \u30b3\u30de\u30f3\u30c9\u3092\u52d5\u7684SQL\u3068\u3057\u3066\u69cb\u7bc9\r\n -- \u3053\u3053\u3067\u306f\u300110% \u306e\u7a7a\u304d\u9818\u57df\u3092\u6b8b\u3057\u3066\u5727\u7e2e\u3059\u308b\u8a2d\u5b9a\uff08\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u5909\u66f4\u53ef\u80fd\uff09\r\n SET @SQL = 'DBCC SHRINKDATABASE (\"' + @DBName + '\", 10);';\r\n\r\n -- \u5b9f\u884c\u3055\u308c\u308b\u30b3\u30de\u30f3\u30c9\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306b\u51fa\u529b\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09\r\n PRINT @SQL; -- \u5b9f\u969b\u306e\u5727\u7e2e\u30b3\u30de\u30f3\u30c9\u304c\u4f55\u304b\u78ba\u8a8d\u3057\u305f\u3044\u5834\u5408\u306b\u5f79\u7acb\u3064\r\n\r\n -- \u69cb\u7bc9\u3057\u305f SQL \u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\r\n EXEC sp_executesql @SQL;\r\n\r\n -- \u6b21\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u30ab\u30fc\u30bd\u30eb\u304b\u3089\u53d6\u5f97\r\n FETCH NEXT FROM db_cursor INTO @DBName;\r\nEND;\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u64cd\u4f5c\u304c\u5b8c\u4e86\u3057\u305f\u3089\u9589\u3058\u308b\r\nCLOSE db_cursor;\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u306e\u30e1\u30e2\u30ea\u3092\u89e3\u653e\r\nDEALLOCATE db_cursor;\r\nGO\r\n<\/pre>\n\u3082\u3057\u4e00\u62ec\u3067DB\u3092\u524a\u9664\u3059\u308b\u5834\u5408<\/p>\n
USE master; -- master \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\r\nGO\r\n\r\nDECLARE @DatabaseName NVARCHAR(128);\r\nDECLARE @SQL NVARCHAR(MAX);\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u3092\u5ba3\u8a00\u3057\u3066\u3001\u524a\u9664\u5bfe\u8c61\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u53d6\u5f97\r\nDECLARE db_cursor CURSOR FOR\r\nSELECT name \r\nFROM sys.databases\r\nWHERE name NOT IN ('master', 'model', 'msdb', 'tempdb') -- \u30b7\u30b9\u30c6\u30e0\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9664\u5916\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u3092\u958b\u304f\r\nOPEN db_cursor;\r\n\r\n-- \u6700\u521d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u53d6\u5f97\r\nFETCH NEXT FROM db_cursor INTO @DatabaseName;\r\n\r\n-- \u3059\u3079\u3066\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u7e70\u308a\u8fd4\u3057\u51e6\u7406\r\nWHILE @@FETCH_STATUS = 0\r\nBEGIN\r\n -- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30b7\u30f3\u30b0\u30eb\u30e6\u30fc\u30b6\u30fc\u30e2\u30fc\u30c9\u306b\u8a2d\u5b9a\u3057\u3001\u63a5\u7d9a\u3092\u5f37\u5236\u5207\u65ad\r\n SET @SQL = 'ALTER DATABASE \"' + @DatabaseName + '\" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;';\r\n PRINT @SQL; -- \u5b9f\u884c\u3055\u308c\u308b\u30b3\u30de\u30f3\u30c9\u3092\u78ba\u8a8d\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09\r\n EXEC sp_executesql @SQL;\r\n\r\n -- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u524a\u9664\r\n SET @SQL = 'DROP DATABASE \"' + @DatabaseName + '\";';\r\n PRINT @SQL; -- \u5b9f\u884c\u3055\u308c\u308b\u30b3\u30de\u30f3\u30c9\u3092\u78ba\u8a8d\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09\r\n EXEC sp_executesql @SQL;\r\n\r\n -- \u6b21\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u53d6\u5f97\r\n FETCH NEXT FROM db_cursor INTO @DatabaseName;\r\nEND;\r\n\r\n-- \u30ab\u30fc\u30bd\u30eb\u3092\u9589\u3058\u3066\u89e3\u653e\r\nCLOSE db_cursor;\r\nDEALLOCATE db_cursor;\r\nGO\r\n<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
\u5fa9\u5143\u51e6\u7406\u4e2d\uff64\u5bb9\u91cf\u4e0d\u8db3\u3067\u30a8\u30e9\u30fc\u8868\u793a\uff61 \u307e\u305a\uff64 compmgmt.msc>\u8a18\u61b6\u57df>\u30c7\u30a3\u30b9\u30af\u7ba1\u7406>C:>\u30dc\u30ea\u30e5\u30fc\u30e0\u306e\u62e1\u5f35 \u3092\u5b9f\u65bd(\u74b0\u5883\u306b\u3088\u3063\u3066\uff64\u901a\u5e38\u52b9\u679c\u306f\u306a\u3044) \u6b21\u306b\uff642\u56de\u306b\u5206\u3051\u3066\u5fa9\u5143\u3057\uff64\u5727\u7e2e\u3092\u5b9f\u65bd\u3057\u305f … <\/p>\n