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

Real name:

E-Mail:

Website:

Address:

Enter your comment. Wiki syntax is allowed:

Please fill all the letters into the box to prove you're human. G L D K Z Please keep this field empty: