운영/백업과 복원
2014. 3. 17.
How to Attach a SQL Server Database without a Transaction Log and with Open Transactions
Problem You want to attach a SQL Server database that does not have the transaction log file and you get the following error when you try to attach the data file: "The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manuall..