SP_Configure - Help!

Question

SP_Configure - Help!

EMtwo

Hall of Fame

Points: 3498
More actions
March 9, 2015 at 3:32 pm

#295034

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

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

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

EMtwo Hall of Fame Points: 3498 More actions · Answer 1

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.

David Webb-CDS SSCoach Points: 17398 More actions · Answer 2

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

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

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)

EMtwo Hall of Fame Points: 3498 More actions · Answer 4

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...

Lempster SSCoach Points: 15651 More actions · Answer 5

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