I need help with my database. I had upgraded to sqlexpress 2012 because I was concerned about my database size and then I find out that it is not compatible with RMS. I am having to do a clean install to get sqlexpress 2012 off but I am not able to retore my db backup. I get an error "incorrectly formed". I am able to continue to make backups but I want to be able to restore before I do my clean install. I am not very familiar with sql but I did see something about “altering database compatibility level”. I am not sure if this is the direction I need to go. I would appreciate any help.
Good morning Anthony,
Thank you for posting your SQL question.
There is not a way to restore a database backup, made on a newer version of SQL, onto an older version of SQL.
If you have a backup I would recommend simply installing SQL 2008 R2 Express; and then restore your backup onto that version of SQL.
Supported version of SQL, etc. are listed on the Service Packs; and the below link is for RMS Service Pack 4:
mbs.microsoft.com/.../rms-20-sp4
If you do not have a backup you will want to contact Technical Support to open a support request: to see if there may be a way to get your data out of 2012: mbs.microsoft.com/.../newstart.aspx or by calling MBS support at: 1-888-477-7877.
Try downloading the Microsoft SQL Server 2005 Backward Compatibility Components
install it and it should work with 2012
www.microsoft.com/.../details.aspx
Nope, 2012 deleted/changed some functions that RMS was using, that's one of the reasons for Feature Pack 2 for RMS.
To use SQL2k12, you must use the upcoming FP2, said to be coming in H2 2012
-- Regards,
Jeff HobbsCheck Point Software