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...
>

Media question

Hi Folks..

I have a question i want's to make a website where people can upload media
files like movies short movies of a minut or 3 max. Can i store those media
files like mp3, mpg etc.. for instance in a sql-server database, or is this
not wise to do?

Thanx in advance.."mike" <me2u@.writeme.com> wrote in message
news:40c2e759$0$5167$3a628fcd@.reader1.nntp.hccnet. nl...
> Hi Folks..
> I have a question i want's to make a website where people can upload media
> files like movies short movies of a minut or 3 max. Can i store those
media
> files like mp3, mpg etc.. for instance in a sql-server database, or is
this
> not wise to do?

You're probably better of saving them as files with a link to them stored in
the db.

> Thanx in advance..

Media Family ... Is Incorrectly Formed

I am using SQL Server 2000 SP 3a enterprise. We do a nightly backup to
a
network location and then in the middle of the night the files are
written to
tape from the network. We have verified our backup plan will work by
choosing a backup and restoring it to the database. We have done this
many
times without problems. However, there is a backup that when I try to
restore it I get the Error:
Server: Msg 3241, Level 16, State 37, Line 1 The media family on device
'UNC
Path.bak' is incorrectly formed. SQL Server cannot process this media
family.
I have run the command: RESTORE HEADERONLY FROM DISK='UNC Path.BAK'.
The
backupName from this says *** INCOMPLETE ***; Position = 1; the rest of
the
fields are NULL.
What would happen to make the backup INCOMPLETE? Maybe this would
happen if
an error was encountered part way throught backing up the file? The
file has
almost 800 MB of data in it. I would like to restore this file and get
out a
specific set of records if possible. Even if I can't get everything,
if I
could get at least some of it then that would be better than a complete
loss.
Is there anyway to get the data that is contained in the file back?
Thank you
KalvinHi
A bad backup is a bad backup, not much you can do with it. Maybe opening a
call with Microsoft PSS might help as they may have tools to read partial
backups.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kalvin" wrote:

> I am using SQL Server 2000 SP 3a enterprise. We do a nightly backup to
> a
> network location and then in the middle of the night the files are
> written to
> tape from the network. We have verified our backup plan will work by
> choosing a backup and restoring it to the database. We have done this
> many
> times without problems. However, there is a backup that when I try to
> restore it I get the Error:
> Server: Msg 3241, Level 16, State 37, Line 1 The media family on device
> 'UNC
> Path.bak' is incorrectly formed. SQL Server cannot process this media
> family.
> I have run the command: RESTORE HEADERONLY FROM DISK='UNC Path.BAK'.
> The
> backupName from this says *** INCOMPLETE ***; Position = 1; the rest of
> the
> fields are NULL.
> What would happen to make the backup INCOMPLETE? Maybe this would
> happen if
> an error was encountered part way throught backing up the file? The
> file has
> almost 800 MB of data in it. I would like to restore this file and get
> out a
> specific set of records if possible. Even if I can't get everything,
> if I
> could get at least some of it then that would be better than a complete
> loss.
>
> Is there anyway to get the data that is contained in the file back?
>
> --
> Thank you
> Kalvin
>

Media Center XP OS and SQL 2005 Editions

I am looking into purchasing a new laptop and can not find any information o
n
which editions of SQL 2005 are supported on Media Center O/S. I know that
Express is supported, but was looking to install a beefier version if at all
possible. Can someone enlighten me?
--
I support The Professional Association for SQL Server (PASS). Visit
www.sqlpass.org today![url]http://support.microsoft.com/?scid=kb;en-us;910228&spid=2855&sid=312#E03W0ABAAA[/u
rl]
states that Windows XP Media Edition SP2 supports the 32-bit Developer,
Standard, Workgroup, and Evaluation Editions of SQL Server 2005.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timothy Ford, MCSD" <timmer@.foo.com> wrote in message
news:C19CB88E-45FA-4C02-91FF-3D41F5CA265F@.microsoft.com...
>I am looking into purchasing a new laptop and can not find any information
>on
> which editions of SQL 2005 are supported on Media Center O/S. I know that
> Express is supported, but was looking to install a beefier version if at
> all
> possible. Can someone enlighten me?
> --
> I support The Professional Association for SQL Server (PASS). Visit
> www.sqlpass.org today!|||Thank you Steve.
--
I support The Professional Association for SQL Server (PASS). Visit
www.sqlpass.org today!
"Steve Dybing [MSFT]" wrote:

