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/default...b;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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment