Restore sql server backup
-
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
-
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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
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.
-
-
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 -
You're bumping quite a lot of old threads at the moment. Is there a reason?
-
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 recoverabilityWe 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