How to Test Log shipping?

Hi,
How do I test that the secondary server can come online, and then just
contiune the log shipping ot the secondary once the test is done?
I know I can always copy the primary db and start over again, but over
a slow network this takes alot of time.
Can I just somehow start shipping new logs even though the db on the
secondary is now recovered? I tried reapplying the last log with the
no-recovery or standby options but to no avail..
Thanksshane wrote:
> Hi,
> How do I test that the secondary server can come online, and then just
> contiune the log shipping ot the secondary once the test is done?
> I know I can always copy the primary db and start over again, but over
> a slow network this takes alot of time.
> Can I just somehow start shipping new logs even though the db on the
> secondary is now recovered? I tried reapplying the last log with the
> no-recovery or standby options but to no avail..
> Thanks
>
I believe you can stop the MSSQLSERVER service, copy the mdf/ldf files
for your database, then start MSSQLSERVER again. The database should
stay in standby mode, and you'll have a second copy of the data files
that you can attach as a new database.|||shane
http://www.sql-server-performance.com/sql_server_log_shipping.asp
"shane" <jtorr_2000@.hotmail.com> wrote in message
news:1150410466.827181.16490@.y41g2000cwy.googlegroups.com...
> Hi,
> How do I test that the secondary server can come online, and then just
> contiune the log shipping ot the secondary once the test is done?
> I know I can always copy the primary db and start over again, but over
> a slow network this takes alot of time.
> Can I just somehow start shipping new logs even though the db on the
> secondary is now recovered? I tried reapplying the last log with the
> no-recovery or standby options but to no avail..
> Thanks
>