MSDE vs Ms SQL

[mando70]

what is the differance/advantage between using MSDE and MS SQL in epo 3?

 

[kebler]

MSDE is the desktop version and is limited not only in database size, but in the number of concurrent transactions that can take place (I believe).

MS SQL is the full blown server version that has greater capabilities.

 

[pytchley]

MSDE has a 2gB limit and has a 'performance throttle' which kicks in at 13 threads. This is about 6 concurrent users. MSSQL does not have these limits but need licences for each potential concurrent user. MSSQL will upgrade your MSDE SQL installation with changes to the master database.

 

[bfralia]

You can get a site license (unlimited users) for MSSQL for a reasonable cost. Then it's a handy repository for a lot of little utility databases like ePO.

MSSQL also has built in utilities to shrink the database or schedule backups without having to have special backup products.

 

[ESTAGroup]

Does anyone knwo how to automate the backup of an MSDE database without having to manually shut down the services and keep users out? MS-SQL can do this but we don't know how to do this with and MSDE database.