Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uryy4me
Starting Member
3 Posts |
 Posted - 2009-01-05 : 11:27:22
|
| I have a table in the MSDB DB It is rather large. What is the best way to delete some of the records with little impact on the production server. Similar to... the sproc that gets rid of backup history...below..sp_delete_backuphistory @startDate |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
uryy4me
Starting Member
3 Posts |
Posted - 2009-01-05 : 11:49:46
|
| How about cleaning up those old records in there now? or will modifying the maintenance plan clear out those old records? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
best way to manage sysmaintplan_logdetail