To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at. Pinal has authored 13 SQL Server database books and 40 Pluralsight courses. He holds a Masters of Science degree and numerous database certifications. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. “DBCC CHECKPRIMARYFILE(‘G:\SQL\Data\DataClient.mdf’,2)”Ĭould you help ? thanks in advance. Then i get verification on source version: This server supports version 852 and earlier. The database ‘DataClient’ cannot be opened because it is version 869. ( FILENAME = N’G:\SQL\Data\DataClient_log.ldf’ )Ĭould not open new database ‘DataClient’. ( FILENAME = N’G:\SQL\Data\DataClient.mdf’ ), 0 (X64) 18:17:30 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 6.3 (Build 16299: ) ” I was a similar problem, but i do not understood why, because my SQL version was the most recent SQL Server Versionĭo you know the steps to move to older version? What have you done before for such errors? Do feel free to share with all via the comments section below. Here is what I was able to find on the internet.
We cannot attach/detach or backup/restore a database from a newer version of SQL Server down to an older version – the internal file structures are just too different to support backwards compatibility. In short, this error is expected when we try to attach file from higher version of SQL to lower version of SQL. When I ran select on my server I found that I was trying to attach it to lower versions of SQL. So, we know that version is 802 which is for SQL Server 2016. Server\MSSQL13.SQL2016\MSSQL\DATA\SQLAuthority.mdf',2) I found a command on the internet to read MDF file version: DBCC CHECKPRIMARYFILE('C:\Program Files\Microsoft SQL The second part of the message was strange and was the first time I was seeing. This server supports version 782 and earlier. The database ‘SQLAuthority’ cannot be opened because it is version 852. ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\DATA\SQLAuthority_log.ldf' )Ĭould not open new database ‘SQLAuthority’. ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\DATA\SQLAuthority.mdf' ), Here is the error I received while I was trying to attach database using below command: USE Fix Error 948 – A Downgrade path is not supported Here is an error which is related to a downgrade path not supported. There are no right or wrong answers sometimes, but am learning every time. But the best part of this learning experience is that I get to write about them one after another. These past weeks the number of errors I have been getting when attaching a database has been far too many.
0 kommentar(er)
