Re: Copying SQL Data from one m/c to another

Author: Stephen Russell

Posted: 2011-08-27 at 08:13:07

On Sat, Aug 27, 2011 at 5: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?

-----------------

Read up on detach and reattach.

There are data meta databases as well as your database. The databases

have an ID for the SERVER they are on

detach will open up the ability to bring in a new server to as as the host.

--

Stephen Russell

Unified Health Services

60 Germantown Court

Suite 220

Cordova, TN 38018

Telephone: 888.510.2667

901.246-0159 cell

_______________________________________________

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/CAJidMYJ-cZt0c+hfa_p9GaGdu3WW_Okfu_atjMXkhQJ73UWBHQ@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.

©2011 Stephen Russell