Solved

best-practises/standards for ManagementTasks

Posted on 2011-09-27
3
160 Views
Last Modified: 2012-06-21
are there best procedures to go about the above?
0
Comment
Question by:25112
  • 2
3 Comments
 
LVL 5

Author Comment

by:25112
ID: 36711867
sorry I meant management plans..

like which comes first checkdb or backup or rebuild index etc

also what level of fragmentation should rebuild/reorg/statistics should be done..

any article on this from MS or experts?
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 36715066
0
 
LVL 5

Author Comment

by:25112
ID: 36716198
exactly...
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now