SQL 2005 Transaction Logs  15 pts. I am by no means very good at
SQL. I know the basics. I am a network engineer but was recently
asked to do a few tasks in a SQL 2005 environment. I currently
have a database that is residing off-site and I was asked to
import the database and transaction logs so that this server can
be used for reporting purposes only. I have to restore
transaction logs on a daily basis and left the database in
"Standby" "Read Only" Everything is working fine but two things
are happening. One is that I have to do this task everynight
which is rather annoying and secondly I have to restore these
transaction logs one at a time. I try to restore all 26 logs in
order but it will not let me. I can only do one at a time and
that sucks. I am trying to accomplish the following. I want to
be able to have this done automatically and leave the database
in Read Only/Standby when it is done. Can someone point me in
the right directions? Thank you. ASKED: June 9, 2008  4:17 AM
UPDATED: June 10, 2008  6:19