1) I want to attach a database from my development server to my production server.
ESpiceHerbs from my development server is located at:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA
2) When I log in using my production server credentials and right click on the
Databases folder in
Object Explorer and select
Attach Databases and click
Add, I cannot find it there! :(
3) I am really confused as to why it cannot be located although its pointing to the same folder.
Could it be because the development server is running on 32 bit and the production server is running on 64 bit?