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,
Karthik
No, 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

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 appl
y
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 Ser
ver 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 ap
ply
> 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

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

Appending Backedup data During Restore Process

Dear All,

Can i append new database backup to the existing data, while restoring the backedup database? If so give me the solution. I had backups for 30 days backup and trying to restore all these bckups..

During the restore process, i had observed that the previsous data is getting deleted and new data is replaced on it (in the database). But i want to append the new data to the existing data.

Note : The backup format that i had taken for all these 30 days is of Full Backup (not differential backup)

Any solution(s) for the above stated...

Regards,Not possible using FULL BACKUP, you can use TLOG Backups to restore them on this server.