topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday December 10, 2024, 6:12 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Best SQL Express DB backup Software (SQL Express 2008)  (Read 3759 times)

questorfla

  • Supporting Member
  • Joined in 2012
  • **
  • Posts: 570
  • Fighting Slime all the Time
    • View Profile
    • Donate to Member
Best SQL Express DB backup Software (SQL Express 2008)
« on: March 29, 2015, 08:04 PM »
Just wondering if anyone has had positive results from any of the many possibilities for getting a SQL Express DB backup

I have a need to temporarily use something other than the DB's internal backup of a SQL Express DB.  It normally runs its own backup  every night and i keep copies of what it backs up.   Unfortunately, it is having issues of some kind and until they can resolve them I would like to be able to keep some kind of backup even if it isn't the one they normally keep.
Hopefully, this will be resolved by Monday or Tuesday but until then it has already been several days of me making copies of their backups  but the event logs say those may not be good.



Thanks

x16wda

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 888
  • what am I doing in this handbasket?
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Best SQL Express DB backup Software (SQL Express 2008)
« Reply #1 on: March 29, 2015, 08:17 PM »
Can you try Expressmaint?
vi vi vi - editor of the beast

Shades

  • Member
  • Joined in 2006
  • **
  • Posts: 2,939
    • View Profile
    • Donate to Member
Re: Best SQL Express DB backup Software (SQL Express 2008)
« Reply #2 on: March 30, 2015, 12:39 AM »
The backups may not br good...or are they not good?

If you don't know, you should test the created backup by importing it on a different SQL2008 Express DB server (a VM is helpful in this case) and test the data being served up by the new SQL DB.
Assuming you have an application that works with this exported data, you could use the same application to verify the data coming from the new DB.

Don't trust a backup you make, verify that it works...else you won't have made a backup at all. It won't matter if you make a backup using 3rd party software or the integrated tools from MS itself. Never trust the message saying "Backup successfully completed". You will be burnt if you won't verify by importing the data again. I have seen the aftermath of others failing miserably with this years ago and you won't see me make their mistakes ever again.

Once you have such a test setup and backup strategy, you will be better prepared for any mishap that is waiting for you. If you do not verify your backups, you have not made backups. Can't say this often enough. 

Making a copy of an existing dump you created earlier isn't much of a safety net either. The NTFS file system (or FAT32 or EXT2 or EXT3 or EXT4 or HFS) can't be trusted 100%. Especially folks that use the MS default file size notation of KB/MB/GB are fooled into thinking that copies  of a file are the same. This notation introduces rounding and that can (and shall) be fatal. I use the byte size notation in directory opus as first indicator to see if there are file size differences. And I have seen these occur. And I have lost control files from Oracle database, simply because of a 1 byte difference in file size.   

For most intends and purposes any of the main file systems are more than adequate, but 100% reliable they aren't.

 

x16wda

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 888
  • what am I doing in this handbasket?
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Best SQL Express DB backup Software (SQL Express 2008)
« Reply #3 on: March 30, 2015, 05:53 AM »
If you do not verify your backups, you have not made backups.

This.

Spin up your server backup in a VM. Restore your SQL backup to another instance. Then you know the process works, and you will have been through the recovery steps so you're not winging it.

Then you do it again the next year.
vi vi vi - editor of the beast