Home » Posts tagged 'SQL server 2008' (Page 2)
Tag Archives: SQL server 2008
Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ? 1) Open SQL Server Installation Center > Click Installation from Left > Click Add node to a SQL Server Failover Cluster from right 2) Click Run to start setup 3) Click Ok to cont., In case of any … Continue reading
Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :- 1) Open SQL Server Installation Center > Go to Installation from Left > Click on New SQL Server Failover installation from right 2) Click RUN to start setup 3) Click ok after validation check. In case of any failure, you need to … Continue reading
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly. Anti-virus are very useful programs from security, audit & venerability detection & removal point of view. But if team managing anti-virus server did not configure anti-virus policies properly then your SQL Server is going to face the problem. Here, we … Continue reading
ERROR || The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.
Table with clustered index is totally depended on index accessibility. ERROR : The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled. REASON : We find that some disable the cluster index due to which issue occur. Clustered index physically sort & save data in … Continue reading
Question : Can we do system configuration check with starting SQL Server installation? One of my friend need to submit it to get installation approval. This is to ensure that no configuration issue occur at time of installation. Answer : Yes, We can do it. Step 1: Run Setup.exe Step 2 : Go to Tool … Continue reading