Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shorte
Starting Member
1 Post |
 Posted - 2005-08-23 : 12:50:55
|
| On one of our servers we have a client running MSDE (it's our Vertias backup program). I need to install a program that uses an MSDE database on the server. Can I use the current version of MSDE to run both the Veritas backup software and the other program I need? Is there any constraints to the number of accesses MSDE will allow? -- i.e. Veritas is using MSDE and my other program will be also, will one be waiting for the other? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-23 : 15:12:56
|
| yes, MSDE has some limitations. Most notably:1. 2GB RAM limitation (per instance)2. 2GB databas size limiation (per database)3. Workload governorhere is some info on the workload governor: http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=trueYou are also missing some of the management tools and fun features like full text indexing, no sql profiler, no BOL, only 2 CPUs supported etc.-ec |
 |
|
|
|
|
|
Running multiple databases from one MSDE