September 13, 2012 at 5:31 am
Hi,
I have recently started a new role and the SQL Server needs rebooting over the weekend.
However, it has never been rebooted or restarted in the year since it was installed.
From a SQL perspective what are the worst case scenarios I should be aware of before performing this? What may I have to repair/do to get the SQL server services running again if they do not come up? Anyone had experience of this?
The SQL Server is 2008r2 RTM
Thanks,
George
September 13, 2012 at 5:47 am
Prepare for the worst case, that the server or databases fail to come online, by making fresh backups of all of your databases. This just for starters so that you can sleep at night.
If you do not already have a test server installed, install one with like configuration to your production server and do test restores there just to make sure your backups are going to work.
September 13, 2012 at 6:28 am
You may also want to retrieve all of the current SQL Server configurations. You can do it through the gui, but to quickly get a complete list that you can output to file for later use run sp_configure.
So run it like this by first turning on the advanced options, otherwise you would get minimal output:
sp_configure 'show advanced option', '1';
reconfigure;
sp_configure;
September 13, 2012 at 10:40 am
Also make sure you do have backup of all the databases including system dbs.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply