Transaction Log ??

From: Shamim (shamim.abdul@railamerica.com)
Date: 07/22/02 

From: "Shamim" <shamim.abdul@railamerica.com>
Date: Mon, 22 Jul 2002 11:48:51 -0500

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: Restoring from non-truncated transaction log
    ... The transaction log is there to support transactional consistency as well ... as supporting "incremental" backup. ... A database backup contains both data pages as well as the necessary log records (from the ... When your restore a database backup, ...
    (microsoft.public.sqlserver.server)
  • Re: POINT IN TIME RESTORE
    ... Perform a transaction log backup of the original database (If you have ... Restore the subsequent transaction log files in order of backup WITH ...
    (microsoft.public.sqlserver.server)
  • Re: Large Transaction Log Backup after Database Backup
    ... script and see for yourself that the database backup doesn't truncate the ... ALTER DATABASE steve SET RECOVERY FULL ... But my understanding was that the transaction log was> truncated after a full database backup. ...
    (microsoft.public.sqlserver.server)
  • Re: Error in restoring database from .BAK file
    ... No you cant restore the trasaction log file alone. ... Destination database is standby to ur production database(destination ... database must be in read only mode to acept the transaction log) ... Restore full database backup with NORECOVERY (You should have a full ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction Log Size
    ... Backup database does not empty the transaction log files. ... How to Shrink the SQL Server 7.0 Transaction Log ...
    (microsoft.public.sqlserver.server)