As a quick script tip for today I’ll show you a script I use regularly for reporting purposes. It shows you the backup history on your instance for successful backups ordered by the most recent first: — Get the latest successful backups — Shows databasename, backup start & end time, duration, backup file, — backup size, […]

A couple of days ago I had to manually grow the database data file for a client, they do not use autogrowth and plan growth events. They are running on a SQL Server 2008R2. The database data file was 1,9TB before the growth event, since we always increase the data file with 10% the new […]