How to change Recovery mode

We can use the codes below to get the recovery mode of a database:
select DatabasePropertyEx('test', 'Recovery')
Now I want to change a database's Recovery to SIMPLE.
How can I do that?Hi ad,
Try: Alter Database <DB Name> Set Recovery Simple
"ad" wrote:

> We can use the codes below to get the recovery mode of a database:
> select DatabasePropertyEx('test', 'Recovery')
> Now I want to change a database's Recovery to SIMPLE.
> How can I do that?
>
>
>

How to bring up warm stabdby server?

Hello, everyone:

I am making disaster recovery plan and considering technical details. My question is that if I configure log shipping and primary server is failed. I have to bring up secondery server online. As warm standby server, the secondary server is Read-only. How to disable read-only?

Thanks

ZYTHello, everyone:

I am making disaster recovery plan and considering technical details. My question is that if I configure log shipping and primary server is failed. I have to bring up secondery server online. As warm standby server, the secondary server is Read-only. How to disable read-only?

Thanks

ZYT
SQL 2000 or SQL 2005?

Do a google for "log shipping sql recovery" or something close to that. There's a document on the MS website that shows how to do it with step-by-step details. It's been so long, I have long since ditched it, but I used to keep a printed copy in my DR handbook.

Regards,

Hugh|||Hi Hugh:

I am running SQL 2000.

Thanks for the advices. I read a ton of papers. Almost all papers are from BOL to recommend last restore transaction log backup from primary server with recovery. I am conderning if it is for sure the secondary server can resume general model from read-only after restoration. Does any one have real experience? If the secondary server runs online with Real-only, that is a big trouble.

ZYT

SQL 2000 or SQL 2005?

Do a google for "log shipping sql recovery" or something close to that. There's a document on the MS website that shows how to do it with step-by-step details. It's been so long, I have long since ditched it, but I used to keep a printed copy in my DR handbook.

Regards,

Hugh|||Hello, everyone:

I would like share this point with you. My testing was executed by "How to: Set Up, Maintain, and Bring Online a Warm Standby Server (Transact-SQL)" in BOL step by step. After restore from last transaction log backup from primary server WITH RECOVERY. Like,

RESTORE LOG northwind1
FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL$Subscription_srv\Log\Northwind_tlog_2 00407111530.TRN'
WITH RECOVERY

Refresh secondary database, it become general model from Read-Only.

Thanks

ZYT