July 9, 2014 at 9:21 am
Hi,
I have a large database (SQL Server 2008 R2) in which some of the filegroups are read-only, therefore the backup is just of the read/write filegroups.
I test these backups using a partial restore and everything works fine, however I also want to restore them to a new development server (SQL Server 2012), this obviously means an upgrade of the database as part of the restore. This upgrade fails the restore, as you would expect it can't upgrade the missing filegroups. That makes sense.
--The database is left in a 'Recovery/Pending' state.
My question is this, is it possible to do a partial restore between 2008 and 2012, either via some option I'm missing or some other method?
Any help would be appreciated.
Thanks,
Nic
July 9, 2014 at 10:16 am
if size of database is small then take full backup and restore.
July 9, 2014 at 11:55 am
It's not something I've tried before, but you'll have to restore all the database at least once before you can access it. In a partial restore operation, you're only moving around the readable bits, but the read only bits have to be there as well.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 10, 2014 at 4:10 am
Thanks for the replies.
Looks like I'll have to do the full restore at least once to allow the upgrade then. The database is large but I should be able to work around that.
Thanks for your help.
Nic
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply