From: RG on
If SBS2008 Premium is set up all on a single server initially and then a
second server is added later, how easy is it to move SQL Server to the
second server?

Alternatively, if it's set up on the two servers and there's a problem with
the second server...how easy is it to put SQL Server back onto the main SBS
server or replace it with new hardware?

Thanks
RG

From: Russ SBITS.Biz [SBS-MVP] on
RG
Kind of hard to answer?
I mean I can do it!
But I don't know if I would call it easy or hard?

I mean you are just moving stuff around and sometimes it can be frustrating.
but as far as Hard/Easy
IMO that depends on your skill level?

I personally wouldn't call it easy or hard, just time consuming?
It's not like a 2min process if that is what you are asking?
Does that help?
Russ

--
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Small Business Server/Computer Support - www.SBITS.Biz
BPOS - Microsoft Online Services - www.BPOSMadeEasy.com
Easy Redirect to Microsoft's New SBS Public Support Forum - SBSRepair.com

"RG" <a(a)b.com> wrote in message news:eJzVwNWDLHA.980(a)TK2MSFTNGP04.phx.gbl...
> If SBS2008 Premium is set up all on a single server initially and then a
> second server is added later, how easy is it to move SQL Server to the
> second server?
>
> Alternatively, if it's set up on the two servers and there's a problem
> with the second server...how easy is it to put SQL Server back onto the
> main SBS server or replace it with new hardware?
>
> Thanks
> RG

From: RG on
Thanks for the feedback Russ. Is moving the server that SQL Server is
installed on something that can be done with the help of wizards?

I'm not short on IT experience...just not much with SBS and I know that the
tendency of IT pros to bypass the wizards in SBS can cause problems :) Just
trying to get some info for a friend who's jumping from SBS 2003 to 2008.
He's planning to just do a fresh SBS setup and then migrate the data files,
email etc. once SBS 2008 Premium is installed on a new server. The old
server will then be wiped and used as the second server for SQL...just not
sure if he can wait until the old server is wiped to install SQL Server.

Thanks

RG

"Russ SBITS.Biz [SBS-MVP]" <russ(a)REMOVETHIS.sbits.biz> wrote in message
news:4DCE82E5-DF6D-46CE-A3EE-FA90E465C78A(a)microsoft.com...
> RG
> Kind of hard to answer?
> I mean I can do it!
> But I don't know if I would call it easy or hard?
>
> I mean you are just moving stuff around and sometimes it can be
> frustrating.
> but as far as Hard/Easy
> IMO that depends on your skill level?
>
> I personally wouldn't call it easy or hard, just time consuming?
> It's not like a 2min process if that is what you are asking?
> Does that help?
> Russ
>
> --
> Russell Grover - SBITS.Biz [SBS-MVP]
> MCP, MCPS, MCNPS, SBSC
> Small Business Server/Computer Support - www.SBITS.Biz
> BPOS - Microsoft Online Services - www.BPOSMadeEasy.com
> Easy Redirect to Microsoft's New SBS Public Support Forum - SBSRepair.com
>
> "RG" <a(a)b.com> wrote in message
> news:eJzVwNWDLHA.980(a)TK2MSFTNGP04.phx.gbl...
>> If SBS2008 Premium is set up all on a single server initially and then a
>> second server is added later, how easy is it to move SQL Server to the
>> second server?
>>
>> Alternatively, if it's set up on the two servers and there's a problem
>> with the second server...how easy is it to put SQL Server back onto the
>> main SBS server or replace it with new hardware?
>>
>> Thanks
>> RG
>
From: Cris Hanna [SBS - MVP] on
There are no wizards
You would save your database files
Uninstall SQL Server on the current server
Move the database files to the new destination
Install SQL on server and connect to database.

--
Cris Hanna [SBS - MVP] (since 1997)
Co-Contributor, Windows Small Business Server 2008 Unleashed
http://www.amazon.com/Windows-Small-Business-Server-Unleashed/dp/0672329573/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1217269967&sr=8-1
Owner, CPU Services, Belleville, IL
A Microsoft Registered Partner
------------------------------------
MVPs do not work for Microsoft
Please do not submit questions directly to me.

"RG" <a(a)b.com> wrote in message news:u90MBPgDLHA.5324(a)TK2MSFTNGP06.phx.gbl...
Thanks for the feedback Russ. Is moving the server that SQL Server is
installed on something that can be done with the help of wizards?

I'm not short on IT experience...just not much with SBS and I know that the
tendency of IT pros to bypass the wizards in SBS can cause problems :) Just
trying to get some info for a friend who's jumping from SBS 2003 to 2008.
He's planning to just do a fresh SBS setup and then migrate the data files,
email etc. once SBS 2008 Premium is installed on a new server. The old
server will then be wiped and used as the second server for SQL...just not
sure if he can wait until the old server is wiped to install SQL Server.

Thanks

RG

