The transaction log for the database is full

by

To fix this problem, change Recovery Model to Simple then Shrink Files Log

1.
Database Properties > Options > Recovery Model > Simple

2.
Database Tasks > Shrink > Files > Log

Done.

Then check your db log file size at
Database Properties > Files > Database Files > Path

To check full sql server log: open Log File Viewer at
SSMS > Database > Management > SQL Server Logs > Current

More Related Contents:

  1. Unpivot with column name
  2. How can I delete using INNER JOIN with SQL Server?
  3. Is there a way to access the “previous row” value in a SELECT statement?
  4. Convert varchar into datetime in SQL Server
  5. sql query to return differences between two tables
  6. Check if a row exists, otherwise insert
  7. SQL Server : dynamic pivot over 5 columns
  8. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  9. How to write UPDATE SQL with Table alias in SQL Server 2008?
  10. SQL Server 2008- Get table constraints
  11. Restrict an SQL Server connection to a specific IP address
  12. Execute Dynamic Query with go in sql
  13. TransactSQL to run another TransactSQL script
  14. How can I get a list of element names from an XML value in SQL Server
  15. Why are logical reads for windowed aggregate functions so high?
  16. How to rename something in SQL Server that has square brackets in the name?
  17. Comma Separated values with SQL Query
  18. how to separate string into different columns?
  19. Using IF ELSE statement based on Count to execute different Insert statements
  20. SQL Server SELECT INTO @variable?
  21. How do I change db schema to dbo
  22. How to subtract 30 days from the current date using SQL Server
  23. How do I find the data directory for a SQL Server instance?
  24. Count records for every month in a year
  25. Safest way to get last record ID from a table
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment