Back up the transaction log for the database to free up some log space.

Error: Back up the transaction log for the database to free up some log space.

To recover from a full transaction log

If the log is 100% full you cannot truncate it by backing it up, since the backup has to be recorded in the transaction log. For version 6.5, use:

DUMP TRANSACTION dbName WITH NO_LOG

And for version 7 or later:

BACKUP LOG  WITH NO_LOG

Since you cannot continue to perform transaction log backup after this command has been executed, you should perform a database backup.

SQL Server Datatypes

Data Types

  • sql_variant: Stores values of various
    SQL Server-supported data types, except text, ntext, and timestamp.
  • timestamp: Stores a database-wide
    unique number that gets updated every time a row gets updated.
  • uniqueidentifier: Stores a globally
    unique identifier (GUID).
  • xml: Stores XML data. You can
    store xml instances in a column or a variable (SQL Server 2005 only).
  • cursor: A reference to a cursor.
  • table: Stores a result set for later
    processing.