September 22, 2009 at 3:37 am
hi all,
i have task to Down Grading SQL Server 2008 from enterprise edition to devloper edition due license issue.
I am thinking to deattach all dbs take script users linked server database roles and all.
uninstall the entprise and install developer edition.
attach all db's and run script for users and linked.
will i face any issue that should address first. I am more concern with user login. will this create problem for me.
regards
ramu.
September 22, 2009 at 3:44 am
ramuvanparti (9/22/2009)
hi all,i have task to Down Grading SQL Server 2008 from enterprise edition to devloper edition due license issue.
I am thinking to deattach all dbs take script users linked server database roles and all.
uninstall the entprise and install developer edition.
attach all db's and run script for users and linked.
will i face any issue that should address first. I am more concern with user login. will this create problem for me.
regards
ramu.
Before deattaching the databases, I would backup them up first. always take care when doing any upgrade or downgrade. apart from logins, linked servers, remember to script anything like replication and script any jobs that you use. also script anyhting that might have been stored in any of the system database and any user configuration changes.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 22, 2009 at 3:51 am
October 1, 2009 at 7:44 am
hi all,
can do this way to restore all setting which were present in the server.
1) restore master and msdb database to new installed server
2) Before uninstalling i will copy all the data folder contains and uninstall enterprise edition and install developer edition and stop the services and rename old data folder and paste the new data folder and restart the server.
Will these option work fine or will have any issue with it.
i dont know how restore master database
October 2, 2009 at 3:31 pm
Recover the master database in SQL Server
http://blogs.techrepublic.com.com/window-on-windows/?p=390
MJ
October 2, 2009 at 4:04 pm
Oops, didn't read original post properly. Rest of post removed. Apologies...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply