My Log files occupied 20 GB. I could not shrink that file. so I detached the database and attached again.
It was just few days back. size of the log file become just 570 kb. Now it reaches 5,000,000 kb again.
How can I limit the growing?
you can restrict it graphically using SSMS or Enterprise Manager.
Right-click on the database name and select Properties.
Note, however, if you limit the size and it fills up, ALL modification
When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database.
Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Learn how to create flexible layouts using relative units in CSS. New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).