Database start trigger 2005

Hi,

I have searched high and low, and can not find any mention of SQL2005 and mount/start database DDL triggers.

I need a trigger/job/event to update a column in a table to indicate that the database has been restarted. I can not have an application connect to the database and set this value as I am afraid one of my other computers may connect first and get the wrong state from the database.

Is there any way to have SQL2005 update a table on MOUNT/Service Start/DB start?

Regards,
Derek

I solved it on my own. I use a StoredProcedure in the MASTER database and set it to start automatically.

~Derek

database quiescing mode

I do have a question that I searched the book but not found answer. As you
know Oracle or DB2 has a feature called database quiescing mode, that can
put database in such state that transactions are temporarily staged,
providing certain time for database snapshot or replication. After the
snapshot is done the quiescing mode can be disabled and all paused
transactions are committed into database. Does SQL 2005 have similar
feature? If not what 3rd party software as you know can mimic the
operation?SQL Server has supported quiescing I/Os for a long time (since SQL 7.0 at
least). In SQL2000 Books Online, type Snapshot backup on the Index tab. On
the Microsoft website, search for VDI (virtual device interface). For
instance, here's the SQL2005 VDI specs
http://www.microsoft.com/downloads/details.aspx?FamilyID=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&DisplayLang=en.
Third-party tools such as EMC TimeFinder all leverage SQL Server quiesceing
capability when doing snapshot backups.
Linchi
"Rustom" wrote:
> I do have a question that I searched the book but not found answer. As you
> know Oracle or DB2 has a feature called database quiescing mode, that can
> put database in such state that transactions are temporarily staged,
> providing certain time for database snapshot or replication. After the
> snapshot is done the quiescing mode can be disabled and all paused
> transactions are committed into database. Does SQL 2005 have similar
> feature? If not what 3rd party software as you know can mimic the
> operation?
>
>|||The VSS writer service does that for the Windows Volume Shadow Service in
SQL 2005.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:13B181C1-6F6C-4320-9545-25749A954C2E@.microsoft.com...
> SQL Server has supported quiescing I/Os for a long time (since SQL 7.0 at
> least). In SQL2000 Books Online, type Snapshot backup on the Index tab. On
> the Microsoft website, search for VDI (virtual device interface). For
> instance, here's the SQL2005 VDI specs
> http://www.microsoft.com/downloads/details.aspx?FamilyID=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&DisplayLang=en.
> Third-party tools such as EMC TimeFinder all leverage SQL Server
> quiesceing
> capability when doing snapshot backups.
> Linchi
> "Rustom" wrote:
>> I do have a question that I searched the book but not found answer. As
>> you
>> know Oracle or DB2 has a feature called database quiescing mode, that can
>> put database in such state that transactions are temporarily staged,
>> providing certain time for database snapshot or replication. After the
>> snapshot is done the quiescing mode can be disabled and all paused
>> transactions are committed into database. Does SQL 2005 have similar
>> feature? If not what 3rd party software as you know can mimic the
>> operation?
>>