Monthly Archives: March 2016

Simple Methods to Recover master.mdf File Password

Posted on March 15, 2016 by Andrew Jackson

Overview MS SQL Server is the relational database management system used to store information in form of tables, views, indexes, triggers, constraints and stored procedures. Master Database File (MDF) is the main database file with the file extension .mdf used … Continue reading →

Posted in Security, SQL, T-SQL | 1 Comment

Different ways to find Data, log and DB Size

Posted on March 10, 2016 by Prashanth Jayaram

Different ways to get the size of the data , log files and Databases Using Counters Querying sysaltfiles & sys.databases Querying sys.master_files SELECT instance_name AS DatabaseName, [Data File(s) Size (KB)]/1024.00 [DataInMB], [LOG File(s) Size (KB)]/1024.00 [LogInMB], [Data File(s) Size (KB)]/1024.00 … Continue reading →

Posted in SQL, sysfiles | Tagged Counters, sysaltfiles, sysaltfiles & sys.databases Querying sys.master_files | 4 Comments

Get the Total Item Size for an Exchange database

Posted on March 6, 2016 by Ram Iyer

Hey there! This one is for those Exchange admins who think it is a sin to use hands for something that a computer can do—those Exchange admins love their PowerShell console more than the Exchange Management Console. There are some … Continue reading →

Posted in Exchange | Leave a comment

Find failed SQL Job in last 24 Hours using Powershell

Posted on March 2, 2016 by Prashanth Jayaram

This post is based on the request to get failed SQL jobs in last 24 hours and output should be displayed in a HTML format. The verification of SQL job steps code is taken from the below blog. http://www.sqlservercentral.com/blogs/sqlsandwiches/2012/01/29/find-failed-sql-jobs-with-powershell/ The … Continue reading →