> [url]http://support.microsoft.com/?scid=kb;en-us;910228&spid=2855&sid=312#E03W0ABAAA[
/url]
> states that Windows XP Media Edition SP2 supports the 32-bit Developer,
> Standard, Workgroup, and Evaluation Editions of SQL Server 2005.
> --
> Sincerely,
> Steve Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Timothy Ford, MCSD" <timmer@.foo.com> wrote in message
> news:C19CB88E-45FA-4C02-91FF-3D41F5CA265F@.microsoft.com...
>
>|||This page in the SQL Server 2005 Books Online also lists the OS versions
supported by SQL Server edition, including Media Center:
http://msdn2.microsoft.com/en-us/library/ms143506(SQL.90).aspx
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter:
http://www.microsoft.com/technet/pr...ql/default.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.

Media Center XP OS and SQL 2005 Editions

I am looking into purchasing a new laptop and can not find any information on
which editions of SQL 2005 are supported on Media Center O/S. I know that
Express is supported, but was looking to install a beefier version if at all
possible. Can someone enlighten me?
--
I support The Professional Association for SQL Server (PASS). Visit
www.sqlpass.org today!http://support.microsoft.com/?scid=kb;en-us;910228&spid=2855&sid=312#E03W0ABAAA
states that Windows XP Media Edition SP2 supports the 32-bit Developer,
Standard, Workgroup, and Evaluation Editions of SQL Server 2005.
--
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timothy Ford, MCSD" <timmer@.foo.com> wrote in message
news:C19CB88E-45FA-4C02-91FF-3D41F5CA265F@.microsoft.com...
>I am looking into purchasing a new laptop and can not find any information
>on
> which editions of SQL 2005 are supported on Media Center O/S. I know that
> Express is supported, but was looking to install a beefier version if at
> all
> possible. Can someone enlighten me?
> --
> I support The Professional Association for SQL Server (PASS). Visit
> www.sqlpass.org today!|||Thank you Steve.
--
I support The Professional Association for SQL Server (PASS). Visit
www.sqlpass.org today!
"Steve Dybing [MSFT]" wrote:
> http://support.microsoft.com/?scid=kb;en-us;910228&spid=2855&sid=312#E03W0ABAAA
> states that Windows XP Media Edition SP2 supports the 32-bit Developer,
> Standard, Workgroup, and Evaluation Editions of SQL Server 2005.
> --
> Sincerely,
> Steve Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Timothy Ford, MCSD" <timmer@.foo.com> wrote in message
> news:C19CB88E-45FA-4C02-91FF-3D41F5CA265F@.microsoft.com...
> >I am looking into purchasing a new laptop and can not find any information
> >on
> > which editions of SQL 2005 are supported on Media Center O/S. I know that
> > Express is supported, but was looking to install a beefier version if at
> > all
> > possible. Can someone enlighten me?
> > --
> > I support The Professional Association for SQL Server (PASS). Visit
> > www.sqlpass.org today!
>
>|||This page in the SQL Server 2005 Books Online also lists the OS versions
supported by SQL Server edition, including Media Center:
http://msdn2.microsoft.com/en-us/library/ms143506(SQL.90).aspx
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter:
http://www.microsoft.com/technet/prodtechnol/sql/default.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.sql

Media Center

Help, I'm trying to burn a CD using Windows Media Player 10. I keep getting the message-interface not registered. I tried to download WMP, and it says it cannot because there is already a more recent version already installed. Should I uninstall WMP, and then reinstall it. If so, how do i do that, I cannot find it on the control panel!

Thank You for your help

Amanda,

You might find one of these newsgroups/forums better equipped to answer you problem.

http://www.microsoft.com/windowsxp/expertzone/newsgroups/reader.mspx?dg=microsoft.public.windowsmedia&lang=en&cr=US

http://www.microsoft.com/windows/windowsmedia/support.aspx

You might also find the solution by searching groups.google.com with search terms of "windows media player" and then any error messages you are getting.

Larry Pope