Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    50

    Unanswered: how to back up??????

    Hi all,
    I know how to backup database form full back, diffrential backupp. I ' d like to know how to restore database from transaction log file not from backup file.
    Thanks fro reading.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    A transaction log file does not contain all the data in the database. It just records changes made to the database. Thus, you cannot restore just from a transaction log file. All restores must start with a restoring a database backup, followed by any transaction logs for changes made since the backup.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2004
    Posts
    50
    Originally posted by blindman
    A transaction log file does not contain all the data in the database. It just records changes made to the database. Thus, you cannot restore just from a transaction log file. All restores must start with a restoring a database backup, followed by any transaction logs for changes made since the backup.
    Thanks for your answer,
    so i'd to know where transaction log file is located?

    The best regard,

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    It's located wherever you specified when you initiated transaction log backups. You DID set up transaction log backups, didn't you?

    By default the log backups are stored in the same directory as the database backups (I think...), though you can specify a different location.

    Usually, you don't need to keep know where they are because the msdb database stores a history of backups that is available when you choose to restore a database through Enterprise Manager.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •