Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gmetaj
Starting Member
33 Posts |
 Posted - 2004-05-10 : 11:12:12
|
| 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. Thanks,Gent |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-05-10 : 11:17:07
|
| Are you using SQL Server Enterpise edition? If so look at log-shipping as your option. If not, read up on snapshot replication as a possibility. Finally if those two are too daunting, look at automating sending the differential (incremental) backup file created from Server A to server B using DTS and restoring the backup (not the log) on Server B.Raymond |
 |
|
|
gmetaj
Starting Member
33 Posts |
Posted - 2004-05-10 : 11:31:53
|
| I am using SQL Server 7.0. I am not sure how to apply transaction logs. Is there a command, or I can do that from the EM. We only need to restore the transaction logs because the other server is out there on the internet and restoring the backup would take to long. Thanks,Gent |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-10 : 13:24:18
|
| Have a look at RESTORE LOG in SQL Server Books Online. That's the command that you'll need to run to restore a transaction log.Tara |
|
|
|
|
|
|
Incremental Backups and Transaction Logs