Solved

SQL Server 2008 Transaction log is now 25gig

Posted on 2011-03-14
4
255 Views
Last Modified: 2012-08-13
Hi everyone,

How can I delete or reduce the transaction log in SQL server 2008. I don't need the transaction log. I use SQL for my vcenter database and I backup everyday the database.

Thank in advance for your help!
0
Comment
Question by:jonathan_camirand
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
Saqib Khan earned 250 total points
ID: 35131695
USE DATABASE;
GO
SELECT file_id, nameFROM sys.database_files;
GO
DBCC SHRINKFILE (1, TRUNCATEONLY);


or Right Click on Database and choose SHRINK DB Option.
0
 
LVL 32

Expert Comment

by:ewangoya
ID: 35131749


Change your database model to simple instead of truncating your log file
0
 

Author Comment

by:jonathan_camirand
ID: 35131803
How can I do that? I'll shrink my database too
0
 
LVL 32

Assisted Solution

by:ewangoya
ewangoya earned 250 total points
ID: 35131866
You can run the command

ALTER DATABASE YourDatabase
SET RECOVERY SIMPLE;
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

791 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