List Database Properties
Allows specification of a database whose properties are to be listed. Allows showing properties by category (Null, false, or true).
2004-11-08 (first published: 2004-08-07)
921 reads
Backup and restore
Restore Backup and all TRANLOGS in a specific DIR
Many DBA's have a Maintenance plan running that creates a backup every night and a transaction log backup every hour.Restoring them to another server (for whatever reason) can be a tedious job. That is why I wrote this T-SQL script.It will read the contents of a backup directory created by the maintenance plan and create […]
2004-06-25
912 reads
Backup all Databases Using SQL LiteSpeed
This script backs up all databases or a specified database to a disk location. Databases can be explicitly excluded from backup as well. Can be used for Full, Differential or Transaction Log Backups. Can also dynamically create sub directories for each database, as well as perform DBCC and restore verify operations. Includes LiteSpeed support for […]
2004-04-15
1,488 reads
Backup All Databases
This script will back up all databases (other than those listed to not be included) to a given disk location. It can also be modified to back up transaction logs, or to use a dump device instead of a disk location.
2004-04-02
1,073 reads
Custom Log Shipping
There are mainly two components. One job that is managing the full database backup - restore and a second job that manage the transaction log backup - restore. At this two a new one similar with the full database backup - restore can be added for the differential backups if is the case. I will […]
2005-02-15 (first published: 2004-04-01)
1,036 reads
List SQL backups
During the process of developing a script to make copies of local SQL database and transaction log backups, I needed to come up with an easy way of locating the backup files. This script queries the SQL2000 backup tables in the msdb database and returns backup start dates, types (D=database, L=Log, I=Differential) and the location […]
2004-02-25
611 reads
MSP_Restore
Simple Procedure to rapidly rebuild a copy of Development TEST1 DB...Lovely and fast when Tard Developers have highlevels of access and you just need them out to restore / refresh a db...KILL KILL KILL !!! Remember to reset / resolve users and permissions after this is run. I use a DTS RUN statment with a […]
2003-12-18
176 reads
Restore all Databases in a Directory
Not my script but a guy a work with (Bruce Canaday). This will restore all databases in a given directory. It will also create the data and log directories if they don't exist. A DR Drill dream :).
2003-11-05
2,994 reads
Transfer or Restore Logins to New Server
Not my script, but this script will transfer the logins to a new server or help you restore the in a DR situation with their correct passwords (encrypted).
2003-11-03
1,151 reads
Kick all users out of a DB
This script to designed to kill all connections for all users to a specified database. This is used in conjunction with an automated QA/Dev database restore/refresh process run as a DTS job.
2003-08-21
730 reads
Blogs
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
Forums
Cannot execute SQL cursor in Azure Query Editor (Preview)
Apologies if this is posted in the wrong forum, but I am trying to...
SQl Server 2014 linked server remote server
Hello all, I have a linked server created on an instance which only has...
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers