-
Production tasks?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|