Re: Error in restoring database from .BAK file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 18:43:32 +0530

Hi Vikas,

No you cant restore the trasaction log file alone. Transaction log can be
restored only in below occasions:-

1. Destination database is standby to ur production database(destination
database must be in read only mode to acept the transaction log)

Other option is :-

1. Restore full database backup with NORECOVERY ( You should have a full
database backup file)
2. After the full database restore, Follow the Transaction log restore

--------------------------------------
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.

-------------------------------------

Tiber mentioned that ur backup file will be having more than one file, this
can be identified by issuing RESTORE HEADERONLY
with the command. If you have multiple files then you have to use
FILE=file_number during restore.

Thanks
Hari
MCDBA

"vikkas" <anonymous@discussions.microsoft.com> wrote in message
news:CDB0E09D-4EEB-4C46-A968-2FBD1B9F9D15@microsoft.com...
> Again Thnx,
>
> But let me know that can i restore from this transaction log backup file
without having database.. Bcoz i don't have database and try to restore
database from this transaction log backup file.
>
> Vikkas
> --------------------------------------------------------------------------
------------------------------------------------------------------------
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • 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: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (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)