A warm-standby database is read-only

Does anyone out there know how to get a database out of
warm-standby mode so it's not read-only and I can shrink
the database?
Thanks,
DonnaUSE master
EXEC sp_dboption 'pubs', 'read only', 'FALSE'
hth
Eric
"Donna" <anonymous@.discussions.microsoft.com> wrote in message
news:1076d01c3be99$fa79b5e0$a601280a@.phx.gbl...
> Does anyone out there know how to get a database out of
> warm-standby mode so it's not read-only and I can shrink
> the database?
> Thanks,
> Donna|||RESTORE DATABASE dbname WITH RECOVERY
But you won't be able to restore anymore transaction log or diff backups
after that.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Donna" <anonymous@.discussions.microsoft.com> wrote in message
news:1076d01c3be99$fa79b5e0$a601280a@.phx.gbl...
> Does anyone out there know how to get a database out of
> warm-standby mode so it's not read-only and I can shrink
> the database?
> Thanks,
> Donna