Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
  Results
CMS-XML LDF or Transaction Log in SQL Server 2000 consistently grows in size and needs to be shrunk.
You must run a BACKUP LOG statement to free up space by removing the inactive portion of the log. You must run DBCC SHRINKFILE again with the desired target size until the log file shrinks to the target size. The following example demonstrates this with the pubs database and attempts to shrink the pubs_log file to 2 MB:

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs