"Rogers" <Rogers@discussions.microsoft.com> wrote in message
news:ACC08DB9-FCA1-4EB8-AFD2-4DAFB3D2BE98@microsoft.com...
>I want to ask one question regarding copying the full backup, differential
> and then log into another machine and
> restore automatically but I want to know about the recovery mode I have to
> set on that machine so that only read
> and restoration can be take place and Yes I don't want to create the
> disaster recovery plan.
>
> Can anyone add his/her comments.
>
> Thanks

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:uYv$sqDPFHA.2748@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Recovery model will not really matter since you are going to keep the
> database in READ_ONLY mode. See the below command
> to set the database to READ ONLY mode.
>
> ALTER DATABASE <DBNAME> SET READ_ONLY
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "Rogers" <Rogers@discussions.microsoft.com> wrote in message
> news:ACC08DB9-FCA1-4EB8-AFD2-4DAFB3D2BE98@microsoft.com...
> >I want to ask one question regarding copying the full backup,
differential
> > and then log into another machine and
> > restore automatically but I want to know about the recovery mode I have
to
> > set on that machine so that only read
> > and restoration can be take place and Yes I don't want to create the
> > disaster recovery plan.
> >
> > Can anyone add his/her comments.
> >
> > Thanks
>
>

"John" <naissani@hotmail.com> wrote in message
news:uCaXLEMPFHA.1096@tk2msftngp13.phx.gbl...
> So, in the read only mode we can restore the database right...
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
> news:uYv$sqDPFHA.2748@TK2MSFTNGP09.phx.gbl...
>> Hi,
>>
>> Recovery model will not really matter since you are going to keep the
>> database in READ_ONLY mode. See the below command
>> to set the database to READ ONLY mode.
>>
>> ALTER DATABASE <DBNAME> SET READ_ONLY
>>
>> Thanks
>> Hari
>> SQL Server MVP
>>
>>
>> "Rogers" <Rogers@discussions.microsoft.com> wrote in message
>> news:ACC08DB9-FCA1-4EB8-AFD2-4DAFB3D2BE98@microsoft.com...
>> >I want to ask one question regarding copying the full backup,
> differential
>> > and then log into another machine and
>> > restore automatically but I want to know about the recovery mode I have
> to
>> > set on that machine so that only read
>> > and restoration can be take place and Yes I don't want to create the
>> > disaster recovery plan.
>> >
>> > Can anyone add his/her comments.
>> >
>> > Thanks
>>
>>
>
>