Re: Transaction Log ??

From: Cameron (cgmergel@hotmail.com)
Date: 07/26/02 

From: "Cameron" <cgmergel@hotmail.com>
Date: Fri, 26 Jul 2002 09:39:45 -0700

Shamim,

I used this the other day to recover one of my databases.

Cameron
Intuitive Mfg. Systems

RESTORE DATABASE IERP52Test
   FROM DISK = 'd:\IERPSRV\IERP52Test\Backup\IERP52Test_db_200207240100.bak'
   WITH NORECOVERY
GO
RESTORE LOG IERP52Test
   FROM DISK =
'd:\IERPSRV\IERP52Test\Backup\IERP52Test_tlog_200207240600.trn'
   WITH NORECOVERY
GO
RESTORE LOG IERP52Test
   FROM DISK =
'd:\IERPSRV\IERP52Test\Backup\IERP52Test_tlog_200207240900.trn'
   WITH NORECOVERY
GO
RESTORE LOG IERP52Test
   FROM DISK =
'D:\IERPSRV\IERP52Test\Backup\IERP52Test_TLOG_200207241200.TRN'
   WITH RECOVERY, STOPAT = 'Jul 24, 2002 10:15 AM'

"Shamim" <shamim.abdul@railamerica.com> wrote in message
news:#5Hi9$ZMCHA.2456@tkmsftngp09...
> HI All,
> SQL SERVER 7.0
>
> Iam in the process of restoring a database from last night complete backup
> and then applying transaction log till the recent (we backup transaction
log
> every 30 minutes).
>
> Transaction Log backups are stored with the name DB_tlog_200207221030 (for
> todays 10.30 backup).
>
> In Enterprise Manager, when trying to restore it shows only the complete
> backup. How to look at all the transaction log??
>
> In database Transaction Log is pointed to :d\....\dbLog.LDF.
> If I want to use T-SQL
> Example says
>
> RESTORE LOG MyDB FROM MyDB_Log1 WITH NORECOVERY
>
> What is MyDB_Log1 ??? is it transaction log filename ?? If so, should i
have
> to give the full filename ??
>
> Please help/Advice.
>
> Thanks
> Shamim
>
>

Relevant Pages

  • Re: Setting up Test database using back/restore part 2
    ... NORECOVERY option - This options set the database to loading status and it ... allows you to restiore the transaction log backup. ... Restore database with recovery ...
    (microsoft.public.sqlserver.server)
  • Re: Restore transaction log
    ... > So i checked some messages on the newsserver and tried to restore the ... > database with NORECOVERY but then the database remains loading and the ... > step to restore the transaction log doesn't work. ...
    (microsoft.public.sqlserver.programming)