Empty Space
  • Home
  • Resume
  • Posts
  • Personal
  • Code
Subscribe
code

Force clean database log files MS SQL

  • Robin Michael

Robin Michael

Apr 5, 2017 • 1 min read

The interactive tools are not working, but this script will clear a stubborn log file that won't release.

Link here

http://stackoverflow.com/questions/56628/how-do-you-clear-the-sql-server-transaction-log

Assumption: You are in simple mode

USE TheDatabase;
GO

CHECKPOINT;
GO

CHECKPOINT; -- run twice to ensure file wrap-around
GO

DBCC SHRINKFILE(TheDatabase_Logical_Name, 5); -- unit is set in MBs
GO;

Sign up for more like this.

Enter your email
Subscribe

Upgrading Ghost 3.X - 4.X

Upgrading to the latest version of 3.X was no problem, but then moving from 3.X to 4 everything blew up because of database schema changes with messages like this A GhostError occurred. Message: Ghost was able to start, but errored during boot with: alter table `members_status_events`

  • Robin Michael
Robin Michael Mar 24, 2021 • 3 min read

Proposal: Open Source Initiative

Open Source, it forms the basis of most personal and commercial software with no sign of a decrease in adoption or change in it's practical use.  At <Company> there is no project or solution that I have heard of or examined that does not use or build from

  • Robin Michael
Robin Michael Feb 24, 2021 • 6 min read

Covid 19 + Post Office

The distribution of the Covid 19 vaccine has and will continue to be a disaster in the USA because structural having public institutions run by the government would demonstrate that profit and business are terrible at handling crisis situations. What should be happening Vaccines should be distributed by and adminstered

  • Robin Michael
Robin Michael Jan 28, 2021 • 1 min read
Empty Space © 2021
Powered by Ghost