difference between filesize in Backupfile and backupset

Can anyone tell me the difference between the filesize values being logged
in the Backupfile and Backupset tables in the msdb database.
I am a little confused as the data for the backup on a same day registers
different file sizes. Also can anyone give me a little more idea on what
each of these tables are being used for.
Thanks
Hi
In BackupSet, there is a column 'backupsize'. This value isthe size, in
bytes, of the backup dumped to tape/disk.
In BackupFile, there is a column 'filesize'. This is the actual size of the
device files that are currently configured for the DB, that have been backed
up in the BackupSet..
Definitions from systbl.chm:
backupfile
Contains one row for each data or log file that is backed up. This table is
stored in the msdb database.
backupset
Contains a row for each backup set. This table is stored in the msdb database.
Regards
Mike
"Rahul Chatterjee" wrote:

> Can anyone tell me the difference between the filesize values being logged
> in the Backupfile and Backupset tables in the msdb database.
> I am a little confused as the data for the backup on a same day registers
> different file sizes. Also can anyone give me a little more idea on what
> each of these tables are being used for.
> Thanks
>
>

difference between filesize in Backupfile and backupset

Can anyone tell me the difference between the filesize values being logged
in the Backupfile and Backupset tables in the msdb database.
I am a little confused as the data for the backup on a same day registers
different file sizes. Also can anyone give me a little more idea on what
each of these tables are being used for.
ThanksHi
In BackupSet, there is a column 'backupsize'. This value isthe size, in
bytes, of the backup dumped to tape/disk.
In BackupFile, there is a column 'filesize'. This is the actual size of the
device files that are currently configured for the DB, that have been backed
up in the BackupSet..
Definitions from systbl.chm:
backupfile
Contains one row for each data or log file that is backed up. This table is
stored in the msdb database.
backupset
Contains a row for each backup set. This table is stored in the msdb database.
Regards
Mike
"Rahul Chatterjee" wrote:
> Can anyone tell me the difference between the filesize values being logged
> in the Backupfile and Backupset tables in the msdb database.
> I am a little confused as the data for the backup on a same day registers
> different file sizes. Also can anyone give me a little more idea on what
> each of these tables are being used for.
> Thanks
>
>

difference between filesize in Backupfile and backupset

Can anyone tell me the difference between the filesize values being logged
in the Backupfile and Backupset tables in the msdb database.
I am a little confused as the data for the backup on a same day registers
different file sizes. Also can anyone give me a little more idea on what
each of these tables are being used for.
ThanksHi
In BackupSet, there is a column 'backupsize'. This value isthe size, in
bytes, of the backup dumped to tape/disk.
In BackupFile, there is a column 'filesize'. This is the actual size of the
device files that are currently configured for the DB, that have been backed
up in the BackupSet..
Definitions from systbl.chm:
backupfile
Contains one row for each data or log file that is backed up. This table is
stored in the msdb database.
backupset
Contains a row for each backup set. This table is stored in the msdb databas
e.
Regards
Mike
"Rahul Chatterjee" wrote:

> Can anyone tell me the difference between the filesize values being logged
> in the Backupfile and Backupset tables in the msdb database.
> I am a little confused as the data for the backup on a same day registers
> different file sizes. Also can anyone give me a little more idea on what
> each of these tables are being used for.
> Thanks
>
>

Diagram, sorting and series groups

Say you have two values for each region: current month and previous month. I
have a column in datase called period_offset (0 for current month and -1 for
previous month).
I want to sort the diagram over current month, where previous month is just
for informational purposes (previous month is also colored gray, btw).
For series group, I have =Fields!period_offset.Value, and under sorting:
=Fields!period_offset.Value.
Currently, the diagram seem to sort by the previous month value (where
=Fields!period_offset.Value = -1). How can I sort by current month
(=Fields!period_offset.Value = 0) ?
Thanks
TiborWhere I say "Diagram", I'm referring to the chart control, btw.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> Say you have two values for each region: current month and previous month.
I
> have a column in datase called period_offset (0 for current month and -1
for
> previous month).
> I want to sort the diagram over current month, where previous month is
just
> for informational purposes (previous month is also colored gray, btw).
> For series group, I have =Fields!period_offset.Value, and under sorting:
> =Fields!period_offset.Value.
> Currently, the diagram seem to sort by the previous month value (where
> =Fields!period_offset.Value = -1). How can I sort by current month
> (=Fields!period_offset.Value = 0) ?
> Thanks
> Tibor
>|||It seems like the order for the rows are determined from the order returned
in the SQL Query. When I add an ORDER BY to the query so that for each
region, that current month is returned before last month, the diagram is
sorted over the current month column.
I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram changes
accordingly...
Is above assumption correct?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> Where I say "Diagram", I'm referring to the chart control, btw.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> > Say you have two values for each region: current month and previous
month.
> I
> > have a column in datase called period_offset (0 for current month and -1
> for
> > previous month).
> >
> > I want to sort the diagram over current month, where previous month is
> just
> > for informational purposes (previous month is also colored gray, btw).
> >
> > For series group, I have =Fields!period_offset.Value, and under sorting:
> > =Fields!period_offset.Value.
> >
> > Currently, the diagram seem to sort by the previous month value (where
> > =Fields!period_offset.Value = -1). How can I sort by current month
> > (=Fields!period_offset.Value = 0) ?
> >
> > Thanks
> > Tibor
> >
> >
>|||Unless you define an explicit sort expression on the chart series grouping
or the chart or the dataset, the data will be processed and grouped in RS in
the order they come from the data provider.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
> It seems like the order for the rows are determined from the order
returned
> in the SQL Query. When I add an ORDER BY to the query so that for each
> region, that current month is returned before last month, the diagram is
> sorted over the current month column.
> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
changes
> accordingly...
> Is above assumption correct?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> > Where I say "Diagram", I'm referring to the chart control, btw.
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> > > Say you have two values for each region: current month and previous
> month.
> > I
> > > have a column in datase called period_offset (0 for current month
and -1
> > for
> > > previous month).
> > >
> > > I want to sort the diagram over current month, where previous month is
> > just
> > > for informational purposes (previous month is also colored gray, btw).
> > >
> > > For series group, I have =Fields!period_offset.Value, and under
sorting:
> > > =Fields!period_offset.Value.
> > >
> > > Currently, the diagram seem to sort by the previous month value (where
> > > =Fields!period_offset.Value = -1). How can I sort by current month
> > > (=Fields!period_offset.Value = 0) ?
> > >
> > > Thanks
> > > Tibor
> > >
> > >
> >
> >
>|||Thanks Robert. This is in line with what I have experienced.
In this particular situation, I just couldn't get RS to sort the way I wanted...
But I did manage when combining sorting on Group/Series and in the SQL query. I'll probably stick
with what I have until I have the time to learn enough about sorting and the relation between
sorting in grouping vs. series.
I found the documentation lacking information rather severely in this area, I should add. And it
just wasn't intuitive enough for me. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23u3BxyzmEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Unless you define an explicit sort expression on the chart series grouping
> or the chart or the dataset, the data will be processed and grouped in RS in
> the order they come from the data provider.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> It seems like the order for the rows are determined from the order
> returned
>> in the SQL Query. When I add an ORDER BY to the query so that for each
>> region, that current month is returned before last month, the diagram is
>> sorted over the current month column.
>> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
> changes
>> accordingly...
>> Is above assumption correct?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
>> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
>> > Where I say "Diagram", I'm referring to the chart control, btw.
>> >
>> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
>> > > Say you have two values for each region: current month and previous
>> month.
>> > I
>> > > have a column in datase called period_offset (0 for current month
> and -1
>> > for
>> > > previous month).
>> > >
>> > > I want to sort the diagram over current month, where previous month is
>> > just
>> > > for informational purposes (previous month is also colored gray, btw).
>> > >
>> > > For series group, I have =Fields!period_offset.Value, and under
> sorting:
>> > > =Fields!period_offset.Value.
>> > >
>> > > Currently, the diagram seem to sort by the previous month value (where
>> > > =Fields!period_offset.Value = -1). How can I sort by current month
>> > > (=Fields!period_offset.Value = 0) ?
>> > >
>> > > Thanks
>> > > Tibor
>> > >
>> > >
>> >
>> >
>>
>|||Regarding BOL:
Yes, our UE/documentation team is working on improving the entire charting
documentation. Updates should be available on MSDN in the next few months.
Regarding sorting:
Grouping/sorting specified in the commandtext is done on the data source's
database server. Grouping/sorting/filtering defined in the RDL is done in
the RS processing engine internally.
If you specify a sort expression on group expressions in the report, the
processing engine will apply sorting. I.e. if you don't specify any explicit
collation settings on the RDL dataset, we will - in case of a live execution
against a SQL 2000 data source - determine the collation settings from the
data source. Otherwise, we will do sorting based on the culture settings of
the report.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3fKkA1mEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Thanks Robert. This is in line with what I have experienced.
> In this particular situation, I just couldn't get RS to sort the way I
wanted...
> But I did manage when combining sorting on Group/Series and in the SQL
query. I'll probably stick
> with what I have until I have the time to learn enough about sorting and
the relation between
> sorting in grouping vs. series.
> I found the documentation lacking information rather severely in this
area, I should add. And it
> just wasn't intuitive enough for me. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23u3BxyzmEHA.2140@.TK2MSFTNGP11.phx.gbl...
> > Unless you define an explicit sort expression on the chart series
grouping
> > or the chart or the dataset, the data will be processed and grouped in
RS in
> > the order they come from the data provider.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
> >> It seems like the order for the rows are determined from the order
> > returned
> >> in the SQL Query. When I add an ORDER BY to the query so that for each
> >> region, that current month is returned before last month, the diagram
is
> >> sorted over the current month column.
> >>
> >> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
> > changes
> >> accordingly...
> >>
> >> Is above assumption correct?
> >>
> >>
> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> > in
> >> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> >> > Where I say "Diagram", I'm referring to the chart control, btw.
> >> >
> >> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> >> in
> >> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> >> > > Say you have two values for each region: current month and previous
> >> month.
> >> > I
> >> > > have a column in datase called period_offset (0 for current month
> > and -1
> >> > for
> >> > > previous month).
> >> > >
> >> > > I want to sort the diagram over current month, where previous month
is
> >> > just
> >> > > for informational purposes (previous month is also colored gray,
btw).
> >> > >
> >> > > For series group, I have =Fields!period_offset.Value, and under
> > sorting:
> >> > > =Fields!period_offset.Value.
> >> > >
> >> > > Currently, the diagram seem to sort by the previous month value
(where
> >> > > =Fields!period_offset.Value = -1). How can I sort by current month
> >> > > (=Fields!period_offset.Value = 0) ?
> >> > >
> >> > > Thanks
> >> > > Tibor
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
>

device_type = 7 in backupmediafamily?

Does anyone know what device_type = 7 means in the
msdb..backupmediafamily table? The physical_device_name values are
strange (i.e., "model_00__9834ee39_40a6_4d36_9ba6_a65daaac40b9_") .
Records for backups that I've initiated have device_type = 2 or 102
and the physical_device_name is the disk path of the backup file.
The SQL documentation shows six valid values for device_type: 2 or 102
= disk, 5 or 105 = tape, 6 or 106 = pipe.
Any insight is greatly appreciated.
TIA,
Doug
Looks like a virtual_device used to create backups using the VBDI API. The
Veritas SQL Server client uses this among others.
Sincerely,
Anthony Thomas
"Doug" wrote:

> Does anyone know what device_type = 7 means in the
> msdb..backupmediafamily table? The physical_device_name values are
> strange (i.e., "model_00__9834ee39_40a6_4d36_9ba6_a65daaac40b9_") .
> Records for backups that I've initiated have device_type = 2 or 102
> and the physical_device_name is the disk path of the backup file.
> The SQL documentation shows six valid values for device_type: 2 or 102
> = disk, 5 or 105 = tape, 6 or 106 = pipe.
> Any insight is greatly appreciated.
> TIA,
> Doug
>

device_type = 7 in backupmediafamily?

Does anyone know what device_type = 7 means in the
msdb..backupmediafamily table? The physical_device_name values are
strange (i.e., " model_00__9834ee39_40a6_4d36_9ba6_a65daa
ac40b9_").
Records for backups that I've initiated have device_type = 2 or 102
and the physical_device_name is the disk path of the backup file.
The SQL documentation shows six valid values for device_type: 2 or 102
= disk, 5 or 105 = tape, 6 or 106 = pipe.
Any insight is greatly appreciated.
TIA,
DougLooks like a virtual_device used to create backups using the VBDI API. The
Veritas SQL Server client uses this among others.
Sincerely,
Anthony Thomas
"Doug" wrote:

> Does anyone know what device_type = 7 means in the
> msdb..backupmediafamily table? The physical_device_name values are
> strange (i.e., " model_00__9834ee39_40a6_4d36_9ba6_a65daa
ac40b9_").
> Records for backups that I've initiated have device_type = 2 or 102
> and the physical_device_name is the disk path of the backup file.
> The SQL documentation shows six valid values for device_type: 2 or 102
> = disk, 5 or 105 = tape, 6 or 106 = pipe.
> Any insight is greatly appreciated.
> TIA,
> Doug
>

device_type = 7 in backupmediafamily?

Does anyone know what device_type = 7 means in the
msdb..backupmediafamily table? The physical_device_name values are
strange (i.e., "model_00__9834ee39_40a6_4d36_9ba6_a65daaac40b9_").
Records for backups that I've initiated have device_type = 2 or 102
and the physical_device_name is the disk path of the backup file.
The SQL documentation shows six valid values for device_type: 2 or 102
= disk, 5 or 105 = tape, 6 or 106 = pipe.
Any insight is greatly appreciated.
TIA,
DougLooks like a virtual_device used to create backups using the VBDI API. The
Veritas SQL Server client uses this among others.
Sincerely,
Anthony Thomas
"Doug" wrote:
> Does anyone know what device_type = 7 means in the
> msdb..backupmediafamily table? The physical_device_name values are
> strange (i.e., "model_00__9834ee39_40a6_4d36_9ba6_a65daaac40b9_").
> Records for backups that I've initiated have device_type = 2 or 102
> and the physical_device_name is the disk path of the backup file.
> The SQL documentation shows six valid values for device_type: 2 or 102
> = disk, 5 or 105 = tape, 6 or 106 = pipe.
> Any insight is greatly appreciated.
> TIA,
> Doug
>