Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL 2005 database move to Windows 7 64 Bit with SQL 2008 R2 Engine installed

Avatar of MarvinEMarshall
MarvinEMarshallFlag for United States of America asked on
Microsoft SQL Server 2008Windows 7
12 Comments1 Solution423 ViewsLast Modified:
Yesterday I did a FULL BACKUP of a large SQL database running SQL 2005 and Windows 2003 Server.
I then copied the newly created sql_song1.bak file to an identical Folder on the same lettered D drive on the Windows 7 computer via my personal network.
I then performed a RESTORE query in Microsoft Management Studio. That was successful.  However when I pulled up the newly formed sql_song1 database, it showed all the tables (about 40) of them and all had the proper fields.   But, when I would right-click on a table, there was no option to OPEN TABLE.  Therefore I did everything except put the data in the tables.  What did I do wrong?
Thanks for any assistance.  I can supply the exact Backup and Restore query text if needed.