mordi
asked on
Transaction log can'r be shrink
My trabsaction log is always increasing in size.
Also after a Backup to the database it is stil full.
How can i solve this?
Also after a Backup to the database it is stil full.
How can i solve this?
dump tran [DATABASE] with no_log
dump tran [DATABASE] with no_log
If you're wanting to reclaim physical disk space by shrinking the LDF file, use:
DBCC shrinkfile filename, , TRUNCATEONLY
DBCC shrinkfile filename, , TRUNCATEONLY
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.