Hello All,
I need to downgrade my production server from enterprise to standard edition
because of cost.
Has anyone been through this scenario?
My plan is to backup all dbs, leave data folders intact (I have db files in
4 drives), uninstall enterprise, install standard and reattach db files.
My questions are:
I have tons of jobs and DTS packages on the server. Can I simply restore
the msdb from enterprise or is it going to have problem with standard
edition?
Does anyone have a script to save logins and restore logins?
Thanks for any help,
sqlgirl"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:407a9a90$0$40211$39cecf19@.news.twtelecom.net...
> Hello All,
> I need to downgrade my production server from enterprise to standard
edition
> because of cost.
> Has anyone been through this scenario?
> My plan is to backup all dbs, leave data folders intact (I have db files
in
> 4 drives), uninstall enterprise, install standard and reattach db files.
> My questions are:
> I have tons of jobs and DTS packages on the server. Can I simply restore
> the msdb from enterprise or is it going to have problem with standard
> edition?
> Does anyone have a script to save logins and restore logins?
The following links should help you in the restore and account migration
process:
http://support.microsoft.com/defaul...kb;en-us;246133
http://support.microsoft.com/defaul...2&Product=sql2k
With regard to your question on MSDB restore, I'm less certain if that will
work... If the SQL Server builds are the same I think you'll be OK, if not,
please see the following link:
http://support.microsoft.com/defaul...4&Product=sql2k
Also, you may want to consider running SQL backups on all of your databases,
prior to uninstalling SQL Server. This will give you one more avenue for the
restore process.
Steve|||Hi Biva,
I am reviewing your post and our MVP provide you some good links for you
question, I want to know if you still have any question on this issue. For
any question, please feel free to post message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
Showing posts with label cost. Show all posts
Showing posts with label cost. Show all posts
Wednesday, March 21, 2012
downgrade from sql 2k enterprise edition to standard
Hello All,
I need to downgrade my production server from enterprise to standard edition
because of cost.
Has anyone been through this scenario?
My plan is to backup all dbs, leave data folders intact (I have db files in
4 drives), uninstall enterprise, install standard and reattach db files.
My questions are:
I have tons of jobs and DTS packages on the server. Can I simply restore
the msdb from enterprise or is it going to have problem with standard
edition?
Does anyone have a script to save logins and restore logins?
Thanks for any help,
sqlgirl
"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:407a9a90$0$40211$39cecf19@.news.twtelecom.net. ..
> Hello All,
> I need to downgrade my production server from enterprise to standard
edition
> because of cost.
> Has anyone been through this scenario?
> My plan is to backup all dbs, leave data folders intact (I have db files
in
> 4 drives), uninstall enterprise, install standard and reattach db files.
> My questions are:
> I have tons of jobs and DTS packages on the server. Can I simply restore
> the msdb from enterprise or is it going to have problem with standard
> edition?
> Does anyone have a script to save logins and restore logins?
The following links should help you in the restore and account migration
process:
http://support.microsoft.com/default...b;en-us;246133
http://support.microsoft.com/default...&Product=sql2k
With regard to your question on MSDB restore, I'm less certain if that will
work... If the SQL Server builds are the same I think you'll be OK, if not,
please see the following link:
http://support.microsoft.com/default...&Product=sql2k
Also, you may want to consider running SQL backups on all of your databases,
prior to uninstalling SQL Server. This will give you one more avenue for the
restore process.
Steve
|||Hi Biva,
I am reviewing your post and our MVP provide you some good links for you
question, I want to know if you still have any question on this issue. For
any question, please feel free to post message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
I need to downgrade my production server from enterprise to standard edition
because of cost.
Has anyone been through this scenario?
My plan is to backup all dbs, leave data folders intact (I have db files in
4 drives), uninstall enterprise, install standard and reattach db files.
My questions are:
I have tons of jobs and DTS packages on the server. Can I simply restore
the msdb from enterprise or is it going to have problem with standard
edition?
Does anyone have a script to save logins and restore logins?
Thanks for any help,
sqlgirl
"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:407a9a90$0$40211$39cecf19@.news.twtelecom.net. ..
> Hello All,
> I need to downgrade my production server from enterprise to standard
edition
> because of cost.
> Has anyone been through this scenario?
> My plan is to backup all dbs, leave data folders intact (I have db files
in
> 4 drives), uninstall enterprise, install standard and reattach db files.
> My questions are:
> I have tons of jobs and DTS packages on the server. Can I simply restore
> the msdb from enterprise or is it going to have problem with standard
> edition?
> Does anyone have a script to save logins and restore logins?
The following links should help you in the restore and account migration
process:
http://support.microsoft.com/default...b;en-us;246133
http://support.microsoft.com/default...&Product=sql2k
With regard to your question on MSDB restore, I'm less certain if that will
work... If the SQL Server builds are the same I think you'll be OK, if not,
please see the following link:
http://support.microsoft.com/default...&Product=sql2k
Also, you may want to consider running SQL backups on all of your databases,
prior to uninstalling SQL Server. This will give you one more avenue for the
restore process.
Steve
|||Hi Biva,
I am reviewing your post and our MVP provide you some good links for you
question, I want to know if you still have any question on this issue. For
any question, please feel free to post message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
downgrade from sql 2k enterprise edition to standard
Hello All,
I need to downgrade my production server from enterprise to standard edition
because of cost.
Has anyone been through this scenario?
My plan is to backup all dbs, leave data folders intact (I have db files in
4 drives), uninstall enterprise, install standard and reattach db files.
My questions are:
I have tons of jobs and DTS packages on the server. Can I simply restore
the msdb from enterprise or is it going to have problem with standard
edition?
Does anyone have a script to save logins and restore logins?
Thanks for any help,
sqlgirl"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:407a9a90$0$40211$39cecf19@.news.twtelecom.net...
> Hello All,
> I need to downgrade my production server from enterprise to standard
edition
> because of cost.
> Has anyone been through this scenario?
> My plan is to backup all dbs, leave data folders intact (I have db files
in
> 4 drives), uninstall enterprise, install standard and reattach db files.
> My questions are:
> I have tons of jobs and DTS packages on the server. Can I simply restore
> the msdb from enterprise or is it going to have problem with standard
> edition?
> Does anyone have a script to save logins and restore logins?
The following links should help you in the restore and account migration
process:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
http://support.microsoft.com/default.aspx?scid=kb;en-us;240872&Product=sql2k
With regard to your question on MSDB restore, I'm less certain if that will
work... If the SQL Server builds are the same I think you'll be OK, if not,
please see the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;264474&Product=sql2k
Also, you may want to consider running SQL backups on all of your databases,
prior to uninstalling SQL Server. This will give you one more avenue for the
restore process.
Steve|||Hi Biva,
I am reviewing your post and our MVP provide you some good links for you
question, I want to know if you still have any question on this issue. For
any question, please feel free to post message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql
I need to downgrade my production server from enterprise to standard edition
because of cost.
Has anyone been through this scenario?
My plan is to backup all dbs, leave data folders intact (I have db files in
4 drives), uninstall enterprise, install standard and reattach db files.
My questions are:
I have tons of jobs and DTS packages on the server. Can I simply restore
the msdb from enterprise or is it going to have problem with standard
edition?
Does anyone have a script to save logins and restore logins?
Thanks for any help,
sqlgirl"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:407a9a90$0$40211$39cecf19@.news.twtelecom.net...
> Hello All,
> I need to downgrade my production server from enterprise to standard
edition
> because of cost.
> Has anyone been through this scenario?
> My plan is to backup all dbs, leave data folders intact (I have db files
in
> 4 drives), uninstall enterprise, install standard and reattach db files.
> My questions are:
> I have tons of jobs and DTS packages on the server. Can I simply restore
> the msdb from enterprise or is it going to have problem with standard
> edition?
> Does anyone have a script to save logins and restore logins?
The following links should help you in the restore and account migration
process:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
http://support.microsoft.com/default.aspx?scid=kb;en-us;240872&Product=sql2k
With regard to your question on MSDB restore, I'm less certain if that will
work... If the SQL Server builds are the same I think you'll be OK, if not,
please see the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;264474&Product=sql2k
Also, you may want to consider running SQL backups on all of your databases,
prior to uninstalling SQL Server. This will give you one more avenue for the
restore process.
Steve|||Hi Biva,
I am reviewing your post and our MVP provide you some good links for you
question, I want to know if you still have any question on this issue. For
any question, please feel free to post message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql
Downgrade Enterprise edition to Standar edition
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.
You'll have to backup all of your databases, de-install EE, install Std and
then restore all DB's.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.
|||But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.
You'll have to backup all of your databases, de-install EE, install Std and
then restore all DB's.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.
|||But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>
Downgrade Enterprise edition to Standar edition
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.You'll have to backup all of your databases, de-install EE, install Std and
then restore all DB's.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.|||But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.You'll have to backup all of your databases, de-install EE, install Std and
then restore all DB's.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Frivas" <Frivas@.discussions.microsoft.com> wrote in message
news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.|||But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>
Downgrade Enterprise edition to Standar edition
Hi all!
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>
I want to change from sql server enterprise edition to sql server standar
edition due to licensing cost. Do anybody have do this?
Any KB article saying hot to reach this?
Thanks for your help.But definately what is offered by EE like log shipping & other features will
not be available once you switch to Std edition.
Thanks
Ajay Rengunthwar
MCDBA MCAD
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OUGHh9RpFHA.3036@.TK2MSFTNGP14.phx.gbl...
> You'll have to backup all of your databases, de-install EE, install Std
and
> then restore all DB's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Frivas" <Frivas@.discussions.microsoft.com> wrote in message
> news:0019A024-0A90-4741-9006-0236775787CD@.microsoft.com...
> Hi all!
> I want to change from sql server enterprise edition to sql server standar
> edition due to licensing cost. Do anybody have do this?
> Any KB article saying hot to reach this?
> Thanks for your help.
>
Subscribe to:
Posts (Atom)