Re: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

On 6/13/06, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> wrote:
>
> I attended a presentation yesterday on SQL2005. They claimed to have
> instituted a locking mechanism similar to Oracle's. I asked about
> flashback. Apparently you can create database snapshots but you have to
> know to create one just before somebody drops a table accidently. They
> are supposed to be getting back to me about FGAC.
>
>

The SQL Server 2005 snapshot is much like a snapshot in the storage sense.

That is, it uses copy-on-write to keep the snapshot up to date.

If you drop the table in the source, it will get copied to the snaphot before being dropped from the source.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l