Hello:

I relatively new to SQL server.

We purchased an application from a vendor and are currently testing it.
As I think of what I nee to do for production next month, I have thought
of the following:

1)I intend to backup the databse nightly and dump tran twice a day. I
will be running dbcc newalloc and dbbc checkdbinsqlmaint before doing
the backup.

2) Run update statistics nightly and may be run a count(*) for all
actve, non-code tables;

3) run checktable(syslogs) to monitor the tran log each morning.


4) check there are no select into's used or really long_running
transactions.

--What else should I be doing, either in a nightly batch on online
during the day?

-- Aside from manually checking device size space used for the databse,
what else can I use to do so?


How can I monitor the error log for errors --and which ones -- and send
myself a notification immediately?

Any information you can provide wuld be greatly appreciated. Thanks.

David Spaisman