SP_Configure - Help!

  • Please Help!

    My instance will not restart after I stopped it. I issued the command below inorder to enable backup of my databases to a mapped drive. Now it will not restart. Any help will be appreciated.

    EXEC sp_configure 'show advanced options', 1

    GO

    -- To update the currently configured value for advanced options.

    RECONFIGURE

    GO

    -- To enable the feature.

    EXEC sp_configure 'xp_cmdshell', 1

    GO

    -- To update the currently configured value for this feature.

    RECONFIGURE

    GO

  • How do I reset the value of sp_configure back to what it was now that my instance will not start...Any help will be appreciated.

  • This shouldn't prevent your instance from starting. What errors are you getting and what's in the errorlog?


    And then again, I might be wrong ...
    David Webb

  • smatu (3/9/2015)


    Please Help!

    My instance will not restart after I stopped it. I issued the command below inorder to enable backup of my databases to a mapped drive. Now it will not restart. Any help will be appreciated.

    EXEC sp_configure 'show advanced options', 1

    GO

    -- To update the currently configured value for advanced options.

    RECONFIGURE

    GO

    -- To enable the feature.

    EXEC sp_configure 'xp_cmdshell', 1

    GO

    -- To update the currently configured value for this feature.

    RECONFIGURE

    GO

    What else did you "configure" because, as David said above, that will not prevent a server from starting. Did you actually map any drives?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • What I wanted to do was backup all of the databases in my instance to a mapped drive without any interaction from end-users. I had to do a backup before maintenance operation on the SAN of the server which hosts all of the data and log files of my databases.

    So, the plan was:

    1. Issue SP_Configure Script to enable me map a drive for my backup(backing up to virtual drive due to insufficient space on the local server).

    2. Set my instance to single_user mode; perform my backup

    3. Shut down the instance

    After executing the steps above, my instance would not restart...

  • Were you able to take your backup and if so, is it possible that there is now insufficient space on the drive for SQL Server to even start?

    Regards

    Lempster

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply