June 20, 2008 at 7:18 am
I have seen a lot of posts asking about this, but have seen no answers. I am trying to use the CODEPLEX CLUB Starter Kit. I have it working fine running off of the supplied Express DB, now I want to take a backup of that DB, or use any other method, and restore it to a regular MS SQL Server 2005 DB.
Can this be done? I get meaningless errors when trying to do it. If so, how?
June 20, 2008 at 8:54 am
Can you post the error message(s)? They may not be meaningless to someone here.
I've upgraded databases from Express to Standard quite a few times. Definitely works. But there might be something specific in that particular database that blocks that. Can probably be overcome, but seeing the error messages would be helpful in that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 20, 2008 at 9:10 am
This is when trying to restore the CLUBDB from a backup from express.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'xxxxxx'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Too many backup devices specified for backup or restore; only 64 are allowed. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
June 20, 2008 at 11:52 am
What code are you using for the backup and the restore?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 20, 2008 at 11:56 am
SQL Express Management Studio on the Express side for creating the backup, and SQL Server Management Studio on the standard side for restore.
June 20, 2008 at 12:46 pm
The error message you're getting is saying that the backup was done to "too many devices". That usually means too many backup files.
Try running a separate full backup, to a different location than usual, and try restoring that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply