MS SQL Server 2000... Error backing up database

Hi

I am getting an error while backing up a particular database named "asset" . The error says ......

Server: Msg 3132, Level 16, State 1, Line 4
The media set for database 'Asset' has 2 family members but only 1 are provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 4
BACKUP DATABASE is terminating abnormally.

I have created two backup devices for this database ("asset") through enterprise manager.
AssetDMP
AssetLogDMP

I have total 9 databases out of which only this database throws error. All other database backups going fine.

Here is the query that I am using to backup the database and Log.

USE master
GO
IF EXISTS (SELECT * FROM sysdatabases WHERE name = 'Asset')
BACKUP DATABASE Asset TO AssetDMP WITH NOUNLOAD, STATS=10, INIT, SKIP
GO
IF EXISTS (SELECT * FROM sysdatabases WHERE name = 'Asset')
BACKUP LOG Asset TO AssetLogDMP WITH NOUNLOAD, STATS=10, INIT, SKIP

Please Help

Thank You / SsgThis error occurs if a member of the stripe set (the backup was performed to more than 1 backup file/device) that was originally used to create the backup, was not selected when you tried to perform the restore. The number that displays in the message shows the set or file number that is missing.

You need to provide all the backup devices, files in your restore command|||Originally posted by Satya
This error occurs if a member of the stripe set (the backup was performed to more than 1 backup file/device) that was originally used to create the backup, was not selected when you tried to perform the restore. The number that displays in the message shows the set or file number that is missing.

You need to provide all the backup devices, files in your restore command

Dear Satya,

Thanks a lot for your quick response. This issue has been resolved by re creating the devices ; but somehow I could not understand the root cause of the problem ;). Anyway, I wanted to ask one more question here...

I am using MS SQL 2000 Server. Can I move the dabases ( Master, Model , MSDB and tempdb) to a different drive location without re-installing SQL Server !!!

Waiting for an early reply...

Thanks again,
Ssg|||Here you go with this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071) .|||BTW where abouts you're in Bangalore??|||Originally posted by Satya
BTW where abouts you're in Bangalore??

Thanks Satya,

My Question has been answered. Great help !!!

I am in ShanthiNagar , Bangalore -27

R U Familiar with BLR ?? I mean r u a bangalorean ?

Tks / Ssg|||Glad this works... I sent you private message as its ideal for personal chat.|||Originally posted by Satya
Glad this works... I sent you private message as its ideal for personal chat.

satya,

I don't find any private mesg.. It shows empty..however you can mail me.

Thanks
Ssg|||My PM tracking confirms an email sent to you about this Private message, check the email when you registered to this site.

MS SQL EM DB properties vs sp_spaceused

Hello everyone,
I am confused with the output of the DB properties page on Enterprise
Manager versus that of sp_spaceused for a particular database. I
can't understand how Enterprise Manager calculate for the Space
Available and can't correlate the value with what I am getting from
sp_spaceused.
Can anyone enlighten me on this?
Thanks.
AramidOne thing to remember is that sp_spaceused includes the size of the transact
ion log file when it
calculates at the database level. Not something you normally want. Apart fro
m that, make sure you
understand the extent concept so you understand difference between used rese
rved etc. That is a
prereq for understanding space usage information in SQL server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:in4ta1tem4954a6cg9prr4dlu19ejiqqs7@.
4ax.c
om...
> Hello everyone,
> I am confused with the output of the DB properties page on Enterprise
> Manager versus that of sp_spaceused for a particular database. I
> can't understand how Enterprise Manager calculate for the Space
> Available and can't correlate the value with what I am getting from
> sp_spaceused.
> Can anyone enlighten me on this?
> Thanks.
> Aramid

MS SQL EM DB properties vs sp_spaceused

Hello everyone,
I am confused with the output of the DB properties page on Enterprise
Manager versus that of sp_spaceused for a particular database. I
can't understand how Enterprise Manager calculate for the Space
Available and can't correlate the value with what I am getting from
sp_spaceused.
Can anyone enlighten me on this?
Thanks.
AramidOne thing to remember is that sp_spaceused includes the size of the transaction log file when it
calculates at the database level. Not something you normally want. Apart from that, make sure you
understand the extent concept so you understand difference between used reserved etc. That is a
prereq for understanding space usage information in SQL server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:in4ta1tem4954a6cg9prr4dlu19ejiqqs7@.4ax.com...
> Hello everyone,
> I am confused with the output of the DB properties page on Enterprise
> Manager versus that of sp_spaceused for a particular database. I
> can't understand how Enterprise Manager calculate for the Space
> Available and can't correlate the value with what I am getting from
> sp_spaceused.
> Can anyone enlighten me on this?
> Thanks.
> Aramid

MS SQL EM DB properties vs sp_spaceused

Hello everyone,
I am confused with the output of the DB properties page on Enterprise
Manager versus that of sp_spaceused for a particular database. I
can't understand how Enterprise Manager calculate for the Space
Available and can't correlate the value with what I am getting from
sp_spaceused.
Can anyone enlighten me on this?
Thanks.
Aramid
One thing to remember is that sp_spaceused includes the size of the transaction log file when it
calculates at the database level. Not something you normally want. Apart from that, make sure you
understand the extent concept so you understand difference between used reserved etc. That is a
prereq for understanding space usage information in SQL server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:in4ta1tem4954a6cg9prr4dlu19ejiqqs7@.4ax.com...
> Hello everyone,
> I am confused with the output of the DB properties page on Enterprise
> Manager versus that of sp_spaceused for a particular database. I
> can't understand how Enterprise Manager calculate for the Space
> Available and can't correlate the value with what I am getting from
> sp_spaceused.
> Can anyone enlighten me on this?
> Thanks.
> Aramid

ms sql 7, tracking changes

Hi,
windows 2000 server
ms sql server 7
I am trying to track changes in the "options" tab in a particular database.
Specifically, I want to see when the "truncate log on checkpoint" was
checked. Are these changes logged anywhere?
Thank you,
kak37
Possibly in the errorlog and EventLog. OR, you can have a Profiler trace running to capture the
changes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"kak37" <kak37@.discussions.microsoft.com> wrote in message
news:F2CEE76C-1ECB-4933-B5F7-44A34D76B585@.microsoft.com...
> Hi,
> windows 2000 server
> ms sql server 7
> I am trying to track changes in the "options" tab in a particular database.
> Specifically, I want to see when the "truncate log on checkpoint" was
> checked. Are these changes logged anywhere?
> Thank you,
> kak37

ms sql 7, tracking changes

Hi,
windows 2000 server
ms sql server 7
I am trying to track changes in the "options" tab in a particular database.
Specifically, I want to see when the "truncate log on checkpoint" was
checked. Are these changes logged anywhere?
Thank you,
kak37Possibly in the errorlog and EventLog. OR, you can have a Profiler trace run
ning to capture the
changes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"kak37" <kak37@.discussions.microsoft.com> wrote in message
news:F2CEE76C-1ECB-4933-B5F7-44A34D76B585@.microsoft.com...
> Hi,
> Windows 2000 server
> ms sql server 7
> I am trying to track changes in the "options" tab in a particular database
.
> Specifically, I want to see when the "truncate log on checkpoint" was
> checked. Are these changes logged anywhere?
> Thank you,
> kak37

ms sql 7, tracking changes

Hi,
windows 2000 server
ms sql server 7
I am trying to track changes in the "options" tab in a particular database.
Specifically, I want to see when the "truncate log on checkpoint" was
checked. Are these changes logged anywhere?
Thank you,
kak37Possibly in the errorlog and EventLog. OR, you can have a Profiler trace running to capture the
changes.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"kak37" <kak37@.discussions.microsoft.com> wrote in message
news:F2CEE76C-1ECB-4933-B5F7-44A34D76B585@.microsoft.com...
> Hi,
> windows 2000 server
> ms sql server 7
> I am trying to track changes in the "options" tab in a particular database.
> Specifically, I want to see when the "truncate log on checkpoint" was
> checked. Are these changes logged anywhere?
> Thank you,
> kak37