Friday, May 25, 2012

SQL 2012 Upgrade Gotcha: Network Backup Location

If you have your database backup location set to a network (UNC) path you might run into the following error during an upgrade of the Data Engine to SQL Server 2012. I think the upgrade process runs under the Local System account so it doesn't have permission to modify rights on the network location.

Updating permission setting for folder '\\<network path>' failed. The folder permission setting were supposed to be set to '<some gobbledy-gook that looks permissions and a SID>'.

The best thing to do is to prevent the problem in the first place. All you need to do is make note of the current database backup location and then change the location to a local directory on the server you're upgrading. Both steps can be accomplished by connecting to the SQL Server Data Engine instance via SQL Server Management Studio 2012 (screenshot below).

If you already ran into the problem and you can't get the Data Engine instance to upgrade then you came to the right place. If you're like me, you closed the final dialog of the upgrade that told you what went wrong and how to fix it so here is how it's done:
  1. Change the backup location as described above.
  2. Run the following in the command line from the root of the SQL Server 2012 installation media:
    setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE
    (This just removes the 2012 parts of the upgrade that didn't go right, not the entire instance)
  3. I don't remember if you need to reboot after step 2 or not but it wouldn't hurt.
  4. Run the 2012 upgrade again; it should work this time.
More gotchas to follow!

Did this help you? Please let me know in the comments!

No comments:

Post a Comment