Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have set up a local instance in SQL Server 2008 R2. I have a database (called GD_LOCAL_TC) that I need to restore so I can begin working in it (right now it's empty).

When I right click on GD_LOCAL_TC --> TASKS --> Restore database, it will not let me navigate to the .bak file that I need to restore. It shows the C drive as well as folders, but will not show any of the files I need to highlight.

Is this a problem with the program I am using, or am I missing something?!

I don't know if this matters, but the .bak file is from SQL Server 2005.

share|improve this question
add comment

1 Answer

It's looking for a 2008 SQL Server database backup, not a 2005 SQL Server database backup.

This is primarily because it's not possible to directly restore one SQL database version into a different version database engine. Different SQL versions have different metadata formats and schemas that aren't compatible across versions. The easiest thing to do would be to restore this database to a 2005 SQL Server engine, and then go through the following procedure to copy it from 2005 to 2008.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.