Funky Glass Art and SQL Server Musings: March 2007

SQL Server 2005 Service Pack 2 Installation -- where are my databases??

Thursday, March 8, 2007

I upgraded our development server from SP1 to SP2 of SQL Server 2005 this morning. It claims that the database engine upgrade failed (yes, that's as verbose as the error message got), yet all the server properties purport that it's now SP2.

At any rate, some of our databases were left in "RECOVERY_PENDING" status. Rebooting didn't help, so I tried the first result of my Googling -- set the database offline, then back online. Coming back online failed, but it returned a helpful error: operating system access denied. LO AND BEHOLD, the broken database files now had different NTFS permissions than the working databases. I made them all the same, and the databases happily came back online.

Labels: SQL Server

Permalink

SQL Server 2005 Service Pack 2 Installation -- where are my databases??

Buy My Art

Labels

Recent Posts

Archives

Navigation

		SQL Server 2005 Service Pack 2 Installation -- where are my databases?? Thursday, March 8, 2007 I upgraded our development server from SP1 to SP2 of SQL Server 2005 this morning. It claims that the database engine upgrade failed (yes, that's as verbose as the error message got), yet all the server properties purport that it's now SP2. At any rate, some of our databases were left in "RECOVERY_PENDING" status. Rebooting didn't help, so I tried the first result of my Googling -- set the database offline, then back online. Coming back online failed, but it returned a helpful error: operating system access denied. LO AND BEHOLD, the broken database files now had different NTFS permissions than the working databases. I made them all the same, and the databases happily came back online. Labels: SQL Server Permalink
	Buy My Art Original glass and gemstone jewelry and glass housewares at Jellybug Artworks! Labels Access ADO Art - Glass - Fusing - Ideas Art - Glass - Fusing Art Food Art ASP ASP.NET Beasts Contest Costumes Excel Tricks Google Base Haiku Hair Color Home Wares Internet iPhone Jewelry Kinetics Maine Outlook Tricks Recipe of the Week Sale Song Stylings of Stephen Foster SQL Server - Backups SQL Server - Diagnostics SQL Server - Performance SQL Server - Scripts SQL Server - SSMS SQL Server 2008 SQL Server Titter To the Tune of Uncategorizable Silliness Web Applications - Javascript Web Applications Writings Recent Posts Modern Mint Square Plate Bronzite and Green Opal Gemstone Necklace and Earr... Rose Recycled Etched Wine Bottle Serving Tray Daisy Recycled Etched Wine Bottle Serving Tray Modern Mint Oval Platter Wine and Wiggles Fused Glass Plate Rosebud Saucer Earrings Easy Being Green Fused Glass Pendant Half Goddess Fused Glass Pendant Berry Bush Fused Glass Pendant Archives January 1997 April 2001 June 2002 November 2002 January 2004 August 2004 November 2004 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 May 2006 June 2006 July 2006 September 2006 February 2007 March 2007 May 2007 August 2007 October 2007 November 2007 January 2008 February 2008 March 2008 April 2008 May 2008 June 2008 July 2008 August 2008 September 2008 October 2008 November 2008 December 2008 January 2009 February 2009 March 2009 April 2009 May 2009 Navigation Home Art Comics Recipes Hair
		Blogger Template by Gecko & Fly, modified by yours truly.