What is the cluster node limitation? The number of allowable nodes in the SQL Server cluster depends on your SQL Server version and your Windows Server version. For SQL Server 2008 Standard edition, you can only have two cluster nodes. If you have SQL...
What is the maximum limit of SQL Server instances for a standalone computer? (2008 R2) 50 instances on a stand-alone server for all SQL Server editions. SQL Server supports 25 instances on a failover cluster.
Can we uninstall/rollback a service packs from SQL Server 2005?
Can we uninstall/rollback a service packs from SQL Server 2005? No not possible for SQL Server 2005. To rollback a SP you have to uninstall entire product and reinstall it. For Sql Server 2008 you can uninstall a SP from Add/Remove programs. Some people...
How to recover a database that is in suspect stage? ALTER DATABASE test_db SET EMERGENCY After you execute this statement SQL Server will shutdown the database and restart it without recovering it. This will allow you to view / query database objects,...
Start SQL Server in different modes? Single User Mode (-m) : sqlcmd –m –d master –S PAXT3DEVSQL11 –c –U sa –P ******* DAC (-A): sqlcmd –A –d master –S PAXT3DEVSQL11 –c –U sa –P ******* Emergency: ALTER DATABASE test_db SET EMERGENCY
What is the port numbers used for SQL Server services? The default SQL Server port is 1433 but only if it’s a default install. Named instances get a random port number. The browser service runs on port UDP 1434. Reporting services is a web service – so...
How can we check whether the port number is connecting or not on a Server? TELNET
SQL Server is not responding. What is action plan? Connect using DAC via CMD or SSMS Connect via CMD SQLCMD -A –U myadminlogin –P mypassword -SMyServer –dmaster Once you connect to the master database run the diagnostic quires to find the problem Correct...
What are the Hotfixes and Patches? Hotfixs are software patches that were applied to live i.e. still running systems. A hotfixis a single, cumulative package that includes one or more files that are used to address a problem in a software product (i.e....
