Tuesday, March 10, 2015

starting the sql server using command prompt


how to start the sql server using command prompt

=============
We can start the SQL Server in command prompt also.   Go to Run--> type below command..

If default instance
-------------------
net start mssqlserver
net stop  mssqlserver

With  named Instance
-------------------
net start mssql$instancename
net stop  mssql$instance.

No comments:

Post a Comment

COMMON SQL SERVER BACKUP FAILURE ERRORS AND ISSUES

  One of the most common task for a DBA’s are to perform installation of new SQL Server versions and installing patches. Most often or not e...