Restoring databases to Server 2005

Whilst attempting to restore a database backup to SQL Server 2005, I encountered a "restore failed" error due to "the file or filegroup cannot be selected for this operation". After some trawling of the Net, I found the solution.

There is an option in the Restore window to copy the script generated to the clipboard. Cancel out and paste the script into a New Query. Delete the two "FILE = " options from the line then execute the script. Bingo, you have a newly restored database.

Coming up for air, UniPhi 3.0 released

It has been a while between UniPhi blog posts, however the 3.0 release of UniPhi is now complete and deployed with existing clients, so far the feedback has been very positive.

Some of the key new features include:

• Exporting UniPhi documents to pdf
• Cost Management
• Procurement Management
• Improved rich text editor

Of the four major additions and improvements, the pdf rendering of UniPhi documents is the most interesting from a technical perspective. We are utilising XSL Formal Objects as a means of converting the XHTML output from the UniPhi document management system into a format which can then be passed through a processor to generate almost any format desired, PDF was obviously the first one we looked at, utilising third party library from Altsoft.

Writing the XSL transformations was completely new to me from a personal perspective, a new challenge is always a welcome addition to any software project and we are very pleased with the results.