SQL Server Log Shipping

I have restored my full backup on the secondary in norecovery mode and am now restoring about 100 or so T-Log backups in norecovery mode. My question is when I get to the last Transaction log can I restore the last log in Standby mode. Then let the Log Shipping jobs take over. Or should I have restored the Full backup in Standby mode from the start and not with NoRecovery.

Thanks In Advance
VitaminDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
In my opinion it depends why you setup log shipping that drives the scenario.
Do you want a stand by server, or is a database server migration, or is rather another SQL box where you need to connect in read-only mode and run some report queries for instance?

Only if you want it available in between T-log restores then use a StandBy otherwise use norecovery until the last T-log and Tail Log were restored on secondary.

And you should start in my opinion with a full database backup on primary(source) then do a restore on secondary(destination) and immediately after that restore is done ENABLE log shipping and let SQL take care of the rest.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.