Category: MS SQL Server DBA

SQL-Transact Backup all Databases In a MS SQL Server

January 25, 2016

The Problem My client wants to backup all the databases in their MS SQL Server Server – 1,000 large databases – to a shared network drive. I want to run a script, get coffee and come back to check when the backup is completed. Solution Created a script to backup all the databases on the … More SQL-Transact Backup all Databases In a MS SQL Server

Transfer database permissions on all objects from one SQL server to another – MS SQL Server 2008 – 2014

September 10, 2015

The Problem I needed to migrate all databases from a MS SQL server 2008 R2 to MS SQL Server 2014; while I can create and restore my databases, permission in objects live on the system databases, therefore I needed to transfer all my login and data objects from one server to another. This cannot be … More Transfer database permissions on all objects from one SQL server to another – MS SQL Server 2008 – 2014