error attach database i need help

01/12/2023 16:55 Eosanity09#1
After i attach the data base i get error, please i need help, thanks

TITLE: Microsoft SQL Server Management Studio
------------------------------

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details.

------------------------------
BUTTONS:

OK
------------------------------
01/12/2023 19:26 MrRoyalT#2
Drag the bar to the right to see the "hyperlink" which will open the description to what's wrong.

Usually you get an error because you are using new version of SQL which the database that you attached doesn't support.
let's say you use SQL Server Management Studio 2022 but the database is set for 2012, so you get that error.
02/05/2023 07:54 Hoocker92#3
Maybe compatibility level number of DB not suitable for your sql server version. If DB have 90 level (SQL Server 2005) it mean that you can attach this DB up to SQL Server 2012. Latest versions will throw an error.