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 ''?'''
mirnshi/shrink_the_larger_log_of_mssql_server.txt · Last modified: 2009/02/12 03:58 by mirnshi
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
Discussion
What a joy to find someone else who tihkns this way.
bismillahi http://obatherbalterpercaya.com/ http://herbalcakrawala.com/2018/08/13/obat-kelesterol/ https://sites.google.com/site/obatkolesterolpalingampuh/
bismillahi http://obatherbalterpercaya.com/obat-katarak/ http://obatherbalterpercaya.com/obat-katarak/