General discussion

Locked

SQL Backup Issues

By bbuechler ·
It seems we're having difficulties backing up open files on a Pervasive SQL database.

Both Pervasive and Microsoft admit this to be a problem. But we are a 24 hour operation who cannot simply backup the server when it's not in use - because it'salways in use.

Both Pervasive and Microsoft state that you can set the backup to 'continuous' so that the instant any file is closed, it is backed up. However this meathod causes increased bandwidth/slowdown issues that we'd like to avoid.

Isthere any way around using the continuous backup mode? Is there perhaps a third-party app that will accomplish this?

(I don't need a list of backup softwares that simply 'backup open files', I need one that you know for a fact will backup open Pervasive or Microsoft SQL database files).

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Backup Issues

by gutridgesj In reply to SQL Backup Issues

since you do not want a list of software how about this.

we were using ms sql 6.5 and now we use 7.0, what we are doing is dumping the db and transaction logs to other files every so often and then that dump file gets backed up with the backup software

of course you need enough disk space to do this

since we do this, we do not need to spend money on 3rd party software

Collapse -

SQL Backup Issues

by bbuechler In reply to SQL Backup Issues

Poster rated this answer

Collapse -

SQL Backup Issues

by bbuechler In reply to SQL Backup Issues

Don't get me wrong, software suggestions are fine. Just be sure that the software deals directly with this issue.

You suggestion sounds a little cumbersome and time consuming (depending on the size of the files). However it is possible, so I'll pass it along.

Anyone have any other suggestions?

Collapse -

SQL Backup Issues

by bbuechler In reply to SQL Backup Issues

This question was closed by the author

Back to Windows Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums