Differences

This shows you the differences between two versions of the page.

mirnshi:shrink_the_larger_log_of_mssql_server [2009/02/12 11:58] (current)
mirnshi created
Line 1: Line 1:
 +====== Shrink the larger log of MSSQL Server ======
 +  1. BACKUP DATABASE database_name TO backup_device
 +  2. BACKUP LOG database_name TO backup_device
 +  3. DBCC SHRINKFILE (log_file_name)
 +\\
 +list the size of tables
 +  EXEC sp_msforeachtable 'sp_spaceused ''?'''
 +
 +
 +{{tag>}}
 +
 +~~LINKBACK~~
 +~~DISCUSSION~~
 
mirnshi/shrink_the_larger_log_of_mssql_server.txt · Last modified: 2009/02/12 11:58 by mirnshi
 
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki