Re: Total Newbie - Maintainenance of SQL Database

Hi

If you are having a consultancy migrate/install this packaged solution then
you would need to state that the system will have to included scheduled
maintenance. I don't know the package but they may provide their own front
end administration tool, which should be suitably documented. This should
cover most day to day issue but you may also require support if something
more serious happens.

As far as SQL Server is concerned you may want to look at books online and
the sections on
"Automating Administrative Tasks", "Backing Up and Restoring Databases", "
Monitoring Server Performance and Activity" and "Rebuilding an Index"
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx

There is a specific newsgroup for Great Plains -
microsoft.public.greatplains as well as general accounting newsgroups and
they may help on advice as you will also probably need support on using the
application as well as maintaining the database

It may help to browse:
http://www.microsoft.com/BusinessSolutions/Community/GettingStarted.mspx

John


"TheScullster" <phil@xxxxxxxxxxxxxxx> wrote in message
news:A8mdnRQUcufeMoDeSa8jmw@xxxxxxxxxxxxxx
> 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?
>
> Any help appreciated.
>
> Phil
>


.

Relevant Pages

  • Re: SQL 2000 after upgrade to server 2003 from NT4
    ... Try to change the owner for each job to "sa". ... > Within the SQL Enterprise Manager under Management->Database Maintenance ... > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan ...
    (microsoft.public.sqlserver.setup)
  • RE: Event 3760 Error
    ... SQL Database 'STS_TSMAIL_1' on SQL Server instance ... Microsoft CSS Online Newsgroup Support ... <Source: Windows SharePoint Services 3 ... <SQL Database 'STS_TSMAIL_1' on SQL Server instance ...
    (microsoft.public.windows.server.sbs)
  • Re: Questions on a Database with Mass Data
    ... SQL server, how much involvement would I expect from our IT department? ... SQL Server 2005 learning resources (free online videos) ... FE to each BE and let a query to grab the specific data from a specific year ... I also heard that SQL database can handle the massive data. ...
    (microsoft.public.access.modulesdaovba)
  • The need to get around the 4000 character limit in varchar2
    ... I was approached by a developer this morning, who has a SQL server ... The SQL database has a few columns that are varchar columns, ... At this point I know of no way to migrate this data across to Oracle ...
    (comp.databases.oracle.server)
  • Creating/adding column description, not caption
    ... How do I get these descriptions back into my SQL Server 2000 database? ... I've generated the script and have made some changes to the SQL database, ... like changing the data types and sizes. ...
    (microsoft.public.sqlserver.dts)