iLearnSQL

MCSA 2012, MCDBA, MCITP, MCP, MCTS(SQL Server 2005), MCTS (Database Development, 2008), ITIL v3
  • Tagline: Data knows everything ...

Technical Article

Monitor basic Database parameters like Recovery Model, Page Verify, Auto Close, Auto Shrink, DB Owner, Auto Create Statistics Enabled, DB Create Date etc with PowerShell command.

I have created this script for one of our client, the requirement was all the databases should be in full recovery model and should be monitored. Also, I added other important parameters like AutoShrink, AutoClose etc. Output:

5 (1)

2020-06-16

757 reads

Blogs

Goal Progress for June 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

Using Sessionize for Your User Group – Part 2

By

Now that your CFS has been setup it’s time to get the word out...

Daily Coping 1 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Identify Process

By jsshivalik

Hi Is it possible thru query or other means which sql process are running...

Invalid column name when fetching large amounts of data

By Tibor_Sebok

Hi Guys, I am developing an SSIS package right now where I have to...

Christmas in July

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Christmas in July

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers