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