Skip to content

The Dailey Grind

September 7, 2016 / web development

“Family count” error when trying to restore database in SQL Server

In the process of migrating a SQL Server LocalDB database to MySQL, one of the steps involves restoring the database in SQL Server Management Studio. The LocalDB database was first created in Visual Studio and to migrate it over to MySQL the database had to be setup in SQL Server Management Studio beforehand. Initially I recreated the database in Management Studio by using the T-SQL generated in Visual Studio. Along the line I had to move the database from my work computer to my home computer due to needing admin privileges to run certain tasks.

This is when I encountered an error of “Family count:2. Missing family sequence number:1” when in the middle of the restore process. After some digging, the cause was from having more than one file path listed when performing the backup. I backed up the database a second time with just one file path listed under the Destination section and the Backup Type set to ‘Full’. The database was restored with no errors. Success! Here is a blog post from SQL Compass with some helpful screenshots.

Post navigation

Previous Post:

Switching from SQL Server to MySQL in an .NET MVC app

Next Post:

Jetpack is a must-have WordPress plugin

Search

Recent Posts

  • Using WP-CLI and Composer to migrate a site
  • How to add free SSL certificate to GoDaddy shared hosting
  • Adding virtual hosts in WAMP
  • Simple fix if custom fields in WordPress are not saving

Categories

  • black and white
  • events
  • misc
  • photo retouching
  • photography
  • Photoshop
  • portrait
  • travel
  • Uncategorized
  • web development
  • Wordpress
©2019 The Dailey Grind - Powered by Simpleasy