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 |
|
nhuanlieu
Starting Member
27 Posts |
 Posted - 2009-03-18 : 19:57:58
|
| Hi, how do grant a login access to that db when that db is in "StandBy /ReadOnly" mode (after a trans log restore each hour). When I tried, I gets "Failed to update database...because the database is read-only".If i flips it a ALTER DATABASE db_name WITH RECOVERY and then grants it, it will work, but my subsequent T-log restores (append) no longer works.Thanks. |
|
|
|
|
|
How do grant access when it's in "StandBy" mode?