I recently restored a database from SQL7 to SQL2005. When restoring the database I needed to create a c:\data\data folder or else it would not restore the mdf and ldf files.
I would like to move these files to a new location. Copied the the two files to a new folder, C:\database. Using the sql studio manager, preformed a task to detach the database, then attach the database with the new location.
This seemed to work, I am able to access my application that uses this database. However, any changes I make to the program, are not writing changes back to the mdf file. When I open the program, these changes are still in place, but the mdf
file should be updated, correct? When the database files were stored in the c:\data\data folder, any little change I made to the program changed the modified time for the mdf file.
Is there something missing or where could these changes be written to?
View Complete Post