Showing posts with label jan. Show all posts
Showing posts with label jan. Show all posts

Thursday, March 22, 2012

Bar chart with row data

Hi,
I have a dataset with values for each month.
For example:
Jan Feb Mar Apr May Jun Jul
1200 1500 1420 1540 1450 1470 1467
I would like to create a Bar chart from this data. Is there a way to supply
the row as a source data? Since my data is in 12 columns, i have to add each
column as a data field to the chart and all bars show up in different colors
because of this.
Is there a way to provide the row a single series?
Thanks,If you have RS 2000 SP1 or SP2 installed, you could set the color to the
same identical value for all values (under appearance - series styles).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Prash" <Prash@.discussions.microsoft.com> wrote in message
news:06121C94-6D66-4BD6-9AFC-CA3E787723C7@.microsoft.com...
> Hi,
> I have a dataset with values for each month.
> For example:
> Jan Feb Mar Apr May Jun Jul
> 1200 1500 1420 1540 1450 1470 1467
> I would like to create a Bar chart from this data. Is there a way to
> supply
> the row as a source data? Since my data is in 12 columns, i have to add
> each
> column as a data field to the chart and all bars show up in different
> colors
> because of this.
> Is there a way to provide the row a single series?
> Thanks,

Saturday, February 25, 2012

backups

database backups and differential backups

i took database back up on 01-jan-2005 and from 2nd jan onwards im taking differential backups. if i want to restore the database to a new system, is it sufficient that i restore the back up which i took on 1st jan , and the most recent differential backup ? will the entire data till the last back up date be restored?From BOL:
The sequence for restoring differential database backups is:

1.Restore the most recent database backup.

2.Restore the last differential database backup.

3.Apply all transaction log backups created after the last differential database backup was created if you use Full or Bulk-Logged Recovery.

yes if u restore to the last differential database backup the database will be recoverd to that point of time.|||I'm 99% sure that you'll need to restore the last full backup, plus each differential backup in sequence in order to get back to the state of the last differential dump you've got. In other words, if you are missing the backup from day 13 out of 30, you can only get to the point of the backup from day 12.

You only explicitly restore the last file, but all of the files need to be present in order for the restore to be successful.

-PatP|||that means if i have 10 differential back ups named 1,2,..10

i'll have to restore the last full back up (on jan 1st) and then restore each of 1,2,3...10 in order. am i correct?

one more question.

BOL (under Differential Database Backups ) says that "A differential database backup records only the data that has changed since the last database backup".

so is it necessary that i restore full backup & differential backups from 1 to 10

i think restoring full back up + differential backup no 10 will give me all the data .. i donno whether im correct..

pl discuss|||You have to restore only the last diff. backup made, not the whole sequence.
See 'Tracking Modified Extents' topic in Books Online for details. mojza