Tuesday, March 20, 2012

Applying Tran logs in SQL 2000

Hi,
I have a SQL 2k database thats around 200 GB in size. I have restored this
from a backup, but while restoring I failed to realise that I needed to apply
tran logs (didnt specify NORECOVERY) once the full backup was restored.
There are 6 tran log files to apply now.
Can I do this without once again restoring the database (with NORECOVERY)? I
am asking this because it will save a lot of time.
Thank you.
Regards,
KarthikNo, once you did RECOVERY, you can't restore any more backups, since SQL Server performed the UNDO
phase. The other way around is possible, though...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:DAC80787-AC08-47B8-8046-CCF6DD770639@.microsoft.com...
> Hi,
> I have a SQL 2k database thats around 200 GB in size. I have restored this
> from a backup, but while restoring I failed to realise that I needed to apply
> tran logs (didnt specify NORECOVERY) once the full backup was restored.
> There are 6 tran log files to apply now.
> Can I do this without once again restoring the database (with NORECOVERY)? I
> am asking this because it will save a lot of time.
> Thank you.
> Regards,
> Karthik|||Hi,
You cant. You need to start the full database restore again with NORECOVERY
option.
SQL Server requires that the WITH NORECOVERY option be used on all but the
final RESTORE statement when restoring a database
backup and multiple transaction logs. NORECOVERY Instructs the restore
operation to not roll back any uncommitted transactions
Thanks
Hari
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:DAC80787-AC08-47B8-8046-CCF6DD770639@.microsoft.com...
> Hi,
> I have a SQL 2k database thats around 200 GB in size. I have restored this
> from a backup, but while restoring I failed to realise that I needed to
> apply
> tran logs (didnt specify NORECOVERY) once the full backup was restored.
> There are 6 tran log files to apply now.
> Can I do this without once again restoring the database (with NORECOVERY)?
> I
> am asking this because it will save a lot of time.
> Thank you.
> Regards,
> Karthik

No comments:

Post a Comment