Tag Info

New answers tagged

1

This is possible and we successfully completed an upgrade of a single failover cluster instance to SQL 2012 on a cluster with multiple SQL 2008 failover cluster instances. Perform the upgrade of the instance on the two nodes not hosting the instance first (be sure to select the correct instance when asked as in the screenshot), then finally perform the ...


2

I would like to post this as answer what is point in upgrading to SQL server 2000 which is outdated completely without any support. Even it is not good for testing purpose. Its like using typewriter in era or super computers. Dont uninstall personal edition first. Install enterprise move databses by backup restore method. If you restore master msdb ...


-1

did you have a look in BOL (Books online) ? ...


0

Provisioning the SQL Server Agent service account is simply referring to "configuring it". Which you stated you changed the service account from Network Services to Local System, that is provisioning the service to run as "Local System". It is just terminology used in their documentation. Regarding the issue at hand, you need to review the system log within ...


0

Let me answer your question point wise 1.SQL Server express has SQL server agent code built in but disabled. When you go to sp_configure you can see Agent XP enable/disable option this is so because if any point of time you are planning to upgrade SQL Server Express Microsoft upgrade process does not have to do much change but just a minimum to enable SQL ...


2

3<4, I opt for option 2 approach. This is also what Oracle instructs us to do in for example this document: http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12394 After you have installed the software for Oracle Database 11g Release 2 (11.2) and any required patches, Oracle recommends that you analyze your database before ...



Top 50 recent answers are included