Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

maintenance plans best practices on system DBs

Status
Not open for further replies.
jlaw10

jlaw10

Technical User
Jul 28, 2005
54
US
I have a SQL 2000/2005 instance and am setting up maintenance plans. I was told that is best to only do maintenance plans (update stats, shrink DBs, rebuild indexes, etc) on User DBs. Should these also be periodically run on system DBs?
 
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
191
TheBugSlayer
TheBugSlayer
baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
220
iambob
iambob
lavadan
  • Locked
  • Question
SQL Maintenance Job Schedule
Replies
0
Views
75
lavadan
lavadan
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
185
JScannell
JScannell
mrmovie
  • Locked
  • Question
ODBC connection, or other from Linus system using AD account details 2
Replies
2
Views
110
mrmovie
mrmovie

Part and Inventory Search

Sponsor

Back
Top