I need some help...
Can someone please, in point blank form tell me the difference between
Database maintenance and Database Administration? This might seem
obvious, however apparently I am not certain.
thxDatabase Administration is the task you undertake when agreeing to administe
r a database for your
company (typically). It can involve tasks such as:
Planning, implementing and managing permissions
Writing stored procedures
Performance tuning
Import/export of data
...
Among the things a dba typically is responsible for is database maintenance
(things you typically
does at a regular schedule):
Backup
Defragmentation
Integrity check of the database
...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<angela.solorzano@.ca.wunderman.com> wrote in message
news:1123182460.104320.150300@.f14g2000cwb.googlegroups.com...
>I need some help...
>
> Can someone please, in point blank form tell me the difference between
> Database maintenance and Database Administration? This might seem
> obvious, however apparently I am not certain.
>
> thx
>|||I guess that the terms are often used interchangeably, though intuitively,
I'd say that maintenance is a private case of administration.
That is, "administrating" involves both setting up the environment, creating
objects, etc., and also taking care of already existing environment/objects,
while "maintaining" refers to only the latter.
Nothing formal, just something that seems intuitive.
BG, SQL Server MVP
www.SolidQualityLearning.com
<angela.solorzano@.ca.wunderman.com> wrote in message
news:1123182460.104320.150300@.f14g2000cwb.googlegroups.com...
>I need some help...
>
> Can someone please, in point blank form tell me the difference between
> Database maintenance and Database Administration? This might seem
> obvious, however apparently I am not certain.
>
> thx
>
Showing posts with label administration. Show all posts
Showing posts with label administration. Show all posts
Wednesday, March 7, 2012
Friday, February 17, 2012
database log growth too fast
Dear all
My database log growth is too fast. I want to stop this situation. I am a rookie in database administration. Please give me some suggestions. Thanks a lot.
Alex
Perhaps you are able to shrink this from time to time within a maintaince plan, or a manually setup jon in SQL Server ?http://www.aspfaq.com/show.asp?id=2471
HTH, jens Suessmeyer.|||thx
Subscribe to:
Posts (Atom)