|
Posted by Greg D. Moore \(Strider\) on 09/06/05 19:10
"TheScullster" <phil@dropthespam.com> wrote in message
news:A8mdnRQUcufeMoDeSa8jmw@karoo.co.uk...
> Hi all
>
> Sorry if this is such a mega dumb question for this group, but what
exactly
> is involved in maintaining/supporting a SQL database?
>
> My company is looking at accounting software "Great Plains" which they
> intend to run on SQL server.
> Having only had experience of a split Access database, this is something
of
> a quantum leap for me!
> The only maintenance I do on the Access version is a scheduled nightly
> compact/repair on the back end and have the front ends set to compact on
> close.
>
> So what is involved with the SQL database?
> Is it straightforward, or should I be talking the company into paying for
> yet more "maintenance/support" for someone to remote in weekly and perform
a
> similar function?
Depends. How important is the data?
Most critical thing you probably need to know is how to do backups and what
type and how to do a restore.
If you can reliably do backups and restores, for your needs you're probably
85% of the way there.
>
> Any help appreciated.
>
> Phil
>
>
Navigation:
[Reply to this message]
|