Solved

SQL - Workgroup / Standard Upgrade question

Posted on 2008-06-24
6
445 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

776 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