Re: New Server Hardware - Move everything from one Server to another?
- From: "Scott Townsend" <scooter133@xxxxxxxxxxxxxxxx>
- Date: Thu, 5 Apr 2007 07:44:58 -0700
I was hoping for a way to move the DBs without having to do everything piecemeal. Move the DBs, move the Users, fix the user, move the jobs, fix the jobs. I know its possible, its just a headach everytime we do it...
the onw KB has 5 differnet steps with multiple steps for each step. Since they are both standalone SQL 2005 Servers, no replication, no other attachments, I though there might be a more simple way to jsut move over the data and the settings.
Something like the Files and Settings transfer Wizard (-;
Thanks,
"Charles Wang[MSFT]" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message news:m5ZQLl1dHHA.4692@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi, Scott,
Thanks for your response.
Moving everything from one computer to another is not an easy thing.
Sometimes it is not possible without any manual configuration. For example,
if there is a replication under your original server, after you move all
the databases, users, logins, jobs, and DTS packages etc, you need to
manually re-create the configurations on your new server.
To make your issue more clear and specific, could you please let us know
what the problems that you have but the KB article does not include?
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
.
- Follow-Ups:
- Re: New Server Hardware - Move everything from one Server to another?
- From: Charles Wang[MSFT]
- Re: New Server Hardware - Move everything from one Server to another?
- From: Charles Wang[MSFT]
- Re: New Server Hardware - Move everything from one Server to another?
- References:
- New Server Hardware - Move everything from one Server to another?
- From: Scott Townsend
- RE: New Server Hardware - Move everything from one Server to another?
- From: Charles Wang[MSFT]
- Re: New Server Hardware - Move everything from one Server to another?
- From: Scott Townsend
- Re: New Server Hardware - Move everything from one Server to another?
- From: Charles Wang[MSFT]
- New Server Hardware - Move everything from one Server to another?
- Prev by Date: Re: Unable to Install SQL2005 SP2
- Next by Date: Re: Unable to Install SQL2005 SP2
- Previous by thread: Re: New Server Hardware - Move everything from one Server to another?
- Next by thread: Re: New Server Hardware - Move everything from one Server to another?
- Index(es):
Relevant Pages
|
