Media set

Hi All
I would like to know in detail about the differences between back up set,
media set, media family, devise etc. Can any one provide link to resourses
where I can find that. In BOL it is bit confusing.
Thanks in Advance
R.DAn image tell more than a thousand words.
Using Media Sets and Families
http://msdn.microsoft.com/library/d... />
t_70oj.asp
AMB
"R.D" wrote:

> Hi All
> I would like to know in detail about the differences between back up set,
> media set, media family, devise etc. Can any one provide link to resourses
> where I can find that. In BOL it is bit confusing.
> Thanks in Advance
> R.D|||> An image tell more than a thousand words.
Keep up with the news. You should soon say:
An varbinary(max) tell more than a thousand words.
<g>
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:4549A302-23DF-4E5C-BBE1-AF1D26E43C17@.microsoft.com...
> An image tell more than a thousand words.
> Using Media Sets and Families
> http://msdn.microsoft.com/library/d...>
rst_70oj.asp
>
> AMB
> "R.D" wrote:
>|||Media Sets and Families
Media sets comprise several individual media. All media in a media set
should be of the same type. For example, a 200-GB database might span 3
tapes. The 3 tapes are considered to be a media set.
A media family refers to the collection of media used by an individual
backup device. For example, if a 2-TB database is backed up using 4 tape
drives (with 5 tapes in each drive), each set of 5 tapes is considered to be
a media family. Collectively the 20 tapes would be considered a media set.
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx[
/url]
Aleksandar Grbic
MCDBA, Senior Database Administrator
"R.D" wrote:

> Hi All
> I would like to know in detail about the differences between back up set,
> media set, media family, devise etc. Can any one provide link to resourses
> where I can find that. In BOL it is bit confusing.
> Thanks in Advance
> R.D|||Tibor,
This is good. I am happy to start a new w with some humor.
AMB
"Tibor Karaszi" wrote:

> Keep up with the news. You should soon say:
> An varbinary(max) tell more than a thousand words.
> <g>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:4549A302-23DF-4E5C-BBE1-AF1D26E43C17@.microsoft.com...
>

Measure data transfer between replicated servers

Hello All
I was wondering if there's a way to monitor/measure data-transfer
being taking place between 2 serves in a replicated environment.

I cannot see any counters, etc. to monitor this..??

thanks
SunitWhat about the SQL Server:Replication Dist counter to name but one ?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sunit Joshi" <sjoshi@.ingr.com> wrote in message
news:8f8ffe67.0404301026.1fbedf87@.posting.google.c om...
> Hello All
> I was wondering if there's a way to monitor/measure data-transfer
> being taking place between 2 serves in a replicated environment.
> I cannot see any counters, etc. to monitor this..??
>
> thanks
> Sunit

MDX:time between fatcs / time spent in a state

Hi all

I am an MDX newbie and it happens i have to do immediately with a query that seems (to me) pretty unorthodox.

The fact table i have is made up of the following entities: StateMachineId, StateId, TransitionDateTime.
In fact, i have several State Machines that can find themselves in different states and i log in a DB the time of their transitions and the new state.
I need to generate reports mostly based on the time spent in each state and i have no clue on what is the best way to do that in mdx.
In sql, what i did was to join this FactTable (FT1) with itself (FT2) ON StateMachineId adding the condition that FT2.TransitionDateTime BETWEEN FT1.TransitionDateTime AND FT1.TransitionDateTime + SomeTimeInterval , in this way i narroewed the size of the join. At this point, i took the row from FT2 with the lesser TransitionDateTime .
All this works perfectly, but it is akward and pretty slow. Another downside is that some longer transitions (those longer than SomeTimeInterval) are excluded.
I think working with MDX could be better but, as i stated before, i am new in this field.
Do you have some ideas to create a suitable cube for these queries?

Thank You So Much

Best regards

Wentu
It's me again

I found this SQL solution:

Code Snippet

with modnums as (
select *, row_number() over (order by StateMachineId, TransitionDateTime) as rn
from FactTable
)
select m_this.StateMachineId, m_this.TransitionDateTime, m_next.StateId, m_next.TransitionDateTime, m_this.StateId, datediff(ms,m_this.TransitionDateTime, m_next.TransitionDateTime) elapsedTime
from
modnums m_this
inner join
modnums m_next
on m_next.rn = m_this.rn + 1
and m_this.StateMachineId = m_next.StateMachineId

It's working very well (Thankx to Rob Farley for this) .
Now, i would like to use it in Analysis Services but the "OVER" is not allowed in Named Queries. Any Idea on how to write this query in MDX ?

Thankx again

Wentu