How to shrink SQL database to increase disk space

 USE DatabaseName
GO
DBCC SHRINKFILE(, 1)
BACKUP LOG WITH TRUNCATE_ONLY
DBCC SHRINKFILE(, 1)
GO

In Case of SharePoint server .this problem often observed .to resolve the same ..following query works well for me


USE SharePoint_Config
GO
DBCC SHRINKFILE(SharePoint_Config_log, 1)
BACKUP LOG SharePoint_Config WITH TRUNCATE_ONLY
DBCC SHRINKFILE(SharePoint_Config_log, 1)
GO

Comments

Post a Comment

Popular posts from this blog

Architecture is about Intent.. My few cents..

Image
https://www.youtube.com/watch?time_continue=5&v=IEQr7gn6Gnc https://www.youtube.com/watch?v=o_TH-Y78tt4 https://www.arch2o.com/famous-architecture-quotes-time/ The Principles of Clean Architecture by Uncle Bob Martin Architecture is about Intent !  Its not about tools , Its not about frameworks , those are details, details should be hidden and not exposed.  It is vital to keep the business logic is kept immune the delivery model. Architects are abs-tractors, we separate details from general things. e..g UI or database is details Good architecture is allowed major decision to be differed. Job of an architecture is not to make decisions but to differed the decisions. Good architecture maximizes the number of decisions NOT made. Architects are responsible for Form and Structure while engineers are concerned with structure and functions. What activities an Architects do Act as a true trusted advisor & value-based professional. The solution ar...
Read more

Walkthrough on creating WCF 4.0 Service and Hosting in IIS 7.5

Image
Walkthrough on creating WCF 4.0 Service and Hosting in IIS 7.5 Objective This article will give step by step walkthrough How to create a basic WCF 4.0 Service? How to host WCF Service in IIS 7.5? Hot to test service in a client. Create WCF Service Create WCF service. Open visual studio select new project and then from WCF tab select WCF Service application to create a new WCF service. Delete the default code created by WCF from  IService1  and  Service1.svc.cs a. So delete the data contract b. Modify the service contract as below. Just make one operation contract to return a string . IService1.cs 01. using   System; 02. using   System.Collections.Generic; 03. using   System.Linq; 04. using   System.Runtime.Serialization; 05. using   System.ServiceModel; 06. using   System.ServiceModel.Web; 07. using   System.Text; 08. namespace   WcfService5 09. { 10. [ServiceContract] 11. public ...
Read more

Definition & Delivery of the software architecture

Image
Definition of the software architecture The architecture definition process seems fairly straightforward. All you have to do is figure out what the requirements are and design a system that satisfies them. But in reality it's not that simple and the software architecture role can vary wildly depending on how engaged you are and how seriously you view your role. As the following diagram shows, the architecture definition part of the role can be broken down further into a number of different elements. Management of non-functional requirements : Software projects often get caught up on asking users what features they want, but rarely ask them what non-functional requirements (or system qualities) they  need . Sometimes the stakeholders will tell us that "the system must be fast", but that's far too subjective. Non-functional requirements need to be specific, measurable, achievable and testable if we are going to satisfy them. Most of the non-functional re...
Read more