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.