Log Shipping Question

Hi,
I would like to implement Log Shipping to my company and I have everything
set up and work fine. However, I am not sure how to ship the database backu
p
file to the destination server after the first time. Since the log shipping
function only ships the log file, if I want to also ship the backup file,
what i need to do?
I have log shipping set up every 15 mins from 8:30 a.m. to 5:30 p.m.
(regular working hour). However, I would like to restore the database backu
p
at night 3:00 a.m. but the log shipping doesn't provide the database copy an
d
restore... I need to write the script by myself? like copy //... ... and
write the Retore command?
Please advise.
Thanks
EdIf you are using the built-in log shipping mechanism in SQL Server ( which
is a part of the Database Maintenance Plan wizard ), it allows you to ship
the initial snap shot of the database and the subsequent logs. Once the
initial snap shot ( full database backup file ) is copied and restored at
the destination server, the log backup shipping starts.
Alternatively, you can write up your own backup/ copy/ restore scripts with
a table or two maintaining the log file names and history of actions, which
many DBAs find very easy and simple to manage. It also allows them to have
customized alerting mechanisms and provides for easy recovery/reapply
options in case of out of sync issues between the source and destinations.
Anith