|
Home > Archive > MS SQL Server > March 2006 > Standby Mode
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Kevin Antel 2006-03-09, 1:23 pm |
| Is there a Transact SQL Statement you can use to put a database in
Standby/Read-Only mode?
Thanks.
| |
| Robert Ellis 2006-03-09, 1:23 pm |
| Hi,
If you are using SQL 2000 (or later) you can set database options using
ALTER DATABASE... (( SINGLE USER || READ_ONLY ))
If you are using an earlier version, check out 'sp_dboption'. Check out
the syntax in Books Online.
Robert
"Kevin Antel" <kevina@cqlcorp.com> wrote in message
news:%23gQYuA6QGHA.4952@TK2MSFTNGP09.phx.gbl...
> Is there a Transact SQL Statement you can use to put a database in
> Standby/Read-Only mode?
>
> Thanks.
>
| |
| Tibor Karaszi 2006-03-10, 3:23 am |
| The "read/only" mode is confusing, so we first need to ask you to clarify exactly which type of
read-only mode you refer to?
Do you refer to the one that Robert talks about in his post? If so, see Robert's post.
OR, do you refer to the one which is really standby, i.e., the one you get when you restore a backup
using the STANDBY option? If so, no, restoring a backup using the standby option is the only way to
get a database into this state. This is no surprise considering that the option mean (for SQL Server
to have an undo file containing the UNDO operations it did in the prior restore operations so it can
undo these undo operations).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Kevin Antel" <kevina@cqlcorp.com> wrote in message news:%23gQYuA6QGHA.4952@TK2MSFTNGP09.phx.gbl...
> Is there a Transact SQL Statement you can use to put a database in Standby/Read-Only mode?
>
> Thanks.
>
|
|
|
|
|