SQL Server Version - BAK Properties - by David Farrell

Status : 


Sign in
to vote
ID 785794 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 4/29/2013 8:12:28 AM
Access Restriction Public


Hi MS Connect

When SSMS makes a BAK file - in the properties of the BAK's file - Details - can I suggest that they put the version of SQL Server that created the file, i.e., SQL 2008R2, SQL 2012, etc.  This way when wanting to Restore the BAK file - we know which SSMS to aim for?  Sounds like a good property to have!

With thanks

Sign in to post a comment.
Posted by David Farrell on 5/10/2013 at 3:32 PM
Hi Walter

Thanks for the reply

I can just imagine the conversation with a typical NAV user. Tech: "please add the SQL Version number to the backup name." NAV USER: "Errr, say what now? What's a 'SQL'?"

With thanks

Posted by Microsoft on 5/10/2013 at 1:51 PM
Hello David. You should be able to use RESTORE HEADERONLY (http://msdn.microsoft.com/en-us/library/ms178536.aspx) and look at the SoftwareVersionMajor and SoftwareVersionMinor values. While it may not be much use when you're trying to figure things out after the fact, proactively including version numbers in files as you create them could also help. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by ianwilson on 5/10/2013 at 6:46 AM
Where exactly in the Restore GUI is this information shown? I cannot see it anywhere.
Posted by David Farrell on 5/9/2013 at 6:06 AM
Hi Microsoft Connect Team

Thanks for your reply.

I appreciate that the SSMS displays the restore information in the header part but the problems come when trying to restore a SQL 2012 BAK file into say SQL 2008 SSMS - a error occurs with no real hint of the real SQL BAK version - this is why a version ID on the BAK file property would be real good going forward!

With thanks

Posted by Microsoft on 5/6/2013 at 1:44 PM
Hello David. It is not actually SSMS that is responsible for making these files. They come from the Engine. These files also contain the version in the header file, and this version is displayed by SSMS in the restore dialog. We will be resolving this item as "By Design." Please let us know if this information does not help you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Microsoft on 5/3/2013 at 9:49 AM
Hello David. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)