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?
>>