SQL Server Maintenance Routines/Procedures

From: "Mark D Powell" <Mark.Powell@xxxxxxx>
Date: 17 Mar 2006 12:53:32 -0800

I recently learned that there is a stored procedure
sp_delete_backuphistory that cleans up the msdb for information related
to backup jobs. I tried the procedure in test and it ran 5 hours with
a target date of the first day in 2003. Obviously my databases have
been around a while. Up until now I thought the limit values entered
into the EM maintenance plan limited the history that SQL Server keep.
Obviously I was wrong.

I am wondering if there are any other maintenance procedures, other
than the standard optimization tasks, that I should be looking at
running on a regular basis to keep the master, msbd, and tempdb in good
shape?

Thanks in advance

-- Mark D Powell --

.

Prev by Date: Re: SQL query - duplicate records - different dates - how to get only latest information?
Next by Date: Re: outer join column
Previous by thread: Dell Raid 0+1
Next by thread: mysterious corruption of stored procedures
Index(es):
- Date
- Thread

Relevant Pages

Re: how to automatically delete a row after the elapsed time?
... i have to write a process which cleans up ... any database feature which allows the automatic deletion of records ... Dbdelete is at least as fast as using dbaccess and a DELETE script and tends to be faster than an equivalent stored procedure running the simple DELETE. ...
(comp.databases.informix)
Re: Unable to locate job scheduling stored procedures
... sp_add_job and all other SQL Server Agent stored procedure exist in the msdb ... database, ... You can fix this by either starting your script with "USE msdb", ...
(microsoft.public.sqlserver.msde)
Re: how to automatically delete a row after the elapsed time?
... i have to write a process which cleans up ... any database feature which allows the automatic deletion of records ... You will most likely end up writing a stored procedure or other process ... possibly via cron). ...
(comp.databases.informix)
Re: Permission necessary for a normal user to create and run DTS? Thanks.
... public role has execute permissions on sp_add_dtspackage ... stored procedure in msdb and the guest account is enabled in ... msdb so it depends on whether you have changed this or not. ...
(microsoft.public.sqlserver.server)
Re: disable/enable all SQL Agent jobs in a non cursor approach
... because you should be calling a stored procedure for each ... (As opposed to updating a table somewhere in MSDB, ... What is wrong with a cursor approach for this type of one-off, ...
(microsoft.public.sqlserver.programming)