Re: SQL or Access ?

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


Date: Tue, 11 May 2021 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