Wednesday, March 7, 2012

msde

I recently joined a company where they have couple of MSDEs that were
installed as part of the software application package. Do they need to be
administered as well alongwith the other Standard and Enterprise SQL Servers
installations?sharman,
The answer about how much administration depends on how these MSDE servers
are being used.
If they hold critical data, then yes they need to be administered along with
the other SQL Servers. If there are security issues related to access, these
need to be managed as well.
If the application simply uses these databases as a temporary workarea and
can easily rebuild the data in case of problems, then the management is
less. It would still be good to have database backups that could restore
the metadata.
You need to understand what is going on with the MSDEs and then you can make
a good decision.
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1B413580-5393-405C-81CD-0CECD6D4DA83@.microsoft.com...
>I recently joined a company where they have couple of MSDEs that were
> installed as part of the software application package. Do they need to be
> administered as well alongwith the other Standard and Enterprise SQL
> Servers
> installations?

No comments:

Post a Comment