You are here: Re: Total Newbie - Maintainenance of SQL Database « MsSQL Server « IT news, forums, messages
Re: Total Newbie - Maintainenance of SQL Database

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация