Wednesday, March 28, 2012

Replacing a Server

Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.Basically, you can do a backup and restore of most of the databases. You
can create DTS packages to migrate jobs and logins.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.|||Hi,
Look into the KB article:-
http://support.microsoft.com/defaul...kb;EN-US;224071
Since this help you to move system databases as well; there is no need to
copy Logins; users;jobs; dts packages from old server.
Thanks
Hari
SQL Server MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
> Hi,
> I just replaced a Windows 2003 server. The old server had SLQ Server 2000
> on
> it. Is there an artcile I can read on how to transfer everything over from
> one server to the other.
> Thanks,
> Kevin.

No comments:

Post a Comment