September 3, 2016 at 12:12 am
Hi
I use sharepoint(2013),for this I have SQLServer(2014) in seprate server.Now I have to" update" SQLServer(2014) in server, I want to know that if there is any specific point in updating SQLServer(2014), if there is common problem and.... I want to know them before working with server.
would you please help me?
thanks.
September 3, 2016 at 3:38 am
nazaninahmady_sh (9/3/2016)
HiI use sharepoint(2013),for this I have SQLServer(2014) in seprate server.Now I have to" update" SQLServer(2014) in server, I want to know that if there is any specific point in updating SQLServer(2014), if there is common problem and.... I want to know them before working with server.
would you please help me?
thanks.
Quick question, are you applying updates to the SQL Server 2014 instance?
😎
September 3, 2016 at 3:54 am
thank you for your notification..
yes, I am using sql server 2014 instance
September 3, 2016 at 7:52 am
AFIIK there are no known problems when updating SQL Server 2014 (i.e. SP 2) but it is always better to be safe and do a full backup both on OS and DB level before the upgrade. Do you have a maintenance window where you can take the SharePoint offline?
😎
September 3, 2016 at 11:30 pm
Thank you for your notification I have three questions :
1- What do you mean by full backup in OS level?
2-Should I have maintenance window for using sharepoint in offline mode?
3- Detail Steps for updating.. for example :should I stop any service at first? then.. full backup
again thanks
September 4, 2016 at 5:01 am
Thank you for your notification I have three questions :
1- What do you mean by full backup in OS level?
That is a full backup of the operating system and software on the machine which allows for reverting any changes made during the update. This step is the ultimate safety net for recovery if anything goes wrong. It is optional as one can use the "Programs and Features" to revert the update.
2-Should I have maintenance window for using sharepoint in offline mode?
Preferrably you want to make certain that no traffic hits the SQL Server during the update. The best way of doing that is to take the SharePoint offline whilst updating.
3- Detail Steps for updating.. for example :should I stop any service at first? then.. full backup
Update process suggestion:
01. Take the SharePoint offline.
02. Stop all SQL Server Services on the SQL Server instance.
03. Run a full OS backup on the SQL Server including the Programs / SQL Server folders and the system databases (master, msdb, model, tempdb)
04. Update the operating system if necessary (patches/service packs etc.), a restart may be required.
05. Start the SQL Server Services and run a full SQL Backup of all user databases.
06. Run the SQL Server update executable, a restart may be required.
07. Bring the SharePoint back online.
08. Run all necessary tests to assert full functionality.
09. Done!
😎
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply