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!

Database Maintenance Plan

Status
Not open for further replies.
GysE

GysE

Programmer
Jun 21, 2002
16
0
0
ZA
What is the correct order to schedule a database maintenance plan?
I want to include the following option: Optimization, Integrity and Complete Backup.

What will happen if the one process overlaps with next of previous process?
I assume the SQL Agent will take care of it.

I would like to know what the most efficient order is.
 
Status
Not open for further replies.

Similar threads

niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
67
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
79
Chris Miller
Chris Miller
iambob
  • Locked
  • Question
Retrieve Data from Database - SQL 1
Replies
2
Views
43
TamarGranor
TamarGranor
tn_sudheer
  • Locked
  • Question
Accessing data from database between given time stamps
Replies
11
Views
105
Andrzejek
Andrzejek
ms901Boss
  • Locked
  • Question
Converting DB2 query to Microsoft Database
Replies
1
Views
84
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top