User Tools

Site Tools


mirnshi:shrink_the_larger_log_of_mssql_server

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 ''?'''

Discussion

, EVgApmViIT, 2012/01/06 10:42

What a joy to find someone else who tihkns this way.

Enter your comment. Wiki syntax is allowed:
 
mirnshi/shrink_the_larger_log_of_mssql_server.txt · Last modified: 2009/02/12 03:58 by mirnshi