Tag Archives: Administration

How to control windows services from SQL Server?

How to control windows services from SQL Server? For a SQL Server DBA there are scenarios where he/she needs to deal with Windows services from SQL Server when there is no direct access to Windows server and only have access … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , | Leave a comment

Automate database restore procedure SQL Server

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 , , , , , , , , , , , , , , , | 1 Comment

SQL Server database mirroring with screenshots

   SQL Server Database Mirroring With Screenshots   Introduction: This post takes you through SQL Server Database Mirroring with screenshots in both the ways using T-SQL script and management studio. Also you will learn components involved in SQL Server database … Continue reading

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , , , | 14 Comments