SQL Server Scripts
open-menu closeme
Home
All SQLServer70 Scripts
Scripts & Commands
Links icon
SQL Server Documentation SQL Server Mgmnt Studio
About
Contact Us
Privacy Statement
rss

  • SQL Server Backup History: Duration and Size Report

    calendar Apr 13, 2026 / Apr 12, 2026 · 6 min read · sql server backup recovery msdb sql scripts database administration backup monitoring maintenance scripts reporting sys.databases backupset  ·
    Share on: twitter facebook linkedin copy

    Query Backup Duration and File Size from SQL Server History This script queries SQL Server's msdb backup history to report the backup type, start and finish time, duration in minutes, and file size in both megabytes and gigabytes for every backup across all user databases on the server. Purpose and Overview Knowing …


    Read More

  • SQL Server Backup Status Report: All Databases

    calendar Apr 10, 2026 / Apr 12, 2026 · 7 min read · sql server database administration backup recovery maintenance scripts msdb sql scripts database management backup monitoring full backup differential backup transaction log backup sys.databases  ·
    Share on: twitter facebook linkedin copy

    Check SQL Server Backup Age Across All Databases This script queries the SQL Server backup history catalog to report the most recent full, differential, and transaction log backup for every database, including how many hours and minutes ago each backup completed. Purpose and Overview Database backups are your last line …


    Read More

  • SQL Server Point-in-Time Restore with STOPAT

    calendar Apr 5, 2026 / Apr 12, 2026 · 8 min read · sql server restore backup recovery transaction log msdb database maintenance DBA scripts point in time restore sys.databases  ·
    Share on: twitter facebook linkedin copy

    Recover a SQL Server Database to a Specific Point in Time SQL Server's RESTORE LOG ... WITH STOPAT lets you roll a database back to any exact moment covered by your backup chain. This guide walks through querying backup history in msdb, executing the restore sequence, and verifying the result. Purpose and Overview Data …


    Read More

  • SQL Server Database Size Report for All Databases

    calendar Apr 2, 2026 / Apr 12, 2026 · 6 min read · sql server monitoring sql scripts sys.master_files sys.databases database administration capacity planning storage reporting maintenance scripts  ·
    Share on: twitter facebook linkedin copy

    Report Database Size in MB and GB for All SQL Server Databases This script queries sys.master_files and sys.databases to report the total allocated size in megabytes and gigabytes for every user database on the SQL Server instance, sorted by largest database first. Purpose and Overview Knowing how large each database …


    Read More

  • SQL Server Blocking Detection: Find Blocked Sessions

    calendar Mar 1, 2026 / Apr 12, 2026 · 5 min read · sql server blocking performance dm exec requests dm exec sessions wait types dba scripts monitoring query tuning sys.databases sys.dm_exec_requests sys.dm_exec_sessions sys.dm_exec_sql_text sys.dm_tran_locks  ·
    Share on: twitter facebook linkedin copy

    Blocking in SQL Server occurs when one session holds a lock that another session needs, causing the second session to wait. This T-SQL script queries the dynamic management views to show all currently blocked sessions, the blocking session, wait type, wait duration, and the SQL text involved. Purpose and Overview When …


    Read More

  • Generate DBCC SHOWCONTIG Commands for All SQL Server Tables

    calendar Aug 1, 2025 / Apr 12, 2026 · 4 min read · sysobjects sql server database maintenance fragmentation dbcc commands performance administration scripts optimization DBCC sys.tables sys.columns sys.databases sys.dm_db_index_physical_stats sys.objects syscolumns sysdatabases  ·
    Share on: twitter facebook linkedin copy

    Generate DBCC SHOWCONTIG Commands for All User Tables in SQL Server Database administrators frequently need to monitor table and index fragmentation to maintain optimal database performance. This SQL Server script provides an efficient way to generate DBCC SHOWCONTIG commands for all user tables in your database …


    Read More

SQLServer70.com

Your Source for SQL Server Scripts
Read More

Recent Posts

  • SQL Server Backup History: Duration and Size Report
  • SQL Server Long-Running Queries: Find Active Sessions
  • SQL Server Agent Job Failure History Report
  • SQL Server Kill Sessions: Filtered SPID Management
  • SQL Server Backup Status Report: All Databases
  • SQL Server User Permissions and Role Memberships
  • SQL Server Search Stored Procedure and View Text
  • SQL Server Error Log Search Script: xp_readerrorlog

Categories

SCRIPTS 28 SQL SERVER ADMINISTRATION 6 SQL SERVER MONITORING 5 SQL SERVER PERFORMANCE 5 SQL SERVER BACKUP RECOVERY 4 SQL SERVER MAINTENANCE 4 SQL SERVER SECURITY 2 SQL SERVER STRUCTURE 2

Series

ADMIN-GUIDE 28

Tags

