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 |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2010-04-30 : 11:29:39
|
| Hi guys, I have a sales demo database I can't seem to get out of the read only mode.On the database, the transaction log file was restricted to 2gigs in size. The last action I was told was that some ETLs was running on the server and during that process a power outtage did happen.When I was given the server to repair, the databases had been detached. I reattached them, they went into read only mode. I can't reattach them without the log as it gives me an error message that in read only mode, it can't create a new log file.Whenever I try to modify an option to get out of read only mode or increase log size, it gives me an error it can't write to the log or initiate a transaction. The only thing I was able to do was to change the multi-user to single user mode.It is not a critical database, though it would save some precious time for the sale guy who did some work on this database for his presentation. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Read only database stuck