Solved

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

Posted on 2009-07-08
7
254 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:camoIT
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:willettmeister
ID: 24804819
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.
0
 
LVL 2

Author Comment

by:camoIT
ID: 24804871
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.
0
 
LVL 11

Expert Comment

by:willettmeister
ID: 24805059
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
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 2

Author Comment

by:camoIT
ID: 24805123
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
0
 
LVL 11

Accepted Solution

by:
willettmeister earned 500 total points
ID: 24805161
replace [database name] with the name of the acutal database.
0
 
LVL 2

Author Comment

by:camoIT
ID: 24805195
right:)
0
 
LVL 11

Expert Comment

by:willettmeister
ID: 24817565
Please select my comment as the solution to you problem.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
GPO policy question 4 33
Disabling null sessions on domian controllers 15 28
powershell query 2 22
Cannot view members of new distributionlist 2 28
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now