Copy open database files
Copy open database files
Goodday is it possible to backup open database files?
Re: Copy open database files
Yes (if the database supports Volume Shadow Copies)
--
Luis Cobian
Cobian Backup's creator
Luis Cobian
Cobian Backup's creator
Re: Copy open database files
The thing about shadow copying database file is you don't know the state of the file when it's copied. Better to have the database make a backup and then back that up. Just a thought.
Re: Copy open database files
That's right but if the database is designed to properly handle a VSS request, the state of the db should be OK.With that said, I too handle this with events (close and reopen the db)
--
Luis Cobian
Cobian Backup's creator
Luis Cobian
Cobian Backup's creator