Results 1 to 2 of 2

Thread: Start / Stop SQL Server From Command Prompt or Run

  1. #1
    Join Date
    Feb 2008
    Location
    Islamabad, UK
    Posts
    88,507
    Mentioned
    1031 Post(s)
    Tagged
    9706 Thread(s)
    Thanked
    603
    Rep Power
    21474934

    exclaim Start / Stop SQL Server From Command Prompt or Run

    i - Start / Stop SQL Server From Command Prompt or Run

    Trouble:

    Microsoft SQL server is a a service that helps run database related applications to run. How can we run SQL Server through run prompt or command prompt.

    *


    Let’s see how can we start, stop SQL Server 2005 through run prompts with some simple commands


    Fix:

    SQL Server 2005 is actually a service running behind, so you can start and stop the instance of SQL Server by starting or stopping the service.

    *

    1. Open Start Menu >> Run,

    *

    2. Run the following command to run or stop the SQL Server

    *

    2.1 To Start SQL Server 2005 – run the following command at run prompt***
    net start mssqlservaer
    *

    2.2 To Stop SQL Server 2005 – run the following command at run prompt***
    net stop mssqlserver
    *

    3. That’s it

    *

    Note: You can also run these commands through command prompt or store both of these commands in batch file in sequence of stop and start command to restart running SQL Server.


  2. #2
    Join Date
    Feb 2008
    Location
    Karachi, Pakistan, Pakistan
    Posts
    125,914
    Mentioned
    839 Post(s)
    Tagged
    9270 Thread(s)
    Thanked
    1180
    Rep Power
    21474971

    Default Re: Start / Stop SQL Server From Command Prompt or

    v nice shairng
    صرف آواز نہیں ، لفظ بھی مقفل ہیں مرے

    سوچ میں ہوں کہ اب تجھ کو پکاروں کیسے

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •