|
Home > Archive > MS SQL Server > December 2005 > Ghosting SQL Server 2000 Running on NT40
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Ghosting SQL Server 2000 Running on NT40
|
|
| Scott Yu 2005-12-29, 8:23 pm |
| Hello,
Is it possible to Ghost SQL Server 2000 running on NT4.0 and then restore
that image on another server with different hardware configuration and
operating system(likely Windows 2003)???
The currentl SQL Server have DTS packages, Linked Services, Jobs, etc...
If possible, what would be the best steps to take to ensure a successful
image.
Are there any documentations on Ghosting SQL Server???
Thank You
Scott Yu
| |
| Michael Hotek 2005-12-29, 8:23 pm |
| No.
--
Mike
Mentor
Solid Quality Learning
http://www. solidqualitylearning
.com
"Scott Yu" <ScottYu@discussions.microsoft.com> wrote in message
news:161D3054-7195-414E-A814- 5B60B8B82624@microso
ft.com...
> Hello,
>
> Is it possible to Ghost SQL Server 2000 running on NT4.0 and then restore
> that image on another server with different hardware configuration and
> operating system(likely Windows 2003)???
>
> The currentl SQL Server have DTS packages, Linked Services, Jobs, etc...
>
> If possible, what would be the best steps to take to ensure a successful
> image.
> Are there any documentations on Ghosting SQL Server???
>
> Thank You
> Scott Yu
| |
| Scott Yu 2005-12-30, 11:23 am |
| Why? I need to give an answer to my manager and client.
"Michael Hotek" wrote:
> No.
>
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www. solidqualitylearning
.com
>
>
> "Scott Yu" <ScottYu@discussions.microsoft.com> wrote in message
> news:161D3054-7195-414E-A814- 5B60B8B82624@microso
ft.com...
>
>
>
| |
| Dan Guzman 2005-12-30, 11:23 am |
| I assume that by 'ghosting', you mean creating a disk image of all installed
SQL Server components and databases. This is not feasible for a number of
reasons. For example, much configuration data is stored registry and this
would need to be properly merged to the target system.
Is there some reason you must use a 'ghosting' technique to move the
installation? The normal way to accomplish this is to install SQL Server on
the target server (same version/SP/hotfix level as source), restore system
databases and then restore (or attach) user databases, much like you might
do in a disaster recovery scenario. Restoring master and msdb will move
your DTS packages, Linked Services, Jobs, etc. See
http://support.microsoft.com/kb/307775/en-us for a list of DR articles.
--
Happy Holidays
Dan Guzman
SQL Server MVP
"Scott Yu" <ScottYu@discussions.microsoft.com> wrote in message
news:19023EF9-09A7-4FF1-AE24- 7C268426F612@microso
ft.com...[color=darkred]
> Why? I need to give an answer to my manager and client.
>
> "Michael Hotek" wrote:
>
| |
| Scott Yu 2005-12-30, 1:23 pm |
| Thank you Dan,
Management wants to use Ghost, I don't. I figure Ghost was not a solution,
but I wasn't 100% sure. I'll proceed the way it should be done,
re-installing SQL Server and then restore the various components.
Now I have a good reason to let management know why Ghosting is not a quick
fix solution.
Thank you so much.
Scott Yu
"Dan Guzman" wrote:
> I assume that by 'ghosting', you mean creating a disk image of all installed
> SQL Server components and databases. This is not feasible for a number of
> reasons. For example, much configuration data is stored registry and this
> would need to be properly merged to the target system.
>
> Is there some reason you must use a 'ghosting' technique to move the
> installation? The normal way to accomplish this is to install SQL Server on
> the target server (same version/SP/hotfix level as source), restore system
> databases and then restore (or attach) user databases, much like you might
> do in a disaster recovery scenario. Restoring master and msdb will move
> your DTS packages, Linked Services, Jobs, etc. See
> http://support.microsoft.com/kb/307775/en-us for a list of DR articles.
>
> --
> Happy Holidays
>
> Dan Guzman
> SQL Server MVP
>
> "Scott Yu" <ScottYu@discussions.microsoft.com> wrote in message
> news:19023EF9-09A7-4FF1-AE24- 7C268426F612@microso
ft.com...
>
>
>
| |
|
|
| Leythos 2005-12-31, 3:23 am |
| In article <161D3054-7195-414E-A814- 5B60B8B82624@microso
ft.com>,
ScottYu@discussions.microsoft.com says...
> Hello,
>
> Is it possible to Ghost SQL Server 2000 running on NT4.0 and then restore
> that image on another server with different hardware configuration and
> operating system(likely Windows 2003)???
>
> The currentl SQL Server have DTS packages, Linked Services, Jobs, etc...
>
> If possible, what would be the best steps to take to ensure a successful
> image.
> Are there any documentations on Ghosting SQL Server???
Ghost doesn't restore files, it's an IMAGE of the Drive / Partition.
Sure you can pull individual files using Ghost Walker, but it's designed
to make a instance image of a DRIVE and restore the entire thing to
another drive.
You want to MIGRATE based on your description - Ghost has nothing to do
with a Migration, unless you want to migrate the existing OS/Data to
another hardware, fix it, get it working perfectly, then upgrade the OS
- this would leave the old system running until needed.
The new system could have the same name as the old system (as long as
you don't put them on the network at the same time, even the same IP,
but you would have to do the upgrade manually.
--
spam999free@rrohio.com
remove 999 in order to email me
|
|
|
|
|