Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm attempting to upgrade a SQL 2005 SP3 clustered instance to SP4. During installation, a rollback event took place with the error indicating there was insufficient space on the the disk. The system volume and application binary volume both have adequate space. On examination of the hotfix logfile, the config.msi target folder for the rollback files was the volume used as a mountpoint folder (in this case, M: was the target but it's only 128 MB in size, hosting only folders to be used as mountpoints for other physical disks, like M:\DATA00). Why would the SP install routine use that volume instead of the system volume or SQL binary volume for the rollback file location and can the target path for the rollback file be altered?

share|improve this question
    
Does SQL Server have any particular knowledge of M:\ (e.g. is it the drive specified for any defaults such as default data path, log path, error log, etc.)? –  Aaron Bertrand Apr 26 '13 at 15:04
    
Not the M:\ path explicitly, but for default data, tlog and backup paths (i.e., M:\MOUNTPT\DATA00\SYSDB\MSSQL.1\MSSQL\DATA) –  MattyZDBA Apr 26 '13 at 15:49
    
Yes, I meant M:\<anything>\... - let me ask some colleagues –  Aaron Bertrand Apr 26 '13 at 15:50
    
I found something similar to this applying SP2 for SQL 2008 R2 desktop tools on my laptop. I found the unpacking of the MSI was occurring on the USB drive I had plugged in and not a local drive. I could not figure out why it was choosing to use that drive. –  Shawn Melton Apr 26 '13 at 16:06
    
I was thinking that was the issue as well and did an unpack to a D:\ drive folder, but got the same result on install. The M:\ reference only shows up on the log file when spawning the rollback file. –  MattyZDBA Apr 26 '13 at 16:17
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.