Tuesday, March 20, 2012

copying my database to another offsite computer

My need: I want to copy my databse (the file itself) in a mem card so that I can use it in another comuter offsite.
How do I do that. it s like a back up I think, except that I ll need to import the DB in another computer at home.
When I try using Backup the DB of Entreprise Manager, I get violation error, can t copy the file being used or something like that. Am I doing it the right way or is there another better way to do this.

Thanks

One way you can do this:

First you detach your database from EM , and find where your database's data file is, by default installation, the database file is in this folder: C:\Program Files\Microsoft SQL Server\MSSQL\Data.(attach the database after you copy it)

Then, copy the .mdf file of your database to your memory card.

From another computer, you can simply attach it through EM. Good to go.

|||thank u

No comments:

Post a Comment