SQL Server Full Database Backup not Restoring All Data

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
6/10/2010 12:48:28 PM
Tim Webster
Gravatar
Total Posts 8
View Posts

SQL Server Full Database Backup not Restoring All Data

Hello,

We have been developing a web site and would like to make copies of it on other computers for testing.  We use the version control feature which we really like.  The problem I'm having is when we restore the full backup onto another computer we don't have all the html content from the original.  The original has 130 rows of data in the html mp_HtmlContent table whereas the restored database has only 70 rows.  Additionally the site map is different as well.  Any ideas what is going on here.  I remember successfully restoring this application several months ago but haven't tried this lately.  The version we are currently on is 2.3.3.9.  The database was SQL Server 2008 Express and I even upgraded to SQL Server 2008 R2 Express to no avail.  I have tried both the gui backup utility inside SQL Server Management Studio as well as a TSQL backup database command.

Tim

6/13/2010 10:06:17 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: SQL Server Full Database Backup not Restoring All Data

My best guess is that when you make the backup you have it configured for append to media instead of replace/overwrite, so you end up with a set of backups all in one file and when you restore it it is using the first one in the set not the newest one.

There is nothing in mojoportal that can have any effect on database backup and restore tools.

Hope it helps,

Joe

8/17/2010 9:06:53 AM
yagoda76
Gravatar
Total Posts 1
View Posts

Re: SQL Server Full Database Backup not Restoring All Data

***There is nothing in mojoportal that can have any effect on database backup and restore tools.***

 

so, can I advise some kind of external tool? I think the topic starter may try the [url=http://www.recoverytoolbox.com/how_to_repair_sql_2005_database_mdf_files.html]sql server repair mdf[/url] application, it is the easiest way to repair corrupted databses. Indeed, there are some other utilities that perform the same task, I do not insist
 

You must sign in to post in the forums. This thread is closed to new posts.