Posted by Mike Epprecht \(SQL MVP\) on 05/24/05 00:02

Hi

You can copy the user databases(first detach them and then re-attach them at
destination (sp_attachdb), but you can not copy the EXE's and binaries. You
need to run an install on the new server. SQL Server is not just about
files, it involves registry entries and updates to MDAC etc.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"laststubborn" <arafatsalih@gmail.com> wrote in message
news:1116865451.858663.71740@o13g2000cwo.googlegroups.com...
> Hi All;
>
> We are going to change our application server. We will copy all of our
> Database from Mic 2000 Server OS to Mic 2003 Server OS. I found an
> article that how to move all the folders from same OS. My question is
> that Would the 2003 OS be a problem when we copy all of the MC SQL 2000
> folders to New OS ? Has anybody done this before? Could you gimme your
> suggestions please?
>
> Thanks
>
> ASA
>

• Next in forum: Re: Working with date ranges
• Prev in forum: Re: How to reclaim space in columns changed from nvarchar to varchar
• Thread view: Re: Copying Database from 2000Server Machine To 2003 Server Machine

[Reply to this message]