At this point I decided to restore from nightly tape backup. Unfortuantely,
my Seagate backup exec 7.2, was a trial version that someone (me) forgot to
put my new reg codes into after I bought them, so I opened it to find I was
on day 71 of a 60 day trial. Great no backups for the last week or so. So I
put in the reg codes. so now I have to restore from a backup that is over a
week old. at this point I am bashing my head against the wall. So I proceed
to load the old backup by doing the following.
Droping the emerald database and its log and data devices. manually
deleteing the DAT files from the drive.
I then opened emerald admin 2.5.60 and asked it to recreate the database.
While creating the database and populating it with tables,
the create database dialog shows a "Arithmetic overflow occurred." message
but emeradmin still says the db was created successfully.
so from here I attempt to load in my backed up data.
My restore fails due to constraints on the database.
Now I am faced with trying to gracefully remove all constraints from the
database.
does anyone know how I can UN-GRACEFULLY remove all of the constraints so I
can restore my backup and get up and running again?
Any help is a godsend and I would be eternally grateful.
Franco Nogarin
Radius NT 2.5.151
Emerald 2.5.229
SQL 6.5