Backup and restore database

thanhtruc

unread,

Jun 6, 2006, 1:01:55 AM6/6/06

to

Hi all.

Now I use Delphi7, TIBBackupservice to backup my database before update it,
and TIBRestoreservice to restore that database if getting errors while
updating.

I always get error when restore the database if it is connected.
My problem is I can't define if the database is been connecting or not.

Have u ever met this case?

--

Thanh Truc.

Robin

unread,

Jun 6, 2006, 1:17:35 AM6/6/06

to

Hi Truc,

The IBBackupService has a boolean property 'IsServiceRunning'.

It might be that your backup has not finished before you try to restore it.

--
Robin.

"He who treats the database as a flat-file repository of data is doomed
to burn in Hell. It's true, I asked." - Dratz

thanhtruc

unread,

Jun 6, 2006, 3:50:11 AM6/6/06

to

Thanks Robin.
But I have to tell once more about my problem.

1. I backup database, and certainly it's okey.
2. After that, I start update that database (example: add some procedures or
triggers), get errors, so I want to restore my database.
3. Certainly I have to disconnect all connections to my database (some other
applications connect to it) before do restoring.

But how can I find all of those connections to disconnect?
It's exact my problem!

Thanks for all.
--

Thanh Truc.

thanhtruc

unread,

Jun 6, 2006, 3:54:38 AM6/6/06

to

Sorry, but I have to rewrite a bit.

"But how can I find all of those connections to disconnect?"

--> I only want to know if there 's any connection to my database before I
do restoring, not all of them.

Thanks.

--

Thanh Truc.

Jeff Overcash (TeamB)

unread,

Jun 6, 2006, 9:27:57 AM6/6/06

to

thanhtruc wrote:
> Sorry, but I have to rewrite a bit.
>
> "But how can I find all of those connections to disconnect?"

IBDatabaseInfo should give you the connected users. You can shutdown the server
with one of the admin components (don't remember which off the top of my head).

> --> I only want to know if there 's any connection to my database before I
> do restoring, not all of them.
>
> Thanks.
>
> --
>
> Thanh Truc.
>
>

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
A human being should be able to change a diaper, plan an invasion, butcher
a hog, conn a ship, design a building, write a sonnet, balance accounts, build
a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act
alone, solve equations, analyze a new problem, pitch manure, program a computer,
cook a tasty meal, fight efficiently, die gallantly. Specialization is for
insects. (RAH)

Bill Todd

unread,

Jun 6, 2006, 10:41:59 AM6/6/06

to

thanhtruc wrote:

To disconnect all attachements use:

UPDATE TMP$ATTACHMENTS SET TMP$STATE = 'SHUTDOWN'

--
Bill Todd (TeamB)

thanhtruc

unread,

Jun 13, 2006, 11:31:08 PM6/13/06

to

Thanks all.
I 'll try all your tips

--

Thanh Truc.

thanhtruc

unread,

Jun 13, 2006, 11:37:29 PM6/13/06

to

Hi Bill Todd.
Can you rewrite clearly your tip?
Because I don't know where I have to write this SQL ("UPDATE TMP$ATTACHMENTS
SET TMP$STATE = 'SHUTDOWN'").

Thanks.

--

Thanh Truc.

Bill Todd

unread,

Jun 14, 2006, 10:50:13 AM6/14/06

to

thanhtruc wrote:

You can use that statement in any tool that lets you execute SQL
statements against your InterBase database including IBConsole, isql,
any third party tool that lets you execute SQL or a program you have
written that uses the InterBase Express or dbExpress components.

--
Bill Todd (TeamB)

thanhtruc

unread,

Jun 20, 2006, 3:26:42 AM6/20/06

to

Yes, thanks so much for your care.

--

Thanh Truc.