?
Solved

SQL Server 2008 Transaction log is now 25gig

Posted on 2011-03-14
4
Medium Priority
?
269 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 1000 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:Ephraim Wangoya
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:Ephraim Wangoya
Ephraim Wangoya earned 1000 total points
ID: 35131866
You can run the command

ALTER DATABASE YourDatabase
SET RECOVERY SIMPLE;
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

807 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