How Do I Shrink/Reduce/ Truncate a log file?

I am having an issue logging in users to GP75 this morning.

They are getting "Save" errors, and when i replicated the same error, it said that the Database log was too big and to clear it up

Can someone help me, Im not sure what version of SQL we are running.. I know that sounds stupid, but I have not seen Sql Enterprise Manager before.

I can provide any screen shots if needed
Who is Participating?
willettmeisterConnect With a Mentor Commented:
replace [database name] with the name of the acutal database.
The database log should be truncated when the server is backed up so you may have a larger issue than you know.  You should if you know it has been committed or backed up first.  

The process is different depending on the version of SQL you are running.  Right click on the server in enterprise manage and go to properties and tell us what version of SQL you are running including SP if applicable.
camoITAuthor Commented:
If I click on Help--> About MS Enterprise Manager Ver 8. SP2
If I go into Add Remove I see MS SQL 2000

Ok thats what I have found.
Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

Make sure you have a good backup of the database.

Open the query analyzer and run this command

backup log [database name] with truncate_only
camoITAuthor Commented:
I opened Start - Prgrams - Query Analyzer
I Logged in with Databases Username and Password.
I chose from the drop down list the database that is giving the issue

Copied and pasted your command.
This is the result

Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'database name'. No entry found with that name. Make sure that the name is entered correctly.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

Please remember that i am kinda new to this SQL server if you cant tell already
camoITAuthor Commented:
Please select my comment as the solution to you problem.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.