SQL SERVER 27 DATABASE ADMINISTRATION 21 SQL SCRIPTS 17 MAINTENANCE SCRIPTS 11 SYSOBJECTS 10 PERFORMANCE 8 SYS.TABLES 7 DATABASE MAINTENANCE 6 DBA SCRIPTS 6 SYS.DATABASES 6 MONITORING 5 MSDB 5 PERFORMANCE TUNING 5 DBCC COMMANDS 4
All Tags
ACTIVE SESSIONS2 ADMINISTRATION2 AUTOMATION2 BACKUP1 BACKUP MONITORING2 BACKUP RECOVERY3 BACKUP VALIDATION1 BACKUPSET1 BLOCKING2 BOTTLENECK ANALYSIS1 CAPACITY PLANNING1 CLUSTERED INDEXES1 CURSOR PROGRAMMING1 DATABASE1 DATABASE ADMINISTRATION21 DATABASE CONNECTIONS1 DATABASE MAINTENANCE6 DATABASE MANAGEMENT3 DATABASE MONITORING2 DATABASE OBJECTS1 DATABASE OPTIMIZATION1 DATABASE SCRIPTS1 DATABASE SECURITY1 DBA SCRIPTS6 DBA TOOLS1 DBCC1 DBCC CHECKIDENT1 DBCC COMMANDS4 DBCC DBREINDEX2 DIAGNOSTICS1 DIFFERENTIAL BACKUP1 DM DB MISSING INDEX DETAILS1 DM DB MISSING INDEX GROUP STATS1 DM EXEC REQUESTS1 DM EXEC SESSIONS2 DM OS WAIT STATS1 DYNAMIC SQL2 ERROR LOG1 EXECUTION PLAN1 FRAGMENTATION2 FULL BACKUP1 GRANT STATEMENTS1 IDENTITY COLUMNS1 INDEX MAINTENANCE2 INDEX OPTIMIZATION1 INDEX REBUILDING1 INDEX TUNING1 INDEXES2 INDEXING1 INFORMATION_SCHEMA.TABLE_CONSTRAINTS1 INFORMATION_SCHEMA.TABLES1 JOB MONITORING1 KILL SPID1 MAINTENANCE SCRIPTS11 MISSING INDEXES1 MONITORING5 MSDB5 MSDB.DBO.BACKUPMEDIAFAMILY1 MSDB.DBO.BACKUPSET1 NONCLUSTERED INDEXES1 OBJECT SEARCH1 OPEN TRANSACTIONS1 OPTIMIZATION2 PERFORMANCE8 PERFORMANCE TUNING5 PERMISSIONS2 POINT IN TIME RESTORE1 PRIMARY KEYS1 QUERY OPTIMIZATION1 QUERY TUNING3 REBUILD REORGANIZE1 RECOVERY1 REPORTING3 RESTORE1 RESTORE VERIFYONLY1 ROLE MEMBERSHIPS1 SCHEMA MANAGEMENT1 SCRIPTS3 SECURITY2 SECURITY AUDIT1 SESSION MANAGEMENT1 SP_PKEYS1 SP_READERRORLOG1 SP_SPACEUSED1 SPACE MANAGEMENT1 SQL1 SQL SCRIPTS17 SQL SERVER27 SQL SERVER AGENT1 STATISTICS1 STORAGE1 STORED PROCEDURES1 SYS.ALLOCATION_UNITS1 SYS.COLUMNS1 SYS.DATABASE_PERMISSIONS1 SYS.DATABASE_PRINCIPALS1 SYS.DATABASE_ROLE_MEMBERS1 SYS.DATABASES6 SYS.DM_DB_INDEX_PHYSICAL_STATS2 SYS.DM_DB_INDEX_USAGE_STATS2 SYS.DM_DB_MISSING_INDEX_DETAILS1 SYS.DM_DB_MISSING_INDEX_GROUP_STATS1 SYS.DM_DB_MISSING_INDEX_GROUPS1 SYS.DM_EXEC_QUERY_PLAN1 SYS.DM_EXEC_QUERY_STATS1 SYS.DM_EXEC_REQUESTS2 SYS.DM_EXEC_SESSIONS2 SYS.DM_EXEC_SQL_TEXT3 SYS.DM_OS_WAIT_STATS1 SYS.DM_OS_WAITING_TASKS1 SYS.DM_TRAN_ACTIVE_TRANSACTIONS1 SYS.DM_TRAN_LOCKS1 SYS.INDEX_COLUMNS1 SYS.INDEXES2 SYS.KEY_CONSTRAINTS1 SYS.MASTER_FILES1 SYS.OBJECTS4 SYS.PARTITIONS1 SYS.SP_ENUMERRORLOGS1 SYS.SQL_MODULES1 SYS.TABLES7 SYSCOLUMNS1 SYSDATABASES1 SYSINDEXES2 SYSJOBHISTORY1 SYSJOBS1 SYSOBJECTS10 SYSTEM TABLES3 T-SQL2 TABLE ANALYSIS1 TABLE STATISTICS1 TRANSACTION LOG1 TRANSACTION LOG BACKUP1 UPDATE STATISTICS1 VIEWS1 WAIT STATISTICS1 WAIT TYPES3 XP_READERRORLOG1
[A~Z][0~9]
SQLServer70.com

Copyright  SQLSERVER70.COM. All Rights Reserved

to-top