July 3, 2018 at 9:24 am
Hi Everyone
I'm trying to restore a backup that was taken from a 2012 SQL Server and restore to a SQL Server with 2017. Here are the versions:
Microsoft SQL Server 2012 (SP3-GDR) (KB4019092) - 11.0.6251.0 (X64) Jul 7 2017 07:14:24 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)
Is this possible? I can't seem to get the 2017 SQL Server to recognize the backup. It gives me the following errors:
The file ID 1 on device 'Z:\Backups\VSSQL2\Backupfile.bak' is incorrectly formed and can not be read.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I've tried 2 different backups,
Thanks
Cat
July 3, 2018 at 9:40 am
Cat
What statement are you using to attempt your restore? What do you get if you run this:
RESTORE HEADERONLY FROM DISK = 'Z:\Backups\VSSQL2\Backupfile.bak'
John
July 3, 2018 at 10:05 am
The only message I get is:
Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
July 4, 2018 at 1:02 am
Sounds like your backup file isn't a valid backup file. Are there any backups you can restore from? Do you verify your backups when you make them, or use the CHECKSUM option? Is the backup encrypted? What happens if you run this?
RESTORE VERIFYONLY ONLY FROM DISK = 'Z:\Backups\VSSQL2\Backupfile.bak'
John
July 4, 2018 at 3:51 am
OlyKLin - Tuesday, July 3, 2018 9:24 AMHi EveryoneI'm trying to restore a backup that was taken from a 2012 SQL Server and restore to a SQL Server with 2017. Here are the versions:
Microsoft SQL Server 2012 (SP3-GDR) (KB4019092) - 11.0.6251.0 (X64) Jul 7 2017 07:14:24 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)
Is this possible? I can't seem to get the 2017 SQL Server to recognize the backup. It gives me the following errors:
The file ID 1 on device 'Z:\Backups\VSSQL2\Backupfile.bak' is incorrectly formed and can not be read.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I've tried 2 different backups,
Thanks
Cat
what are your source and target SQL server Editions?
Sorry for my bad English..
July 4, 2018 at 6:08 am
Says they're both Enterprise Edition.
What happens if you try to restore the backup to the 2012 server; does that work?
July 4, 2018 at 6:51 am
This was removed by the editor as SPAM
July 4, 2018 at 7:14 am
what is results of restore verify command.
As a trial try to restore it in 2014 or 2016, then take the backup and restore it on 2017.
Thank You.
Regards,
Raghavender Chavva
July 5, 2018 at 8:44 pm
I have just tried a restore from SQL 2005, SQL 2008R2 and SQL 2012 Enterprise to a SQL 2017 Enterprise server with no issues so it should be possible.
I would try what Beatrix suggested and try restoring it back to the server it came from. If that works you at least know that the backup file is OK.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply