Here’s a quick script which will show you restores that have taken place within the last day. Advertisements
If you ever wanted a simple way to get the last several days history using a DateTime column you can simply create a couple of DateTime Variables, and supply them with todays […]
Here’s a script which will help you extract information from the default trace. This should server as a quick audit query, and not a long term audit solution. You can modify the […]
You can see when the database was last restored, and who performed the restore ( or under what account the restore operation was run ). Just run this simple script. The results […]
Find the status of all your databases with this little script. This will show you the Recovery Model, State, and if the Databases is in Read Only mode. use master; set nocount […]
Search through all the Data files to find a specific data file path. Here’s a quick script to search through ALL the database files, and paths to find a specific file.
This script will Set all Offline Databases Online, and do a backup after the switch to online. I’ve also taken the liberty of adding some extra logic to use a network backup […]
Here is a quick script to configure ALL your databases to Simple Recovery not just your User Databases, but System Databases too. use master; set nocount on declare @change_all_databases_to_simple_recovery varchar(max) set @change_all_databases_to_simple_recovery […]
This simple script will show you when databases were restored. It helps you find the restore history of any or all databases.
You can use this quick little script to find when a Backup or Restore completes. It will estimate how many hours, or minutes you have left.
Just go to management Studio and type in the following statement: This will return a list of ALL databases organized in ascending order.
Here’s a quick script that will backup all databases to a shared location on the network. The database backup files will be titled like this: MyDatabaseName.bak There is some extra logic to […]
It seems since the acquisition of LiteSpeed again and again has somewhat fragmented the amount of available information, so I’ll post up what I have in my notes about the LiteSpeed Parameters. […]
Here’s a quick script you can use to check all Jobs to see whats enabled, or disabled. use msdb; set nocount on select name , ‘Job State’ = case enabled when ‘1’ […]