software.safish.com
Blog
Home
All Articles
Sticky
Software
PhotoTool
Online Tools
Mortgage Calculator
Compound Interest Calculator
Future Value Calculator
Future Value Annuity Calculator
Links
Subscribe
Truncating SQL Server Log Files
Created 12 November 2003 00:00
You can get the name of the log file for your database by looking in the
sysfiles
table.
BACKUP LOG <database> WITH TRUNCATE_ONLY DBCC SHRINKFILE ('<logfile>', 100, TRUNCATEONLY)
0 comments
|
Add comment
×
Add Comment
Name *
Email (optional)
Web site (optional)
Enter the text on this image *
Comment *
Markdown format
Cheatsheet