[sims] Backup Exec 11d warning for SQL2005 -> SQL2008 migrations

[localzuk]

This is just a heads up to anyone who has yet to migrate SIMS.net to SQL2008 from SQL2005.

 

If you run Backup Exec 11d with the SQL module, you will no longer be able to backup the database directly, instead now being limited to backing up via the built-in backup system of SIMS and SQL.

[matt40k]

Does this mean you've just migrated?!?

 

11d is very old (4 yrs) so it's not surprising. Still it works and it's not to hard to add a pre-command to run dbattach, or stop the SQL service, or both!

[localzuk]

Does this mean you've just migrated?!?

 

11d is very old (4 yrs) so it's not surprising. Still it works and it's not to hard to add a pre-command to run dbattach, or stop the SQL service, or both!

 

Yes, we just migrated - our LEA did the migration for us but due to them having issues, it took a while to arrange the manual migration and we are not the last one in our LEA either.

 

And 11d may well be 4 years old, but as it costs a fortune to buy, we don't want to upgrade anything unless we have to. Not to mention, if we had bought it in Jan 08, it would only be 22 months old in our terms, hardly ancient in any terms!

 

Also, you missed my point. The idea behind a 'complete' backup solution is just that - it is complete. It allows someone to retrieve things without having to faff, this changes that and forces the hand for many.

[matt40k]

I agree BackupExec is a rip off - £400 odd to backup to tape - not cheap, plus another few hundred to get it to backup SQL. Personally, I would save the money getting the SQL addon, create a batch file that runs dbattach and add it as a pre-command.

 

I can't see how the extract, 2 mins setting up BackupExec is really faff?