On Sat, Aug 27, 2011 at 11:16 AM, Ajoy Khaund <akhaund@gmail.com> wrote:

> Hi,

>

> If SQL Server Express Edition is installed in two computers, then can I just copy the data folder from the first machine and paste it to the second machine.

> Is that possible or is it something completely different?

Hi Ajoy, it should work if you un-mount the source database and

re-attach on the destination.

A better approach is to use backup/restore.

Mirroring and replication are 2 other options but not supported by SQL Express.

--

Paul

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CADwx0+++RWZqaCgBNCWGWuN+NQLm1FwYZSXnYDvJJXWQs+QuMQ@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.