SQL Server Error

[TanviYeotikar]

Hi,

I am facing a problem in SQL Database server. Whenever any user tries to upload a document/drawing, they are getting an error as transaction log for database is full.

Could you please help me out to rectify the problem? All windchill work has been stopped due to this issue. I have attached an image file of the issue.

Rrgards,

Tanvi.

[TomU · Accepted solution]

The transaction log will continue to grow until it is backed up or until it reaches the limit set for it or all the space on the disk. You need to take a full backup of both the database and the transaction log file on a regular basis. You can view the current size by looking at the folder the log is in. You can view the max allowed size by using SQL Server Management Studio. If you have the disk space, you can probably just increase the size limit for now to get things going again. (You may need to restart SQL Server.)

[TanviYeotikar]

Thanks a lot Tom. It was really very helpful.

[TomU]

Also take a look at these:

PTC

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS41551

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS147735

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS81926

Others

http://msdn.microsoft.com/en-us/library/ms175495.aspx

http://dba.stackexchange.com/questions/29829/why-does-the-transaction-log-keep-growing-or-run-out-of-space

http://stackoverflow.com/questions/56628/how-do-you-clear-the-sql-server-transaction-log