This logic will automatically restore a database with a new name. All you need to do is provide the database name you want and the path for the database backup file. There’s […]
You probably have a network storage location with all your Database Backup files in it. One day you’ll need to place those databases ( or restore the databases ) on a new […]
Here’s a quick script you can run to remove old backups. All you need to do is place it into a Job. Question: What does this script do? Answer: 1. This will […]
If you’ve ever seen a full folder path, and file name in the MSDB system tables; one of the first things you need to do is get just the path, or just […]
Here’s a quick script you can use to see exactly when ( or estimated time according to sql server ) that a backup, or restore operation will complete. This will give you […]
Here’s a quick way to search for a certain column name across all your tables in any database.
You can use this script to get ALL the database sizes combined in MB, GB, and TB. Here’s a quick screenshot:
Use this script to get the database size of ALL databases.
Find databases that were restored since the first morning.
Here’s a script I threw together to find what process is taking up space in the TempDB, and where the process came from.
Here’s a quick way to change all the Job owners in SQL Server Agent. Lets say you want to set all the owners to the SQL Server Agent Account called MyDomain\SQL_AGT. You […]
Here’s a simple ( and probably the most common ) way to search across all your tables, and columns within those tables; if you are looking for a particular name either on […]
Here’s a quick script to give you an immediate view of who is running what. It will return a number of things that you might find helpful. Those include the following: 1. […]
Here’s a quick script you can use to automatically add a user across all databases with Read Only ( Data Reader ) rights. Additionally; this script will remove the user ( if […]