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 |
|
rstaats
Starting Member
2 Posts |
 Posted - 2009-03-24 : 18:44:36
|
| Very confused, and I feel like this is going to be one of those palm-to-forehead moments once the answer is revealed.Every new database I create is being created in warm standby. (grey icon, Read-Only/Standby) I can create a database that's not read-only, by changing that option in the options section of the SQL management interface's new database creation window, but it still is created in Standby, and I'm unable to get it out of standby. (tried a couple alter database commands with no luck)This server is currently running numberous SQL databases of various sizes (6megs to 70gigs) that are working just dandy. I've created new database via the simple, right-click new database method in the past, give it a name, appropriate size and growth rules, and it's good to go. I don't know what's different this time.Any ideas are greatly appriciated... I'm heading home for the evening, but will be checking on this frequently tomorrow. Thanks in advance for your time. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-03-24 : 19:14:30
|
| Is the model database in read only mode?CODO ERGO SUM |
 |
|
|
rstaats
Starting Member
2 Posts |
Posted - 2009-03-25 : 14:26:45
|
| Model database is a term I'm not familiar with. (promptly goes forth and googles)--EDIT--So, simple concept, I get it now. Yes, my model database is in warm-standby. How do I get it out of warm-standby? Immediate fiddling didn't come up with anything, and both googling and my 1 SQL book didn't help me either.--EDIT AGAIN--RESTORE DATABASE databasename WITH RECOVERYThat worked! I didn't even think of using just a regular command on that model database... wewt! :) Thanks for getting me rolling in the right direction!!! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-25 : 14:36:06
|
| ALTER DATABASE model SET READ_WRITETechnically "warm-standby" is not a database status, it's just "standby". If the above statement doesn't fix it, try:RESTORE DATABASE model WITH RECOVERY |
|
|
|
|
|
|
|
|
Every New Database in Warm Standby