We are currently running our Database Server on a RTM version:
Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor)
We learnt that we need to install the latest Service Pack for SQL Server 2012, which is SP3
I had the following doubts based on this subject:
Will installation of SQL Server 2012 Web Edition SP3 affect any of our production databases?
Do we need to restore the databases, after installation of SP3?
Are there any particular prerequisites we need to follow before the installation of SP3?
Do we need to perform a database backup and backup of the data files before the installation of SP3?
Please advise. Appreciate your help on this. Thanks.