Restore Backup from 2012 to 2017 GTM

Question

Post reply

Restore Backup from 2012 to 2017 GTM

OlyKLin

Ten Centuries

Points: 1333
More actions
July 3, 2018 at 9:24 am

#365251

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 4, 2018 at 6:51 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

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

OlyKLin Ten Centuries Points: 1333 More actions · Answer 2

The only message I get is:

Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

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

dropsa999 Old Hand Points: 349 More actions · Answer 4

OlyKLin - Tuesday, July 3, 2018 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

what are your source and target SQL server Editions?

Sorry for my bad English..

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 5

Says they're both Enterprise Edition.

What happens if you try to restore the backup to the 2012 server; does that work?

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 6

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

CC-597066 SSCommitted Points: 1637 More actions · Answer 7

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.