Friday, March 23, 2012

Log Shipping problem

Dear Friends
I have a SQL Standard version and due to same i am not
able to do the log shipping for the database i want to
create a backup server which is only for analysis and the
same need to update only once. I can not set the
replication between the server as the Database is not
compatible for the same it is having 1024 column in many
tables.
Now What i have done is created a maintaince plan for the
backup and transactional backup in a 24 hours.
The same are replicated to the other server hard drive
with Data Replication service.
I want to create a job which will automatically restore
the transaction log on the analysis server.
Please suggest how can i achive the same. Your earlier
reply would help me a lot.
Best regards
Sharad
Take a look at the walkthrough and make sure you have only ONE database
selected at a time in the DB Maint Planner and it's in Full Recovery mode
when you have decided which one to select.
http://www.microsoft.com/technet/pro.../logship1.mspx
Hope this helps
Paul.

No comments:

Post a Comment