Can I do this ?

So I have
a Full DB Backup taken at 7am
a Diff backup taken at 9am
a Diff backup taken at 11am
Can I do this ?
Restore Full DB Backup of 7am with noreceovery followed by
Restore Diff Backup of 9am with noreceovery followed by
Restore Diff Backup of 11am with recovery.
I know I could do a restore of the Full DB Backup of 7am followed by Restore
of Diff backup of 11am with recovery and it will work... But i want to know
if the above will work whereby i restore both the differentials one after
another
Thanks
Hassan wrote:
> So I have
> a Full DB Backup taken at 7am
> a Diff backup taken at 9am
> a Diff backup taken at 11am
> Can I do this ?
> Restore Full DB Backup of 7am with noreceovery followed by
> Restore Diff Backup of 9am with noreceovery followed by
> Restore Diff Backup of 11am with recovery.
> I know I could do a restore of the Full DB Backup of 7am followed by Restore
> of Diff backup of 11am with recovery and it will work... But i want to know
> if the above will work whereby i restore both the differentials one after
> another
> Thanks
Did you try it?
CREATE DATABASE foob;
GO
BACKUP DATABASE foob TO DISK = 'C:\foob.bak' WITH INIT;
BACKUP DATABASE foob TO DISK = 'C:\foob1.bak' WITH DIFFERENTIAL, INIT;
BACKUP DATABASE foob TO DISK = 'C:\foob2.bak' WITH DIFFERENTIAL, INIT;
GO
USE master
RESTORE DATABASE foob FROM DISK = 'C:\foob.bak' WITH REPLACE,
NORECOVERY;
RESTORE DATABASE foob FROM DISK = 'C:\foob1.bak' WITH NORECOVERY;
RESTORE DATABASE foob FROM DISK = 'C:\foob2.bak' WITH RECOVERY;
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Hello Hassan,
You can do that; but will not make much difference. This is more than enough
to restore the FULL database backup with NORECOVERY follwed with
the last DIFFERENTIAL backup with RECOVERY. But for testing you could try
restore both DIFFERENTIAL backup and it will work fine..
Thanks
Hari
"Hassan" <Hassan@.hotmail.com> wrote in message
news:e7azxe8GHHA.3668@.TK2MSFTNGP02.phx.gbl...
> So I have
> a Full DB Backup taken at 7am
> a Diff backup taken at 9am
> a Diff backup taken at 11am
> Can I do this ?
> Restore Full DB Backup of 7am with noreceovery followed by
> Restore Diff Backup of 9am with noreceovery followed by
> Restore Diff Backup of 11am with recovery.
> I know I could do a restore of the Full DB Backup of 7am followed by
> Restore of Diff backup of 11am with recovery and it will work... But i
> want to know if the above will work whereby i restore both the
> differentials one after another
> Thanks
>
sql