Browsing category
How to wright a Store Procedure in MS SQL Server Basic Stored Procedure in SQL Server CREATE PROCEDURE GetUserById @UserId INT AS BEGIN SET NOCOUNT ON; SELECT * FROM Users WHERE Id = @UserId; END; To run it: EXEC GetUserById @UserId = 1; Stored Procedure With Multiple Parameters CREATE PROCEDURE InsertUser @Name NVARCHAR(100), […]
SQL SERVER LOG SHIPPING 2017 To install and configuration of Log shipping of SQL Server Database we need to follow below steps. There are some prerequisites for Log shipping. Same version of SQL Server database should be installed on both servers. Static IP should be configured on both servers. Shared folder should be configured on […]
Change the SQL Server Service Account Open the SQL Server configuration manager. We need to change the service account for SQL server services. Right click on SQL server service, select properties, go to log on tab, click on Browse button, click on location select Entire Directory and click on ok, now type the name Administrator […]
Installation of SQL Server on Node 1 1. To install the SQL server mount the ISO of SQL server and double click on it. Below page will open select the Installation and click on New SQL Server stand-alone installation. 2. In this screen enter the product key (if you have purchased then key filled automatic) […]
Prerequisite for SQL Server Always On Setup All Nodes are in Domain Network Static IP should be assigned on all nodes Windows Failover Cluster Roles should be installed on all nodes SQL Server of same version should be installed on all nodes All Ports should be allowed in Windows firewall SQL Server services should be […]
Installation of SQL Server Failover Cluster on Node 1 Step 1: To install the SQL server on mount the ISO of SQL server and double click on it. Below page will open select the Installation and click on New SQL Server fail-over cluster installation. Step 2: In this screen enter the product key (if you […]
Installation of Fail-over Clustering To installation of clustering services, open the server manager, go to manage to add roles and features Click on Add Roles and Features, A screen will open click on next button four times, select Failover Clustering, click on Add features, and then click on next button. Click on install button, and […]
Adding iSCSI Disk on Nodes When we click on iSCSI Initiator it will ask to start the service click on ok button. Once we click on ok button a window will open as shown below, go to tab Discovery, click on Discover Portal, type the IP address of the Storage Server (in our case 192.168.1.15) […]
Prerequisite for SQL Server Fail-over Setup There are some steps for Failover clustering before implementing SQL Server clustering. Creation of Storage Server For storage server node storage server should be ready with Windows Server 2016. And this should be member of the domain server. Follow the below steps to create storage disk for clustering: Open […]
Step 1. To install the SQL server mount the ISO of SQL server and double click on it. Below page will open select the Installation and click on New SQL Server stand-alone installation. Step 2. In this screen enter the product key (if you have purchased then key filled automatic) and click on next button. […]