Recovery Mode.

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
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
|||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...[vbcol=seagreen]
> 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...
differential[vbcol=seagreen]
to
>
|||Hi John,
Yes, But while restoring you must use STANDBY (undo file name) file name in
RESTORE DATABASE and RESTORE LOG command.
eg:-
RESTORE DATABASE TESTDB FROM DISK='d:\backup.bak' with
standy='d:\stanby.fil'
After this you could start restoring the Transaction logs based on a
frequency. To load the transaction logs you could use the below command
RESTORE LOG TESTDB FROM DISK='d:\backuplog.bak' with standy='d:\stanby.fil'
Thanks
Hari
SQL Server MVP
"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...
> differential
> to
>
sql