myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Invalid backup file? Options · View
dmwhitedragon
Posted: Friday, April 24, 2009 10:36:23 AM
Rank: Newbie
Groups: Member

Joined: 4/24/2009
Posts: 2
Points: 6
Location: Sydney
Hi smile

I have a website on Mosso and have a 2008 database created on there. I have 2008 express installed locally

I can backup and restore locally perfectly fine but when i upload and try to restore i get this:

"The file you selected is not a valid backup file. Please choose another file and try again."

Using the check databases option i get this however and it seems weird to me (i've checked and logged into the 2008 cluster for sure)

Property Current value Expected value
Compatibility Level: SQL Server 2008 SQL Server 2005
User Access: Multi user Multi user
Is Read Only: False False
Is Auto Close On: False False
Is Auto Shrink On: False False

So its 2008 but it expects 2005? Any idea what that would mean?

Can you simply not restore express backup databases to a full version 2008 install?
elian
Posted: Friday, April 24, 2009 10:51:09 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Looks like your current Mosso db is set with SQL2005 compatibility level.

Thus you cannot restore your SQL2008 backup because it has a SQL2008 compatibility level and SQL Server backup are not forward compatible.

Ask Mosso to change your db compatibility level to SQL2008 or try to do it by yourself with this T-SQL code:

Code:
EXEC sp_dbcmptlevel 'yourdbname', '100'


Hope this helps
dmwhitedragon
Posted: Saturday, April 25, 2009 10:39:21 AM
Rank: Newbie
Groups: Member

Joined: 4/24/2009
Posts: 2
Points: 6
Location: Sydney
Hi thanks for the reply smile

I checked via the SQL Management Studio remotely connected to the Mosso database cluster and checking the db properties.

Said the DB is set to "SQL Server 2008 (100)" my local 2008 one is set to "SQL Server 2005 (90)" so i ran the above code on the remote server anyway and tryed the import... still failed

I tryed setting my local one to 2008 (100) and then backing up and uploading again and it still failed :(

Anything else i can try?

Extra:
MLB still says that the current compatability level for the database is SQL Server 2008 but that it expects SQL Server 2005 ? So i clicked the button to 'fix it' and now they are both set to 2005.

I've set my local one back to 2005 (so server and local are 2008 db's set to 2005 compat mode) still failed

I can't find any info on the compatability level of SQL Server 2008 Express and full versions of SQL Server 2008...
elian
Posted: Monday, April 27, 2009 8:46:06 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
The "expected value" displayed by MLB is defined in a config file by your webhoster (mosso)

AFAIK Express Edition backup can be restored on Full Edition.

If your db does not contain sensitive data, would you mind sending us a backup so that we can check (support [at] mylittletools.net)?

Also did you try to Mosso about this prob?

Thanks
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.