Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    2

    Unanswered: restore a database

    Hi,
    I have a msde backup file.
    I want restore a database with this backup file, but i get
    the following error :"Error 3256
    The backup set on device '%ls' was terminated while it was being created and is incomplete. RESTORE sequence is terminated abnormally"
    I suspect that the .ldf file is damaged.
    How i can manage this situation ?
    Can I restore a database without a transaction log.
    Others backups are not avalaible.
    Could you help me?
    Thanks

    Giano

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    To attach the database you should have .MDF which should be properly detached earlier. Your query refers to backup file that means it may be .bak file or to a backup device.

    And 3256 error indicates that the backup set is not complete because the backup operation that created the backup set did not finish successfully.

    So make sure to take full backup without any interruption.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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