Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

CAN MS SQL 2005 EXPRESS RUN A MS SQL 2005 WORKGROUP DATABASE

WE ARE A SMALL COMPANY.
I HAVE A STANDBY PLAN. MY MAIN SQL SERVER RUNS 2005 WORKGROUP, THE STANDBY RUNS 2005 EXPRESS. IN THE EVENT OF A FAILURE, THE LIVE DATA IS RESTORED FROM A USB STICK TO THE STANDBY SERVER.
WILL 2005 EXPRESS BE OK TO RUN A WORKGROUP DB - THERES NOTHING FANCY GOING ON, NO SCRIPTING, NO SPROCS JUST AN ACCESS FRONT END WITH AN ODBC CONNECTION.

I HAVE NOT BOUGHT THE WORKGROUP VERSION YET SO I CAN'T TEST IT.

EXCUSE THE UPPERCASE TYPING....
0
STOCRIC
Asked:
STOCRIC
  • 7
  • 5
  • 2
1 Solution
 
jmoss111Commented:
It should be OK. Just be advised that SQL Express will only handle databases up to 4 GB and will only use 1 GB memory.
0
 
Éric MoreauSenior .Net ConsultantCommented:
>>EXCUSE THE UPPERCASE TYPING....

is your capslock key broken?

The Express edition has limitations:
-1 CPU only
-4 gb database size limit
-5 simulatenous users
0
 
STOCRICAuthor Commented:
Thanks for your comments.

I am aware of the restrictions, but what I don't know is will the dB work OK once it's been restored.

1. I've only got 1 processor
2. The dB is only 100mb and is growing at 16mb per Quarter.
3. I have 16 concurrent users in SQLEXPRESS and it dosn't seem to mind (in the management info)

I understand that it'll be dog slow, but it just has to plod along until the main server is fixed.

I'm even thinking of getting the Std version of SQL to make best use of the RAM in the server.

I've tested the scenario as described above (with both servers running EXPRESS) and it works very well - about 5 minutes to go from Live to Standby, I just don't wnat to buy Std and find out that the dB's are not cross compatible.


0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
jmoss111Commented:
Actually Express has no 5 user limitation...
0
 
jmoss111Commented:
I have 160 something users and it runs fine and not slow at all.
0
 
STOCRICAuthor Commented:
Thanks J Moss

BTW
I wonder has anyone really tested that EXPRESS does not make use of 2 processors, as I have a SQL server running on 2 processors and it really, really flies...so much so that I wonder if MS just make the software look like it doesn't

Just wondered...
0
 
Éric MoreauSenior .Net ConsultantCommented:
jmoss111 is right. there is no more engine throttling after 5 concurrent users

As per http://msdn.microsoft.com/en-us/library/ms345154.aspx

The SQL engine supports 1 CPU, 1 GB RAM, and a 4 GB database size. This mechanism permits easy differentiation from other SQL Server 2005 editions by having well defined cut-off points. Otherwise, there is no workload throttle and the engine performs as in other editions. There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve acceptable response times from a SQL Server Express database.

SQL Server Express can install and run on multiprocessor machines, but only a single CPU is used at any time. Internally, the engine limits the number of user scheduler threads to 1 so that only 1 CPU is used at a time. Features such as parallel query execution are not supported because of the single CPU limit.


0
 
jmoss111Commented:
STORIC,

I have no idea of how to test. My SQL Express server is on quad CPU IBM eServer and I only see activity on 2 cpu's. My server is Express backend, Access 2003 front end using pass throughs and does mainly searches with data loaded overnite and the apps have very good response time.
0
 
jmoss111Commented:
Thanks for the C storic. I hope you realize that a C is a slap in the face.  What did I do to deserve a C?
0
 
STOCRICAuthor Commented:
I'm very sorry, I was unaware of this, (I am a relatively new person on EE)
I was only being honest with my assessment. My question was does it work, your answer was it should be OK, that is inconclusive

I accepted your comment with the possibility that it might not be OK, therefore it was average.

I meant no offence. If someone said I was average at my job I wouldn't be offended. I'm no genius, that's why I ask for help on EE.

I do appreciate your help JM, thanks.

I'm happy to reverse this if it's possible and give you an A if you want (i have no qulams about that), I guess my next question is How do I chnage a C to an A?

0
 
jmoss111Commented:
So if that is your assessment, then that is what it is. Score many questions like that and nobody will answer your questions.
0
 
STOCRICAuthor Commented:
Is that really the case?

Is it so bad to be normal or average?

Should the Average be renamed Slap in the Face? as my understanding of average is not yours, as an IT Professional I try an avoid misleading desriptions of key fields.

OK that's over with, how do I change your rating to A?










0
 
jmoss111Commented:
That is really the case. People volunteer their time here, thats above average. What would I have to have done to get an A?
0
 
STOCRICAuthor Commented:
A simple boolean yes it can be done or no it can't would get an A.

I'm extremely grateful to those people who volunteer their time to answer these questions, but it is the volunteers understanding that it is the person asking the question's perogative to assess the solution provided. As it is your perogative to decide if you want to respond.

You respond because you want points and recognition (QED your query about the grade C) I want an accuate answer, I pay my premium member's fee and I decide which solution I accept - it as contract per question, nothing more.

I guess my point is you get an A if the answer is conclusive, a B if it leads you to the conclusion, and a C if it's inconclusive.

Again I thank you for your effort.



0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now