Gopher1976
asked on
Can you back up a Log Shipping Database?
Hi All
I have a backup issue which I want to try an resolve.
Basically we have a 'log shipped' copy of our SQL Servers off site which are approximately 15mins behind the Production (On Site) Servers. We also backup a file backup (.bak file) of our database off site directly to tape and this takes about 24hrs+.
Apparentely our company requires a 'warm copy' and a file copy off site, of our production server.
So what I would like to do is try and backup the 'log shipped' database straight to tape - if it is possible?
If I can do this then on a local LAN our backup takes about 4 hrs to tape.
Can anyone help or give me any advice?
Cheers
Gopher
I have a backup issue which I want to try an resolve.
Basically we have a 'log shipped' copy of our SQL Servers off site which are approximately 15mins behind the Production (On Site) Servers. We also backup a file backup (.bak file) of our database off site directly to tape and this takes about 24hrs+.
Apparentely our company requires a 'warm copy' and a file copy off site, of our production server.
So what I would like to do is try and backup the 'log shipped' database straight to tape - if it is possible?
If I can do this then on a local LAN our backup takes about 4 hrs to tape.
Can anyone help or give me any advice?
Cheers
Gopher
why not just copy the logs to tape as well as apply them to the log shipped db?
ASKER
That is one of our ideas - but if one of the logs are corrupt then they will not restore.
The end result is simply that we need to get a full backup of a database to an off site tape drive as quickly as possible.
The end result is simply that we need to get a full backup of a database to an off site tape drive as quickly as possible.
Hi
what is the kind of budget you intend to spend on this. If you are willing to spend on this then you should look at CA xosoft which can do your current log shipping and backup the same data using CA ARCserve backup.
You also have a High availability solution which can bring your SQL server online in CA xosoft.
This is if you intend to invest on a solution. Update if you currently have a backup solution
bhanu
what is the kind of budget you intend to spend on this. If you are willing to spend on this then you should look at CA xosoft which can do your current log shipping and backup the same data using CA ARCserve backup.
You also have a High availability solution which can bring your SQL server online in CA xosoft.
This is if you intend to invest on a solution. Update if you currently have a backup solution
bhanu
ASKER
Hi Bhanu
I think I have a solution to my problem which to be honest is going away from the original question but the results are the same or similar - I just need to confirmation that I am either doing the right thing or going mad!!!!!!!
Ok, basically we have no budget to improve our backup solution as a few years ago we invested in BackupExec licenses (with no SQL license) so they are not keen to spend any more. So what I have decided to do is:
Saturday - Full backup and transfer off site with log backups.
Monday - Full Backup / Differential Base and Logs throughout the day - At the end of the day transfer off site.
Tuesday - Log backups during the day / Differential in the evening with transfer off site.
Wednesday - Log backups during the day / Differential in the evening with transfer off site.
Thursday - Log backups during the day / Differential in the evening with transfer off site.
Friday - Log backups during the day / Differential in the evening with transfer off site.
My theory is, basically, that after the full backup / Differential Base has completed and transfered off site (approx 36 hours), the rest of the week will be filled with logs and differential backups. These should be smaller and transfer quicker.
So in the event of a diaster we only need to restore the full backup, last differential and then the final logs!
How does that sound??
Thanks for your time
Gopher
I think I have a solution to my problem which to be honest is going away from the original question but the results are the same or similar - I just need to confirmation that I am either doing the right thing or going mad!!!!!!!
Ok, basically we have no budget to improve our backup solution as a few years ago we invested in BackupExec licenses (with no SQL license) so they are not keen to spend any more. So what I have decided to do is:
Saturday - Full backup and transfer off site with log backups.
Monday - Full Backup / Differential Base and Logs throughout the day - At the end of the day transfer off site.
Tuesday - Log backups during the day / Differential in the evening with transfer off site.
Wednesday - Log backups during the day / Differential in the evening with transfer off site.
Thursday - Log backups during the day / Differential in the evening with transfer off site.
Friday - Log backups during the day / Differential in the evening with transfer off site.
My theory is, basically, that after the full backup / Differential Base has completed and transfered off site (approx 36 hours), the rest of the week will be filled with logs and differential backups. These should be smaller and transfer quicker.
So in the event of a diaster we only need to restore the full backup, last differential and then the final logs!
How does that sound??
Thanks for your time
Gopher
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.