Schedule database shrink and defrag - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Schedule database shrink and defrag

Message

De

04/09/2009 16:26:39

Naomi Nosonovsky
Wisconsin, États-Unis

À

04/09/2009 10:56:24

Winan Jaya
Jakarta, Indonésie

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Maintenance bases de données

Titre:

Re: Schedule database shrink and defrag

Versions des environnements

SQL Server:

SQL Server 2005

Application:

Desktop

Divers

Thread ID:

01422674

Message ID:

01422724

Vues:

36

>Dear Expert,
>
>How to schedule database shrink and database defrag? ..
>
>please advise
>
>Thanks
>
>Winanjaya

See also

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/do-not-truncate-your-ldf-files

and

8 Steps to better Transaction Log throughput
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform