No log operation

Hi
I have a database with full recovery model.
Every night at 11.00pm performs full backup, and dayly every 3 hours
performs differential backup, and trasnactional log backup performs
every 15 minutes during a day.

I am interested what operations i can not recover from log or
differential backup.

I saw that when i drop table i can recover it from log backup, but is
there some operation that can not be recover

Thanks a lot
Alex

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"acko bogicevic" <aconi2002@.yahoo.com> wrote in message
news:406d2652$0$198$75868355@.news.frii.net...
> Hi
> I have a database with full recovery model.
> Every night at 11.00pm performs full backup, and dayly every 3 hours
> performs differential backup, and trasnactional log backup performs
> every 15 minutes during a day.
> I am interested what operations i can not recover from log or
> differential backup.
> I saw that when i drop table i can recover it from log backup, but is
> there some operation that can not be recover
> Thanks a lot
> Alex
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

In full recovery, all operations are logged, including truncating tables,
dropping objects, bulk loads etc., so you can always recover to any point in
time. See "Recovery models" in Books Online.

Simon

No data in Data Mining cube.

Hi,

I've created a Cluster data mining model and seems to correctly return data. However I've created a data mining dimension and cube but when I go to query the cube it doesn't return any data if I select any members on the data mining dimension. Any suggestions to where I can look to resolve this?

Thanks

Sanjay

Hi,

I found out how to see the data in the cube. I was using the data mining dimension in relation with the dimension it was based on. So now I can see data for the years that I've trained my model on. Is there anyway to make the cube predict the values for the other years in the cube with data?

Thanks

Sanjay

|||

Are you saying that for example you've created a cluster model on a set of items, and you want to see the cluster values for items not in the set? And you want the slicing behavior to work against those values as well?

If this is the case, unfortunately, that's not the way it works. The cluster dimension is only on the cases for which it was trained. You could apply the clustering to the data outside the cube, write the results to a table and process it as a regular dimension, though.

|||

Hi,

Ideally yes. For example if I generate a cluster model and train it with a couple of years data, potentially I would then like to use the data mining dimension and cube to predict or classify the current years data. I will look to use your suggestion.

Thanks

Sanjay