"Russ SBITS.Biz [SBS-MVP]" <russ(a)REMOVETHIS.sbits.biz> wrote in message
news:4DCE82E5-DF6D-46CE-A3EE-FA90E465C78A(a)microsoft.com...
> RG
> Kind of hard to answer?
> I mean I can do it!
> But I don't know if I would call it easy or hard?
>
> I mean you are just moving stuff around and sometimes it can be
> frustrating.
> but as far as Hard/Easy
> IMO that depends on your skill level?
>
> I personally wouldn't call it easy or hard, just time consuming?
> It's not like a 2min process if that is what you are asking?
> Does that help?
> Russ
>
> --
> Russell Grover - SBITS.Biz [SBS-MVP]
> MCP, MCPS, MCNPS, SBSC
> Small Business Server/Computer Support - www.SBITS.Biz
> BPOS - Microsoft Online Services - www.BPOSMadeEasy.com
> Easy Redirect to Microsoft's New SBS Public Support Forum - SBSRepair.com
>
> "RG" <a(a)b.com> wrote in message
> news:eJzVwNWDLHA.980(a)TK2MSFTNGP04.phx.gbl...
>> If SBS2008 Premium is set up all on a single server initially and then a
>> second server is added later, how easy is it to move SQL Server to the
>> second server?
>>
>> Alternatively, if it's set up on the two servers and there's a problem
>> with the second server...how easy is it to put SQL Server back onto the
>> main SBS server or replace it with new hardware?
>>
>> Thanks
>> RG
>
From: Russ (SBITS.Biz) [SBS-MVP] on
Like Cris said it's just moving things around no wizards
If you know how to do it then you can consider it easy?
IMO it's more of a time consuming thing...
and making sure you can cover everything.

I wouldn't recommend to a beginner however.
Russ

--
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Remote Small Business Server/Computer Support - www.SBITS.Biz
BPOS - Microsoft Online Services - www.BPOSMadeEasy.com
Easy Redirect to Microsoft's New SBS Public Forum - www.SBSRepair.com
"Cris Hanna [SBS - MVP]" <crisnospamhanna(a)cpunospamservices.net> wrote in message news:%23BvuyKkDLHA.5324(a)TK2MSFTNGP06.phx.gbl...
There are no wizards
You would save your database files
Uninstall SQL Server on the current server
Move the database files to the new destination
Install SQL on server and connect to database.

--
Cris Hanna [SBS - MVP] (since 1997)
Co-Contributor, Windows Small Business Server 2008 Unleashed
http://www.amazon.com/Windows-Small-Business-Server-Unleashed/dp/0672329573/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1217269967&sr=8-1
Owner, CPU Services, Belleville, IL
A Microsoft Registered Partner
------------------------------------
MVPs do not work for Microsoft
Please do not submit questions directly to me.

"RG" <a(a)b.com> wrote in message news:u90MBPgDLHA.5324(a)TK2MSFTNGP06.phx.gbl...
Thanks for the feedback Russ. Is moving the server that SQL Server is
installed on something that can be done with the help of wizards?

I'm not short on IT experience...just not much with SBS and I know that the
tendency of IT pros to bypass the wizards in SBS can cause problems :) Just
trying to get some info for a friend who's jumping from SBS 2003 to 2008.
He's planning to just do a fresh SBS setup and then migrate the data files,
email etc. once SBS 2008 Premium is installed on a new server. The old
server will then be wiped and used as the second server for SQL...just not
sure if he can wait until the old server is wiped to install SQL Server.

Thanks

RG

"Russ SBITS.Biz [SBS-MVP]" <russ(a)REMOVETHIS.sbits.biz> wrote in message
news:4DCE82E5-DF6D-46CE-A3EE-FA90E465C78A(a)microsoft.com...
> RG
> Kind of hard to answer?
> I mean I can do it!
> But I don't know if I would call it easy or hard?
>
> I mean you are just moving stuff around and sometimes it can be
> frustrating.
> but as far as Hard/Easy
> IMO that depends on your skill level?
>
> I personally wouldn't call it easy or hard, just time consuming?
> It's not like a 2min process if that is what you are asking?
> Does that help?
> Russ
>
> --
> Russell Grover - SBITS.Biz [SBS-MVP]
> MCP, MCPS, MCNPS, SBSC
> Small Business Server/Computer Support - www.SBITS.Biz
> BPOS - Microsoft Online Services - www.BPOSMadeEasy.com
> Easy Redirect to Microsoft's New SBS Public Support Forum - SBSRepair.com
>
> "RG" <a(a)b.com> wrote in message
> news:eJzVwNWDLHA.980(a)TK2MSFTNGP04.phx.gbl...
>> If SBS2008 Premium is set up all on a single server initially and then a
>> second server is added later, how easy is it to move SQL Server to the
>> second server?
>>
>> Alternatively, if it's set up on the two servers and there's a problem
>> with the second server...how easy is it to put SQL Server back onto the
>> main SBS server or replace it with new hardware?
>>
>> Thanks
>> RG
>