Skip to content
Monday, January 25, 2021

Ramblings of a Crafty DBA

  • Home
  • About John

Tag: Tim Ford

Monitoring Database File Size

December 20, 2012October 11, 2017 admin

A Microsoft SQL Server database is composed of at least two operating system files: a primary data file (*.mdf) and a transaction log file (*.ldf). There might even be several secondary data files (*.ndf) if you have a Crafty database administrator (DBA) on staff. Today, we are going to talk about how these files grow and how they can be monitored. The strength of Microsoft SQL Server is the ease in which an accidental DBA can setup a database system in mere minutes. This same feature can be it’s downfall…

Database AdminCATCH • sysfiles • Error handling • free code • HTML Email • John F. Miner III • sp_send_dbmail • Table Variable • Log File • Database File • TRY • TSQL • Autogrowth • sp_MSForEachDB, Greg Larson, Tim FordLeave a comment

Search Site

Categories

  • Database Admin (43)
  • Database Developer (81)
  • Integration Services (5)
  • Other (15)
  • Perl Scripting (7)
  • Power BI (4)
  • PowerShell (2)
  • Presentations (66)
  • SQL Tidbits (101)
  • VB Script (10)

Archives

Calendar

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Jun    

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Crafty Dba © 2016

Proudly powered by WordPress | Theme: AcmeBlog by Acme Themes