This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.
2016-03-15 (first published: 2016-02-25)
1,131 reads
The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.
2016-02-16 (first published: 2016-02-02)
394 reads
This script will script the role members for all roles on the database.
2015-03-10 (first published: 2015-02-16)
1,293 reads
Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.
2017-01-13 (first published: 2015-01-06)
13,502 reads
if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command
2016-11-10 (first published: 2014-12-17)
2,491 reads
This is a script to restore all databases from backups places in a folder.
2014-08-15 (first published: 2014-07-16)
1,530 reads