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 |
|
venu_93
Starting Member
2 Posts |
 Posted - 2004-09-09 : 12:12:22
|
| Hi I have developed an application(VB) which is setup in different branches . we need to update the database from each brach at CENTRAL office.we generate a Differential backup(Present days transactions) frome each branch and upload to central office. we have created a Databse for each branch at Central office .question is ...1. Is there any script which Updates Diferential backup file to the existing database .2. is there any better way of achieving the same task.thanksVENU |
|
|
n/a
deleted
35 Posts |
Posted - 2004-09-09 : 12:52:22
|
| I do nto think a differential backup will work here. A diff. backup contains all transactions since the last full backup. so you your do a full backup, then a diff backup, then another diff backup; the second diff backup will contain all the information in the first diff backup. so after a few backups you are not saving much in time or space. the syntac to restore fromt he diff file is RESTORE DATABASE MyNwind FROM DISK='path and filename'for this to work your SQLService account has to have access to the recovery file.another way to do this would be replication. I would read up on that and see if it will work for you.HTHPaul |
 |
|
|
venu_93
Starting Member
2 Posts |
Posted - 2004-09-10 : 07:41:57
|
| Hi paul, Thank you. Is the below solution ok for my prob:1.Take a Full backup of database for First time ( One time operation)2. take a Differential backup daily at the end of day 3. Update dataabse at Central office with the new differential baclup File. or any other better methods ..please do let me knowregardsVENU |
|
|
|
|
|
|
attach Differential backup file