Results 1 to 7 of 7

Thread: Unable to restore .bak file in sql servr 2005

  1. Dec 6th, 2011, 09:19 AM #1
    ERUM
    ERUM is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2007
    Location
    Karachi
    Posts
    551

    Unable to restore .bak file in sql servr 2005

    I am unable to restore .bak file in sql server 2005 ,Although i took back up from sql server 2005 and restore in the same version,its giving me an error ...

    does any one thing think that .bak is corrupted or whatever... please give me any remedy in that case ..I am also attaching .bak file too...any quick reply is highly appreciated ...



    see image of error while restoring
    Attached Images Attached Images  
    Attached Files Attached Files
    There is no achievement without goals
    Reply With Quote Reply With Quote
  2. Dec 6th, 2011, 09:48 AM #2
    ERUM
    ERUM is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2007
    Location
    Karachi
    Posts
    551

    Re: Unable to restore .bak file in sql servr 2005

    does minor version of sql server 2005 effect on database restoring ??
    There is no achievement without goals
    Reply With Quote Reply With Quote
  3. Dec 6th, 2011, 10:04 AM #3
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Unable to restore .bak file in sql servr 2005

    maybe... I know that a backup from SQL2008SP1 cannot be applied to SQL2008 .... but usually in that case, you get a version error... your error is different. have you tried searching for that error?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  4. Dec 6th, 2011, 10:05 AM #4
    ERUM
    ERUM is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2007
    Location
    Karachi
    Posts
    551

    Re: Unable to restore .bak file in sql servr 2005

    i verify database using this

    RESTORE VERIFYONLY FROM DISK='E:\downloads\rena.BAK'

    but getting an error

    Msg 3241, Level 16, State 0, Line 1
    The media family on device 'E:\downloads\rena.BAK' is incorrectly formed. SQL Server cannot process this media family.
    Msg 3013, Level 16, State 1, Line 1
    VERIFY DATABASE is terminating abnormally.
    There is no achievement without goals
    Reply With Quote Reply With Quote
  6. Dec 6th, 2011, 10:15 AM #5
    ERUM
    ERUM is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2007
    Location
    Karachi
    Posts
    551

    Re: Unable to restore .bak file in sql servr 2005

    well i have sql server 2005 at both time while taking back up and restoring....

    secondly i did not found reasonable solution yet
    Thanks
    There is no achievement without goals
    Reply With Quote Reply With Quote
  7. Dec 6th, 2011, 10:15 AM #6
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Unable to restore .bak file in sql servr 2005

    looks like a bad backup file then. I'd hazard a guess that something went wrong in the backup process.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  8. Dec 6th, 2011, 10:24 AM #7
    ERUM
    ERUM is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2007
    Location
    Karachi
    Posts
    551

    Re: Unable to restore .bak file in sql servr 2005

    so that means nothing can be possible to recover ...??
    There is no achievement without goals
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width