Solved

SQL - Workgroup / Standard Upgrade question

Posted on 2008-06-24
6
446 Views
Last Modified: 2010-05-18
i read this through ee/kb
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22853240.html
reading "zcrammond" (wrote) comment.

my questions:
in the subject - comments,
which version was it? (sql workgroup or sql standard) i am confused!

if buy sql2005 workgroup (5-cal) do i uninstall SQL Management Studio Express still?
or was that the sql standard version that was discussed in that regarding to uninstall management studio express?

-------

I know for sure we will be working on the in-place upgrade (without changes name instance) the concern is, which version require to uninstall management studio express?

thank you!
Sam
0
Comment
Question by:samntlam
  • 3
  • 3
6 Comments
 
LVL 10

Expert Comment

by:TAB8
ID: 21862734
Standard and workgroup have teh full version of Management stuido ..  so yes if you have the sql express ms version .. backup your databses and uninstall sqlexpress..  install SQL Standard or workgroup and restore your DB's
0
 

Author Comment

by:samntlam
ID: 21862796
Tab8:
what happen to the "in-place" upgrade? after uninstalled sqlexpress?
Sam
0
 

Author Comment

by:samntlam
ID: 21862827
And, backup database from same folder / directory & restore them to the same folder / directory after upgraded to SQL Workgroup - Standard!... does this sound right? and
Will this represent conflict - double work since these database were already in it resided folder / directory?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 10

Expert Comment

by:TAB8
ID: 21869635
the inplace upgrade will refer to upgradin versions on the same server .. not side by side ie 2 differrent servers ....   as for  (backup database from same folder / directory & restore them to the same folder / directory after upgraded to SQL Workgroup - Standard) No you dont need to worry about this ...  Just make sure you take a full backup of all the databses... if it was my upgrade I would do the following
1, backup all databses
2, Script all user accounts and permissions (heap of these on teh web)
3, script any agent jobs
4, uninstalll SQL express (as thsi will be the default sql instance)
5 install your standard edition
6, restore you db's
7, run scripts to create users

all done  :)
0
 

Author Comment

by:samntlam
ID: 21869780
Wow! sound so easy...
does that also apply to workgroup edition?
just in case we decided to buy workgroup instead of standard and do you know what's the differences between them? (workgroup - standard)

----
if i didn't mention before, our production works 7 days a week and rely on the database to get all the work done.

since everybody will be log off and stop all operations during the in-place upgrade
my hesitation - worrying would be....
how much of time spend on the steps - process that you just described?

I am sure restarting the server is a MUST! in that situation (uninstalling - installing i.e)
I have not include - thinking of any possible WSUS for SQL before and after...

Sam
0
 
LVL 10

Accepted Solution

by:
TAB8 earned 500 total points
ID: 21871787
You will need some downtime ...
you will also need to apply Service Packs etc ....

Workgroup and Standard are pretty much the same (same to install) the feature differance between the two can be found on the Microsoft website

I would go standard ..  as in the past when I have priced the two options they work out the same as you couldnt get workgroup without software assurance ...
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question