????SQL Server???????????????????????C???У??????????е?洢??????????C?????????????????????????????????????????????????????????????
????1???????е?????????
????ALTER DATABASE DB1 SET OFFLINE WITH ROLLBACK IMMEDIATE;
????2????????????????μ?λ??
?????????????????????????-????-???-???????????????Authenticated Users-??????????????????????????????????
?????м????????????
??????? 5120?????? 16???? 101???? 17 ??
????????????????“D:MSSQLDATA estdb.mdf”???????????? 5:“5(????????)”??
??????? 5120?????? 16???? 101???? 17 ??
????????????????“D:MSSQLDATA estdb _log.ldf”???????????? 5:“5(????????)”??
??????? 5181?????? 16???? 5???? 17 ??
???????????????????“ctrip”??????????????????
??????? 5069?????? 16???? 1???? 17 ??
????ALTER DATABASE ???????
????3?????????????????????
????ALTER DATABASE DB1 MODIFY FILE(NAME = DB1?? FILENAME = X:SQLServerDB1.mdf);
????ALTER DATABASE DB1 MODIFY FILE(NAME = DB1_Log?? FILENAME = X:SQLServerDB1_Log.ldf);
????4????????????????
????ALTER DATABASE DB1 SET ONLINE;