alhanouty
asked on
moving database file to another computer?
Dear all
I want to take a copy of my database to another Server,both servers are running SQl Server but they are not on the same network. what changes a have to do for the tables on the target sql server.
I want to take a copy of my database to another Server,both servers are running SQl Server but they are not on the same network. what changes a have to do for the tables on the target sql server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Iam very sorry, I forgot to told that Iam using MSDE not the MS SQL itself, that means I dont have EM or QA there.
sorry again.
If you can stop SQL Server on the source server long enough to copy the files, then you don't have to detach the database and then re-attach it.
If you can't stop SQL Server and you can't detach the database because it's in use, create a new database, restore the original database into the new one, then do the detach / attach sequence.