Copying SQL Server database

[tani1978]

Hello Friends,
I have an Access frontend sql server backend application, I wanted to run it on another computer,so I copied the adp file and SQL server database also.I saved the sql server databse in sql server/data folder but my databse is not shown in the drop down list and my adp is also not working because of it.can someone tell me how to solve this problem?
Thanks

 

[hmckillop]

How did you copy the SQL Database (did you just copy the .mdf and .ldf files?)

The simplest process for you is either to copy over the MDF file and attach it, or to backup the database and restore it.
Copying it over wont do anything.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[tani1978]

i just copied the mdf and ldf files

 

[SQLBill]

You cannot copy them while SQL Server is running or the database is attached. You must do one of these:

1. detach the database, copy the files, attach the database
2. stop the SQL Server services, copy the files, start the services.

When you copy the files, you must move them or rename them before reattaching or starting services.

-SQLBill

Posting advice: FAQ481-4875

 

[tani1978]

I have done the step 2 but I cant see the my copied database on the drop down list.

 

[tani1978]

thanks I hav got it thanks