Subject | Re: [firebird-support] Backup database to working copy? |
---|---|
Author | Martijn Tonies |
Post date | 2005-03-22T11:26:04Z |
> >> I was wondering if it was possible to do a backup of a FirebirdNo, you cannot.
> >> database and create a backup which can be connected to without
> >> requiring a restore?
> >
> > A "backed up database" is not a database. You _have_ to restore
> > it to make it into a database.
>
> I knew this. Maybe I shouldn't have used the word backup when
> explaining my situation. I am essentially wanting to copy a database,
> delete some records and then create a backup of it. I was wondering
> whether I could do this while there was an active connection to said
> database?
The only way to make a safe copy is to shut down the Firebird
server and then do an operating system file copy.
The other safe way is to create a backup and restore it to a new
database.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com