Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [dbachecks]

dbachecks is a Windows PowerShell module created as a framework by and for SQL Server pros who need to validate their environments.

dbachecks is supported by the SQL Collaborative Community, issues can be raised at

https://github.com/sqlcollaborative/dbachecks/issues

dbachecks is designed to provide configurable validation for SQL Server instances.

Check - A test for a single configuration item Config - A value that can be set for the outcome of a check Group - A grouping of checks that fall in the same area Type - the type of check - this can be Windows, SQL or Cluster

There are further details at

https://github.com/sqlcollaborative/dbachecks

including links to blog posts

There is some cross-over with the dbatools project, questions should be about the implementation of dbachecks, incorporating it into daily work, automating it and unusual results

5 questions
1
vote
0 answers

Unable to execute dbachecks command

i installed dbachecks module in a server. but when i am trying to execute get-dbccheck, it is throwing the below error Populating RepositorySourceLocation property for module Pester. VERBOSE: Loading module from path 'C:\Program…
Saravana Kumar
  • 13
  • 4
1
vote
1 answer

How to monitor Mongo databases and Cloud servers?

We have mongo databases installed in AWS and Azure based servers. We need to monitor the Mongo databases and Cloud servers on daily basis. Is there any way to healthcheck the databases and servers ? Thanks,
Mr Surya
  • 11
  • 1
1
vote
2 answers

dbatools, DbcCheck LastBackup

Last week I started testing dbccheck on my test system. I found one strange thing, and I have no idea what is the problem, last fullbackup is few hours old, but dbccheck print an error. Following you can see my steps: installation dba checks based…
KW_1970
  • 11
  • 1
0
votes
3 answers

How to perform bulk delete and release free space?

Good Afternoon, We have a database that wasn't been an archive anytime. The database has grown tremendously and we are running short of space. Hence there is a need to do a bulk delete and free space. Based on my research, in order to free up space,…
rushabh138
  • 3
  • 3
0
votes
1 answer

Encrypt connection when using sqlcmd

Trying to connect database with an encrypted connection, tried below sql queries: sqlcmd -N -E -S tcp:SQLSERVER,1234 -U username -P password -d Database -Q "INSERT INTO table1 VALUES(1,2,2) ERROR: Sqlcmd: The -E and the -U/-P options are mutually…
chris
  • 3
  • 2