Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2009-09-04 : 18:41:23
|
| We have a temporary server set up for training. I was setting up maintenance plans to back up the databases on the server. I set up full and transaction log backups. The full backups appeared to work fine (including model and reportserver db's). The transaction log backup (model and reportserver db's) failed with this message:BACKUP LOG [ReportServer] TO DISK = N'C:\\aaaaaa..." failed with the following error: "Exclusive access could not be obtained because the database is in use.BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Also, my bigger concern, management studio is showing the model database being in a restoring state and I can't access it. Why is it in a restoring state? What can I do to resolve the situation? I'm not sure why it thinks it's restoring the model db, but would like to get it back to a stable state. |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2009-09-10 : 16:11:30
|
| this command gets it back to a normal stateRESTORE DATABASE MODEL WITH RECOVERY |
 |
|
|
lisali
Starting Member
1 Post |
Posted - 2009-10-21 : 09:02:39
|
| I have the same problem and like to know answer about how to fix backing up transaction log issue. |
|
|
|
|
|
|
model database issue