antipodes1
Active Member
Hi there,
we are attempting to design a restore procedure for our enterprise server and are running into trouble with the restore of the database (SQL 2K). I would be interested to know the methods others use to restore their SQL database. We have tried a TIVOLI backup of the database and then a restore which is failing.
In the past I would have reinstalled SQL and then overwritten it with a backup, or maybe reinstalled SQL and attached files from a flatfile backup of the sql files. There seems to be lots of information about restoring a single dbase out there, but what about restoring a complete SQL server? Anyone with the answers?
Thanks
Gordon
OneWorld Xe Sp16_018, W2k, SQL 2K on Compaq Proliant.
we are attempting to design a restore procedure for our enterprise server and are running into trouble with the restore of the database (SQL 2K). I would be interested to know the methods others use to restore their SQL database. We have tried a TIVOLI backup of the database and then a restore which is failing.
In the past I would have reinstalled SQL and then overwritten it with a backup, or maybe reinstalled SQL and attached files from a flatfile backup of the sql files. There seems to be lots of information about restoring a single dbase out there, but what about restoring a complete SQL server? Anyone with the answers?
Thanks
Gordon
OneWorld Xe Sp16_018, W2k, SQL 2K on Compaq Proliant.