SQL 2008 R2 Express vs Workgroup Edition 1

[1DMF]

I was hoping someone could tell me if it is worth gong down the route of the workgroup version of SQL or is Express good enough?

I know the limitations such as 1GB memory per instance, 1 processor (unlimited cores) , 10GB DB size for Express.

We aren't likely to go over this for the forseable future for any of our instances, and I understand studio tools comes with express (although cutdown), but as I've never run the SQL profiler / analyser nor know how to use it, do we need extra SQL tools?

I need to create tables, access the data, write and runs stored procedures, set up table access privilages, security logins, maintenace jobs (SQL Backup) , the usual basic stuff.

I take it I can do all this with the Express tools?

Your advice is apprciated.

Cheers,
1DMF



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta

 

[SQLScholar]

To the best of my knowledge:

create tables - yes
access the data - yes
write and runs stored procedures - yes
set up table access privilages - yes
security logins - yes
maintenace jobs (SQL Backup) - Kind of yes and and kind of no. There are no maintenance jobs and there is no SQL agent so you cant schedule via that. However i have done it before where i have use SQLCMD and a windows scheduler to do the backup and maintenance.

For the maintenance - when you have sqlexpress (and other times!) this guys work is a lifesaver!

http://ola.hallengren.com/

Its a really good maintenance solution - its won many awards. It will make your life easier to write a scheduled SQLCMD backup and maintenance.

Dan


----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[1DMF]

Well i guess the service provider will be backing up the SQL db's.

I just like to run the agent to create a .BAK file and use our remote DR backup to offsite a copy.

Hopefully with the link you gave I can still perform this backup / ofsite DR.

I think for what we use SQL, and the rediculous cost of ownership / licencing for the other versions we will go with SQL Express then upgrade the version should the need arise in the future.

Many thanks.
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta