Restore sql server backup

  • vleninraj

    SSC Journeyman

    Points: 94

    While restoring a database backup file taken in SQL 2005 Standard edition to new database in SQL 2014 Standard edition; the backup set is not filling so that it can be selected for restoration.

    OS:Windows server 2012 , 64Bit

    Sql Server Version : Standard Edition 12.0.2000.8

    Microsoft Sql Server Management Studio :12.0.2000.8

  • Gail Shaw

    SSC Guru

    Points: 1004424

    Thread continues http://www.sqlservercentral.com/Forums/Topic1777329-3411-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • vleninraj

    SSC Journeyman

    Points: 94

    Thanks

    yes i have tried in T-SQL also using following command

    RESTORE DATABASE <YourDatabase>

    FROM DISK='<the path to your backup file>\<YourDatabase>.bak'

    But i am facing following error.

    Msg 3241, Level 16, State 7, Line 1 The media family on device 'D:\dummy.bak' is incorrectly formed. SQL Server cannot process this media family. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.

    I have tried to restore this database backup in SQL server 2005 itself. At that time backup set is able to select for restoring.

  • vleninraj

    SSC Journeyman

    Points: 94

  • Johnson Welch

    SSCoach

    Points: 18748

    Here are the step by step process to restore database to new location. Go through it:
    https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-to-a-new-location-sql-server?view=sql-server-2017

  • Beatrix Kiddo

    SSC-Dedicated

    Points: 32323

    You're bumping quite a lot of old threads at the moment. Is there a reason?

  • Gail Shaw

    SSC Guru

    Points: 1004424

    In this case the step-by-step process is irrelevant, since the backup in question is damaged, possibly in copy.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply