|
Home > Archive > MS SQL Server > February 2006 > SQL Server Backup w/ both Tape(Complete) & Disk(Differential) Scenario
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server Backup w/ both Tape(Complete) & Disk(Differential) Scenario
|
|
| mr.maoji@gmail.com 2006-02-06, 1:23 pm |
| Hi everyone. This is what I am facing with now,
1. A tape driver which runs Veritas BE 9 to backup DBs (complete
backup, daily)
2. Also, in EM, a SQL Server job to backup DBs to a local hard disk
(differential, every 6 hours)
My question is, if I want to restore, I need to do the following steps
in EM,
1. With the tape, restore the most recent complete backup via Veritas
2. Find the most recent differential backup on disk (timestamp after
the complete backup, for sure) and restore it.
Anyone can tell me if I am correct on this? Thanks!
| |
|
|
mr.maoji@gmail.com wrote:
> Hi everyone. This is what I am facing with now,
>
> 1. A tape driver which runs Veritas BE 9 to backup DBs (complete
> backup, daily)
> 2. Also, in EM, a SQL Server job to backup DBs to a local hard disk
> (differential, every 6 hours)
>
> My question is, if I want to restore, I need to do the following steps
> in EM,
> 1. With the tape, restore the most recent complete backup via Veritas
> 2. Find the most recent differential backup on disk (timestamp after
> the complete backup, for sure) and restore it.
>
> Anyone can tell me if I am correct on this? Thanks!
| |
|
|
mr.maoji@gmail.com wrote:
> Hi everyone. This is what I am facing with now,
>
> 1. A tape driver which runs Veritas BE 9 to backup DBs (complete
> backup, daily)
> 2. Also, in EM, a SQL Server job to backup DBs to a local hard disk
> (differential, every 6 hours)
>
> My question is, if I want to restore, I need to do the following steps
> in EM,
> 1. With the tape, restore the most recent complete backup via Veritas
> 2. Find the most recent differential backup on disk (timestamp after
> the complete backup, for sure) and restore it.
>
> Anyone can tell me if I am correct on this? Thanks!
That is what I have found in using CA Enterprise backup and I am sure
it works the same. They state if you turn off MS backup that their
product will work correctly and we are in the process of testing this.
|
|
|
|
|