Re: SQL or Access ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: david epsom dot com dot au (david_at_epsomdotcomdotau)
Date: 05/11/04 

Date: Tue, 11 May 2004 10:10:31 +1000

> Just curious. Why does each site require a DBA?
>
> If the app data schema is static and so long as you do the following:
> BACKUP LOG dotnetnuke WITH TRUNCATE_ONLY

Because your file system admin, who set up the file system back up and
applies the file system patches, may not even have heard of "BACKUP LOG
dotnetnuke WITH TRUNCATE_ONLY."

(david)

"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:qr10a05oe5hipgfebd5o7sg3llvsu5v0ct@4ax.com...
> "david epsom dot com dot au" <david@epsomdotcomdotau> wrote:
>
> >SQL Server applications will require the services of a database
> >administrator at every site, at least part time. If you can justify
> >the cost of the DBA, you will get much more value out of him if
> >he is supporting SQL Server, rather than supporting a Jet database.
>
> Just curious. Why does each site require a DBA?
>
> If the app data schema is static and so long as you do the following:
> BACKUP LOG dotnetnuke WITH TRUNCATE_ONLY
> and
> BACKUP DATABASE dotnetnuke TO DISK =
> 'C:\backup\today\SQLServer\dotnetnuke.bak'
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm

Relevant Pages

  • Re: SQL or Access ?
    ... Why does each site require a DBA? ... > BACKUP LOG dotnetnuke WITH TRUNCATE_ONLY ... Because your file system admin, who set up the file system back up and ... may not even have heard of "BACKUP LOG ...
    (microsoft.public.access.developers.toolkitode)
  • [C.O.L.M][Long..] Dealing with full file system on Oracle-Linux host? Best Practice?
    ... alert that a file system is full. ... Does this file system hold data files for a database? ... once the DBA has some answers to the above questions or some ... Scenario 1: ...
    (comp.os.linux.misc)
  • Re: what sort of dba can you get for 100K nowdays
    ... You'd expect most DBAs to realize that (besides CPU) the most common ... None knew their current file system block size (but few knew oracle's ... DBA salary anymore. ...
    (comp.databases.oracle.server)
  • Re: what sort of dba can you get for 100K nowdays
    ... You'd expect most DBAs to realize that the most common ... None knew their current file system block size (but few knew oracle's ... DBA with good understanding of the underlying hardware and software can be ... color of the database takes least RAM. ...
    (comp.databases.oracle.server)