Log Shipping problem - 03-15-2005 , 05:47 AM
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
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.
Log Shipping problem - 03-15-2005 , 06:08 AM
Let's say you are doing daily log backups, and daily
database backups on the publishing server. I'd create a
log backup job on the primary server which'll backup the
log to a device (file) and overwrite it. This way, the
log file will be identical each time. Have another step
in the job copy over the backup file to the standby
server by using a network share. Once you can determine
how long the backup and transfer take, you can add on a
bit of contingency time and create a job on the standby
server to run at the appropriate time which'll pick up
the backup file. This will do a restore from the file
with the standby option to allow access. You must ensure
nobody is on the database at the time of the restore, so
an initial step might remove all users.
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: