Page 1 of 1
Copy open database files
Posted: 19 Sep 2022, 17:03
by Randy
Goodday is it possible to backup open database files?
Re: Copy open database files
Posted: 20 Sep 2022, 01:16
by cobian
Yes (if the database supports Volume Shadow Copies)
Re: Copy open database files
Posted: 20 Sep 2022, 07:58
by Randy
Nice thank you
Re: Copy open database files
Posted: 20 Sep 2022, 19:51
by ira
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
Posted: 21 Sep 2022, 10:55
by cobian
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)