Re: Developer Database Snapshots

Tech-Archive recommends: Speed Up your PC by fixing your registry

"Tommi" <Tommi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2ECEE6F8-AD03-4245-A0A5-E35F425E6810@xxxxxxxxxxxxxxxx
> I'm developing tool for developers to create snapshots (i.e. backups) from
> different states of SQL Server databases. Later when required for unit
> and/or
> stress testing or code profiling developer could quickly restore database
> snapshots.
>
> Tell me what do you think - is this kind of tool worth doing ?

Not if you use the word "snapshot". There are already at least three
things in SQL Server 2005 that use that name: Database snapshots (i.e. not
backups, but snapshots -- very different), snapshot isolation level, and
snapshot replication.

Plus, there are other types of snapshots available, such as SAN
snapshots. Adding yet another snapshot to an already overused pool is going
to be extremely confusing for your potential users.


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--



.

Relevant Pages

  • Re: a union is always a join!
    ... A changing world can be described as a series of snapshots or as a series ... successor snapshot is clearly stated in each transition. ... declaratively specify constraints that limit the behavior of objects, ... A database is an assertion that states what things have been in the world ...
    (comp.databases.theory)
  • Re: RMAN backups to NFS OR FS snapshots
    ... We have also not used snapshots, but we might want to consider that.. ... clones to replicate the production database. ...
    (comp.databases.oracle.server)
  • Taming Dynasets - what are all those connections!
    ... Those that need to be edited are snapshots but with a dynaset ... I've had a look at Refresh Interval and ODBC refresh interval, ... only seem to be tied to the local install of access, not the database ... Then I have a subform with some combos. ...
    (comp.databases.ms-access)
  • Re: the two questions
    ... Something has to be consistent for them to be the ... From a given database value D, you can arrive at a new database value D' ... T1-T6 are just different snapshots of it. ... recognize it as our "insect life" entity, we need that identifier. ...
    (comp.databases.theory)
  • RE: Replication
    ... Snapshot replication copies over the entire database. ... will still need to backup the main instance of the database. ... > backup or snapshots multiple times a day would also work just fine. ...
    (microsoft.public.sqlserver.programming)