RS First Dynamics NAV Blog

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

Truncate the database and shrink the database

Truncating Log Files   Truncate the database and shrink the databaseThe following set of SQL will shrink your database and “truncate” the log file. File in the parmaters surrounded by <…>.  Note that you’ll need the two filename values from step 1. USE <yourdatabasename>GOBACKUP LOG <yourdatabasename> WITH TRUNCATE_ONLYGODBCC SHRINKFILE (<yourdatabaselogfilename>, 1)GODBCC SHRINKFILE (<yourdatabasedatafilename>, 1)GOexec sp_helpfile 
Leggi tutto il post...
Categoria: Sql Server ALL
martedì, 11 gen 2011 Ore. 16.00

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