RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

Shrink defrag databases - Test Script

Shrink defrag databases An the end, only you can determine whether you want to shrink or not. With above information, you hopefully have enough to go on when making that decision. You probably know by now what I think of regular shrinking. Not to talk about autoshrink. :-)Below you find the T-SQL code I ran to prove that shrinking of a database will generate the same amount of transaction log records as the amount of data which was moved. (The script uses the 'NUL' filename as backup destinatio 
Leggi tutto il post...
Categoria: Sql Server ALL
mercoledì, 01 set 2010 Ore. 09.20

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003