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 backup
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 backup
at night 3:00 a.m. but the log shipping doesn't provide the database copy and
restore...  I need to write the script by myself?  like copy //.... .... and
write the Retore command?

Please advise.

Thanks

Ed

If 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.

Delete and insert data in same transaction!
SQL Jobs Fail but give no error
design question
Huge amounts of unused space...why?
How to save an HTML doc in SQL 2005