camoIT
asked on
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
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
ASKER
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.
If I go into Add Remove I see MS SQL 2000
Ok thats what I have found.
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
Open the query analyzer and run this command
backup log [database name] with truncate_only
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
right:)
Please select my comment as the solution to you problem.
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.