Schedule database shrink and defrag - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Schedule database shrink and defrag

Message

From

04/09/2009 16:26:39

Naomi Nosonovsky
Wisconsin, United States

To

04/09/2009 10:56:24

Winan Jaya
Jakarta, Indonesia

General information

Forum:

Microsoft SQL Server

Category:

Database management

Title:

Re: Schedule database shrink and defrag

Environment versions

SQL Server:

SQL Server 2005

Application:

Desktop

Miscellaneous

Thread ID:

01422674

Message ID:

01422724

Views:

35

>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