SQL Server live DB files are too big

Within the MSSQL files, MDF and LDF can be found and used.

Both LDF and MDF are files extensions used in the Microsoft SQL Server.

The extension file .MDF stands for “Master Database File.” This file contains all the startup information for the database to run and tracks all the databases on the SQL server. It also points to the other files in the database. This file is also a key file in storing information that is very important in admittance and supervision of data content on the server.

Meanwhile, LDF is the file extension for the server transaction log for the main data file. It saves the database information in addition to keeping a record of all the actions and changes made on the information on the server. This includes; date, time, details of all changes, user information regarding who made the changes. In addition, the log also features the computer terminal where the changes were made.

Resolution:

The most common problem is that user sets recovery model to full, and then forgets to do transaction log backups. The solution is simple – switch to the simple recovery model.

PowerShell Day-to-Day Admin Tasks [in a nutshell]

If you are aiming to optimize the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.

This article demonstrates how easily a Windows admin can achieve required Dev Ops skills by using Windows Automation Tasks. The article consists of 3 different areas;

  1. How to create PowerShell Scripts using a GUI tool
  2. Pre defined PowerShell script source [revised by Microsoft]
  3. How to Run the Created PS scripts [Task Scheduler & PS to EXE conversion]

Section 1:

LazyWinAdmin is a project released in 2012, a PowerShell Script that generates a GUI/WinForms loaded with tons of functions. This utility is very helpful for anyone managing workstations or servers.

Sections 2:

Here you will find hundreds of pre defined commands written in PowerShell, VB Script, Perl & Python. Only Minor Tweaks will be required, therefore you can use the given compiler to cross check the validity of the commandlets.

https://gallery.technet.microsoft.com/

Continue reading “PowerShell Day-to-Day Admin Tasks [in a nutshell]”