Missing Triggers

Hi,
I had a problem with a 12GB Database, where a failure on
the disks damaged the datafiles, leaving the database in
Suspect mode.
I managed to recover most of the data, with some data
missing from where the Data Pages where damaged.
No backups on this one (as usual), they where failing for
2 months :(
Then i created a new database, optimized for that size (5
datafiles top size=3.5GB) and moved the data.
And there it whnt online for users access
But somewhere on the process i forgot to activate the
triggers, when i detected my mistake the DB had already 1
week on prodution.
My question is: is there any way to force the Triggers to
execute (Insert) on data alread on a table?> My question is: is there any way to force the Triggers to
> execute (Insert) on data alread on a table?
No, but depending on what your trigger code did, you could probably run a
manual update/insert process ...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||>No, but depending on what your trigger code did, you could probably run a
>manual update/insert process ...
Hi, thanks for your reply
Yes i've tried to retransfer data using the export data, but it seems that it disables the triggers before inserting data.
I also tried to do a "insert into" a copy of the db but some of the tables have a timestamp field that doesn=B4t allow inserting data with a timestamp already on it.
Paulo Ferreira

Missing Log - Suspect Datanbase - HELP!

A customer called me and said they ran the disk out of space, rebooted the
machine and the activity log is complaining about the database log being
already in use, and being out of disk. The database is in suspect mode, and
the database log is MIA!
Any ideas'
Thanks
RichardTry looking into system procs,
sp_add_data_file_recover_suspect_db and sp_add_log_file_recover_suspect_db
in books online
Thanks
"Richard Douglass" wrote:
> A customer called me and said they ran the disk out of space, rebooted the
> machine and the activity log is complaining about the database log being
> already in use, and being out of disk. The database is in suspect mode, and
> the database log is MIA!
> Any ideas'
> Thanks
> Richard
>
>|||Richard
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:OfDesPeVHHA.1000@.TK2MSFTNGP05.phx.gbl...
>A customer called me and said they ran the disk out of space, rebooted the
>machine and the activity log is complaining about the database log being
>already in use, and being out of disk. The database is in suspect mode,
>and the database log is MIA!
> Any ideas'
> Thanks
> Richard
>

Missing Log - Suspect Datanbase - HELP!

A customer called me and said they ran the disk out of space, rebooted the
machine and the activity log is complaining about the database log being
already in use, and being out of disk. The database is in suspect mode, and
the database log is MIA!
Any ideas'
Thanks
RichardTry looking into system procs,
sp_add_data_file_recover_suspect_db and sp_add_log_file_recover_suspect_db
in books online
Thanks
"Richard Douglass" wrote:

> A customer called me and said they ran the disk out of space, rebooted the
> machine and the activity log is complaining about the database log being
> already in use, and being out of disk. The database is in suspect mode, a
nd
> the database log is MIA!
> Any ideas'
> Thanks
> Richard
>
>|||Richard
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:OfDesPeVHHA.1000@.TK2MSFTNGP05.phx.gbl...
>A customer called me and said they ran the disk out of space, rebooted the
>machine and the activity log is complaining about the database log being
>already in use, and being out of disk. The database is in suspect mode,
>and the database log is MIA!
> Any ideas'
> Thanks
> Richard
>