mirnshi:shrink_the_larger_log_of_mssql_server
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | mirnshi:shrink_the_larger_log_of_mssql_server [2009/02/12 03:58] (current) – created mirnshi | ||
---|---|---|---|
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 ' | ||
+ | |||
+ | |||
+ | {{tag>}} | ||
+ | |||
+ | ~~LINKBACK~~ | ||
+ | ~~DISCUSSION~~ | ||
mirnshi/shrink_the_larger_log_of_mssql_server.txt · Last modified: 2009/02/12 03:58 by mirnshi