When SQL Server Service stopped working due to insufficient disk space, one of the possible culprit may be the SQL Server Database Log File that has grown to be very large.
Here is some simple SQL Query to shrink the size of the log file:
====
Use mydatabasename;
GO
ALTER DATABASE mydatabasename
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (mydatabasename_Log, 1);
GO
ALTER DATABASE mydatabasename
SET RECOVERY FULL;
GO
====
Waring: The above query will truncate your database log!
I really enjoy reading of your article. I wanted to inform you that you have people like me who appreciate your work. sms bomber apk editor no wifi games
ReplyDeleteHow to write Abortion essay: Pro Tips
ReplyDeleteRacism Essay: How to write on controversial topic
How to write police brutality essay: Few Tips
Selling your products to Costco: Tips For Costco Essay
How To Ensure Parallel Construction In Your Essay
Police Brutality Essay: Important Details
Wholesale Business Analysis: Tips for Costco Essay
Tips To Ensure Parallel Construction In Your Essay
AP Lang Rhetorical Analysis Essay Guide
Learn these easy steps to create a Narrative Essay Outline
AP Lang Rhetorical Analysis Essay Guide
Top 10 Toughest Exams in World 2021
How To Become An Archaeologist In India