{"repo":"pelsql/YourSqlDba","free":true,"listed":false,"github":"https://github.com/pelsql/YourSqlDba","clone":"git clone https://github.com/pelsql/YourSqlDba.git","description":"Sources for YourSqlDba : Database maintenance solution that installs as a single SQL script","language":"TSQL","stars":17,"topics":["database-maintenance","sql-agent","database-mail","stored-procedures","t-sql","backup","database"],"license":"LGPL-2.1","category":"databases-storage","readme_excerpt":"YourSqlDba Contact info: Maurice Pelchat Pour la version française, consultez LISMOI.md. YourSqlDba is an open-source maintenance and automation tool for Microsoft SQL Server, developed by Maurice Pelchat. Written entirely in T-SQL, it is distributed as a single script that installs a dedicated database for backups, integrity checks, index and statistics maintenance, cleanup, diagnostics, reporting, and controlled delegation of selected database operations to non- sysadmin users. Canonical overview: What is YourSqlDba? Who YourSqlDba is for: Introduction Everything about YourSqlDba is documented in the GitHub Pages documentation . To display the currently installed version of YourSqlDba, execute: Latest release install script For previous versions and details about changes between releases, see the version history and release notes. [!WARNING] Breaking change — Starting with version 7.1.0.12 — delegated database management: Existing non-sysadmin backup, restore, duplication, backup cleanup, or maintenance-mode workflows may stop working after this upgrade. Each delegated login and its authorized databases must now be configured in Maint.DelegatedDbManagement , and restore targets must follow the new naming restrictions. Review the delegated database management documentation before upgrading any instance that uses delegated operations. YourSqlDba operates through SQL Server Agent jobs and Database Mail, both of which must be configured. After downloading and running the YourSq","default_branch":null,"files":null,"tree":[],"storefront":"/r/pelsql","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pelsql/YourSqlDba/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}