Try these in Query Analyzer :
To find the used size of the log file :
1. dbcc sqlperf (logspace)
To backup the log
1. backup log db_name to db_name_log with init (or noinit)
- with init will override the old backup log file
- with noinit will append to the old backup log file
To truncate the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.