Is your log file too large? Apply this command so that your log file will shrink to 1 MB.

BACKUP log <your databasename> with truncate_only

DBCC shrinkfile (<your database log filename>, 1)

VN:F [1.1.6_502]
Rating: 0.0/5 (0 votes cast)
Share:
  • Digg
  • del.icio.us
  • Facebook
  • Google
  • DotNetKicks
  • LinkedIn
  • Live
  • MySpace
  • StumbleUpon
  • Technorati

Related posts:

  1. Get current date format of SQL Server database
  2. Download any file from ASP.NET
  3. Get all table names from Microsoft Access (MDB) database file
  4. Free database comparison tool
  5. Connect using UDL file from .NET