May 10, 2004 at 9:20 am
Hi, I am trying to do do an incremental backup of a Database A on Server1 to a DatabaseB on server 2 located at a different site. Database A is the only one that can receive changes. Database B is only used for querying and reporting. No changes allowed. I am trying to automate the process and perform the incremental backups every night.
Has anyone had to do this before and if so how did they perform it?
What I am thinking of consists of backing up the transaction logs on Database A and ftp-ing them to Server2. THe problem I have is that I am not sure how to apply these transaction logs on server 2. Both Database A on server1 and database B on server 2 have the same name and structure.
Any help would be greatly appreciated. I am a novice in this group so this might seem real easy to some of you.
Both servers are running SQL server 7.0
Thanks,
Gent
May 10, 2004 at 10:59 am
Check out "How to set up, maintain, and bring online a standby server" in BOL. Basically, you have to perform a full backup of Database A, restore Database B with the backup, then apply the log backups to Database B.
Greg
Greg
May 11, 2004 at 7:42 am
What about setting up transaction replication using server1 as the publisher/distributor and server2 as the client? You could schedule this to run nightly or whatever schedule you need.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply