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~~ | ||
