SQL Server 2008 Transaction log is now 25gig

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!
jonathan_camirandAsked:
Who is Participating?
 
Saqib KhanConnect With a Mentor Senior DeveloperCommented:
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
 
Ephraim WangoyaCommented:


Change your database model to simple instead of truncating your log file
0
 
jonathan_camirandAuthor Commented:
How can I do that? I'll shrink my database too
0
 
Ephraim WangoyaConnect With a Mentor Commented:
You can run the command

ALTER DATABASE YourDatabase
SET RECOVERY SIMPLE;
0
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.