Post reply

Restore sql server backup

  • April 13, 2016 at 3:45 am

    #326431

    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

  • April 13, 2016 at 3:48 am

    #1871628

    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

  • April 13, 2016 at 5:03 am

    #1871635

    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.

  • April 13, 2016 at 5:07 am

    #1871636

  • January 9, 2019 at 2:23 am

    #2018385

    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

  • January 9, 2019 at 2:56 am

    #2018390

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

  • January 9, 2019 at 12:27 pm

    #2018448

    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 6 (of 6 total)

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