Read DESCRIPTION from a backuped DB file in .Net

Hi,
How can I read the "Description" field from a backuped DB (file) in .Net?
Some ideas?
Thanks,
George.What version are you using?
Where does the "Description"column exist?
If you are using SQL Server 2005 see sys.database_files table
There is state_desc column.
"George Homorozeanu" <george_homorozeanu@.hotmail.com> wrote in message
news:u9E2vXRQGHA.740@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can I read the "Description" field from a backuped DB (file) in .Net?
> Some ideas?
> Thanks,
> George.
>|||I am using SQL Server 2000 and I want to be able to read the descriprion
text entered for the DESCRIPTION option when backing up a database.
Example:
BACKUP DATABASE atsTables
TO DISK = 'c:\temp\20060306_1245_atsTables.dat'
WITH
DESCRIPTION = 'atsTables Backup1'
I want to build a simple application where the user can select a file
(backedup db file) and the application shows in a textbox the description
text ('atsTables Backup1' from the above example). Is this possible?
Thanks,
George.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:%23buDpeRQGHA.1096@.TK2MSFTNGP11.phx.gbl...
> What version are you using?
> Where does the "Description"column exist?
> If you are using SQL Server 2005 see sys.database_files table
> There is state_desc column.
>
>
>
> "George Homorozeanu" <george_homorozeanu@.hotmail.com> wrote in message
> news:u9E2vXRQGHA.740@.TK2MSFTNGP12.phx.gbl...
>|||Lookup backupmediaset system table in the BOL
"George Homorozeanu" <george_homorozeanu@.hotmail.com> wrote in message
news:OGFY%23lRQGHA.1688@.TK2MSFTNGP11.phx.gbl...
>I am using SQL Server 2000 and I want to be able to read the descriprion
>text entered for the DESCRIPTION option when backing up a database.
> Example:
> BACKUP DATABASE atsTables
> TO DISK = 'c:\temp\20060306_1245_atsTables.dat'
> WITH
> DESCRIPTION = 'atsTables Backup1'
>
> I want to build a simple application where the user can select a file
> (backedup db file) and the application shows in a textbox the description
> text ('atsTables Backup1' from the above example). Is this possible?
> Thanks,
> George.
> "Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
> news:%23buDpeRQGHA.1096@.TK2MSFTNGP11.phx.gbl...
>|||You mean the information returned from RESTORE HEADERONLY? Sure, just execut
e that SQL command and
treat the result as any result from a SELECT statement.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"George Homorozeanu" <george_homorozeanu@.hotmail.com> wrote in message
news:u9E2vXRQGHA.740@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can I read the "Description" field from a backuped DB (file) in .Net?
Some ideas?
> Thanks,
> George.
>|||Yes Tibor that's what I needed.
Thanks for help guys
George.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:eO$ckrRQGHA.3984@.TK2MSFTNGP14.phx.gbl...
> You mean the information returned from RESTORE HEADERONLY? Sure, just
> execute that SQL command and treat the result as any result from a SELECT
> statement.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "George Homorozeanu" <george_homorozeanu@.hotmail.com> wrote in message
> news:u9E2vXRQGHA.740@.TK2MSFTNGP12.phx.gbl...
>sql