Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Log is full		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Click
Starting Member

3 Posts
Posted - 10 July 2001 :  23:51:05  Show Profile
Getting this error. My board designer usually takes care of it, but I cannot find him. We cannot post...only read. Does anyone know how I can fix this? Thanks for any help.

-2147217900|[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'Magna2d' is full. Back up the transaction log for the database to free up some log space.

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 10 July 2001 :  23:57:22  Show Profile
Do you have Enterprise Manager to login to and manage your SQL Database?
Go to Top of Page

Click
Starting Member

3 Posts
Posted - 10 July 2001 :  23:59:58  Show Profile
I don't have a clue. Wish I did. Is this something that would be done on this end or on the host end?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 11 July 2001 :  00:03:43  Show Profile
Enterprise Manager is a tool that you could use on your end. Your host probably uses the same thing.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 11 July 2001 :  00:09:29  Show Profile
Your hosting company should be able to fix this for you. Ask them to truncate the log file for your sql server database, and also ask them to configure the db to truncate log on checkpoint. The 2nd item will prevent this problem in the future by emptying the log file every time they do a backup.


======
Doug G
======
Go to Top of Page

Click
Starting Member

3 Posts
Posted - 11 July 2001 :  00:19:38  Show Profile
Thanks guys. I just sent a message to the host. Hopefully he hasn't gone to bed yet.

Click
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 12 July 2001 :  00:08:20  Show Profile  Visit Gremlin's Homepage
If you have query analyser, then connect to the database and run the following query

DUMP TRANSACTON yourdbname WITH NO_LOG
DBCC SHRINKDATABASE

Hopefully that will get things running again for you.
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 12 July 2001 :  08:35:09  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Will this same script run thru asp?

strSQL = "DUMP TRANSACTON yourdbname WITH NO_LOG DBCC SHRINKDATABASE"
set rs = my_Conn.Execute (strSql)

Brad
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07