Tag Archives: Automation

Automate database restore procedure SQL Server

Posted on October 22, 2012 by uday arumilli

Automate database restore procedure SQL Server Make sure that the stored procedure “[dbo].[DB_Restore]” is available at Target Instance master database.  Connect to target server instance and open a new query window from SSMS Why Database Restore Automation? It reduce the … Continue reading →

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 4 Comments

Automating SQL Server instance and Database Inventory preparation

Posted on January 4, 2011 by uday arumilli

Automating SQL Server instance and Database Inventory preparation In our environment we have a requirement for Automating SQL Server instance and Database Inventory preparation. We tried different methods and came-up with the T-SQL scripts that helped us in creating the environment … Continue reading →

Posted in SQL Server DBA | Tagged , , , , | 2 Comments