Thursday, March 29, 2012

DB Backup and restoration

Hi, There,
I am going to schedule the live database backup and restoration to the
remote site on daily basis.
The correct procedure:
1. Sunday full db backup-->Restored on remote server
2. Daily differential backup from Monday to Saturday--> Restored on remote
server with the same squence.
3. Again database was sync with full db backup on the 2nd Sunday.
However, for some reason, the following actual procedure happen:
1. Daily DB full backup at 5:00AM in the morning
2. Daily Differential backup at 4:50AM bf the full backup happen
3. Restore the sunday full DB on remote site
4. Followed by daily differential back which happen at 4:50am daily.
Due to the huge side of the DB, I could not ship the daily DB to the remote
site. And I hv problem to restore those differential backup, so I am
wondering whether this is possible, if not, How can I achiev the same.
Thanks for any information!
ShermaineI am not sure for what purpose you are restoring this database, but for
large database you can look for option of replication or logshipping
or mirroring instead of copy backup daily and restore it.
Regards
Amish Shah
http://shahamishm.tripod.com
xiaomei wrote:
> Hi, There,
> I am going to schedule the live database backup and restoration to the
> remote site on daily basis.
> The correct procedure:
> 1. Sunday full db backup-->Restored on remote server
> 2. Daily differential backup from Monday to Saturday--> Restored on remot
e
> server with the same squence.
> 3. Again database was sync with full db backup on the 2nd Sunday.
> However, for some reason, the following actual procedure happen:
> 1. Daily DB full backup at 5:00AM in the morning
> 2. Daily Differential backup at 4:50AM bf the full backup happen
> 3. Restore the sunday full DB on remote site
> 4. Followed by daily differential back which happen at 4:50am daily.
> Due to the huge side of the DB, I could not ship the daily DB to the remo
te
> site. And I hv problem to restore those differential backup, so I am
> wondering whether this is possible, if not, How can I achiev the same.
> Thanks for any information!
> Shermaine|||Hi, Amish,
The reason is the production server and develop team located in different
country.
Some time the develop team need check the live database, however we did not
allow them to direct connect the the live server.
Replication and logshipping via internet is very cost solution, we are not
going to implement that for this purpose only. And due to the huge size of
the DB, it is not psossible for sync the full db backup on daily baisis.
I schedule to upload the daily differential backup to remote office server
daily, and the following day, they will restore the backup there.
The DB full backup(5:00am) and differential backup (4:50am) happen daily, if
I only send the differential backup, will it works after the first time db
was sync with full db backup?
Thanks and best regards
Shermaine
"amish" wrote:

> I am not sure for what purpose you are restoring this database, but for
> large database you can look for option of replication or logshipping
> or mirroring instead of copy backup daily and restore it.
>
> Regards
> Amish Shah
> http://shahamishm.tripod.com
> xiaomei wrote:
>|||According to BOL
A differential backup is based on the most recent, preceding data
backup, which is base backup.A differential backup records only the
data that has changed since its full backup. Before restoring a
differential backup, you must restore its full backup
You can schedule log shipping or create script to zip all log backup of
day and copy to destination server and restore them.
Regards
Amish Shah
http://shahamishm.tripod.com
On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> Hi, Amish,
> The reason is the production server and develop team located in different
> country.
> Some time the develop team need check the live database, however we did no
t
> allow them to direct connect the the live server.
> Replication and logshipping via internet is very cost solution, we are not
> going to implement that for this purpose only. And due to the huge size of
> the DB, it is not psossible for sync the full db backup on daily baisis.
> I schedule to upload the daily differential backup to remote office server
> daily, and the following day, they will restore the backup there.
> The DB full backup(5:00am) and differential backup (4:50am) happen daily,
if
> I only send the differential backup, will it works after the first time db
> was sync with full db backup?
> Thanks and best regards
> Shermaine
>
> "amish" wrote:
>
>
>
>
>
>
>|||Hi, Amish,
Does the Log shipping adopt the simliar technologies as differential backup?
I can schedule the log shipping, however, due to the daily DB full backup
happens on the live server, I aslo need sync the DB with full db backup
daily, because the transaction log also refer to last full db backup or
differential backup or earlier log backup. Else, the log could not be
restored.
Can you help to recommend some document of the difference of implement a log
shipping scheme and a differential bakcup solution, not very clear what are
the disavantages and benifit.
Thanks and regards
Shermaine
"amish" wrote:

> According to BOL
> A differential backup is based on the most recent, preceding data
> backup, which is base backup.A differential backup records only the
> data that has changed since its full backup. Before restoring a
> differential backup, you must restore its full backup
> You can schedule log shipping or create script to zip all log backup of
> day and copy to destination server and restore them.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
> On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:
>|||Log backup is backup of transaction logs.
Logshipping you have to first restore full backup and then all
consecutive transaction log backup. transaction log backup sequence
does not get affected by later on full backup and you dont need to
restore full backup again at destination.
First you should look at different type of backup in Books Online.
Then look at Logshipping. BOL has plenty of information for both.
Regards
Amish Shah
http://shahamishm.tripod.com
On Jan 25, 8:37 am, xiaomei <xiao...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> Hi, Amish,
> Does the Log shipping adopt the simliar technologies as differential backu
p?
> I can schedule the log shipping, however, due to the daily DB full backup
> happens on the live server, I aslo need sync the DB with full db backup
> daily, because the transaction log also refer to last full db backup or
> differential backup or earlier log backup. Else, the log could not be
> restored.
> Can you help to recommend some document of the difference of implement a l
og
> shipping scheme and a differential bakcup solution, not very clear what ar
e
> the disavantages and benifit.
> Thanks and regards
> Shermaine
>
> "amish" wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

No comments:

Post a Comment