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 change licensing modes

I installed SQL 2K on a per user basis and now want to change that to a per
processor licensing mode. Cant seem to do that change from Control Panel and
do now wish to reinstall .. Is there a way ?http://www.tkdinesh.com/faq/ans/license.html
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#szsZX#pDHA.1496@.TK2MSFTNGP11.phx.gbl...
> I installed SQL 2K on a per user basis and now want to change that to a
per
> processor licensing mode. Cant seem to do that change from Control Panel
and
> do now wish to reinstall .. Is there a way ?
>

How to change Ip address

I have changed Ip address(e.g from 192.168.1.x to 172.16.1.x) on a cluster
with a/p mode.When I have done this,I found the cluster is not work.
Event view said instance cant bind with 1433,however 1433 is in listening
state.
You changed the nodes IP, then the cluster IP, then SQL IP? All in the same
subnet? What range is your private now?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"news.microsoft.com" <2004@.5any.com> wrote in message
news:%23XdNzdN6EHA.2016@.TK2MSFTNGP15.phx.gbl...
>I have changed Ip address(e.g from 192.168.1.x to 172.16.1.x) on a cluster
> with a/p mode.When I have done this,I found the cluster is not work.
> Event view said instance cant bind with 1433,however 1433 is in listening
> state.
>

How to bring existing Database in standy mode of secondary server for logshippin

Hi,

I am doing a logshipping in sqlserver2000.
I have PrimaryServer database A and Secondaryserver A which is already existing. Now if i am trying to establish logshipping with this existing db in secondaryserver it says db A in destination is not in standy mode.

Please help me how to bring the db in standy mode that can be used to do logshipping.

Thanks
Md S.HassanMy guess would be:

RESTORE DATABASE dbName WITH STANDBY|||Hi Roa

I am getting this error message after trying with your suggestion

Server: Msg 155, Level 15, State 1, Line 1
'STANDBY' is not a recognized RESTORE option.