Sunday, February 19, 2012

how to copy database?

i have an database created with MSDE using the windows authentication,and now i want to send this database to someone, can i just backup thisdatabase and send it,
can other people access my database with windows authenticaiton in his computer ? or i need to do some extra stuff?
I havent used MSDE but normally you can copy the mdf and ldf files and paste them in the Data folder of the server you want to move it onto and do an "Attach" database. right click on databases and select "Attach database" and follow the wizard.|||

Theoretically, If you're using Windows Authentication - anyone in the domain would be able to access the database, once they're logged into the domain...(with the right tools, of course)

You can back it up or you can detach it and send the two files (.mdf and .ldf) files to the other person - they can then attach the files to their own server.

|||unfortunately the people i want to send is not in the domain
but i have stored procedures within in the database, and when i detachthe database , will they not be ask some password stuff?? becausei this database used window authentication.
can i somehow get rid of this windows authentication to use the normal password version??

No comments:

Post a Comment