I am on the bottom of page 487. I am having trouble when I try to add the existing item, AdventureWorksLT2008_Data.mdf. It keeps saying "The file can not be opened because it is being used by another process. Please close all applications that might access this file and try again." I have no applications open that would be accessing this file. In fact, even after I reboot and try to add the file, it still gives me the same message. Any idea how to get past this?

Hi my friend.
I think your file is attached to SqlServer. you can stop sqlServer service and copy file to new location, then start sqlServer.

Start -> Control Panel -> Administrative Tools -> Services ->
find Sql Server service and stop it. and after coping file to new location, start the service

__________________
happy every time, happy every where

Reza Baiat

Thank you for your quick response.

Ok, I stopped my SQL Server, then I was able to add the database, then I restarted my SQL Server. Is this the normal way to do it? This sounds like it would be too much trouble to stop the server on a production system during the day. Are we supposed to begin all our projects at night when nobody is on?

Hi Drogil
to do this you can open sql server management studio and backup old database. then create a new database and restore backup files over this new db. (in the restore database window, select Options from left side and tick 'Overwrite the existing database'. )
this makes a new copy of your database for test or other purposes.

__________________
happy every time, happy every where

Reza Baiat