Problem restoring backup

I am running SQL 7...

I had a database on a Sql Server on a WinXP machine but I needed to reinstall that machine and I installed Win2k...

Before I format the machine I have made a backup from my database. Now, on the Win2k, I cant restore this backup. Sql Server shows the following error message:

The volume on device 'c:\backup.bak' is not a member of the media family.

Plz, help me on this... I dont know much about Sqlserver and this is the ONLY backup I have... The backup file seems fine... There was no errors during the backup proccess...

If u dont know whats happening, could u tell if exists some program that can read the backup file and extracts its data to another format?What I do is...
i create a backup device that is the same name as the old backup.
i then put the backup file where u set up the backup device to be. at this point the server should see it and use it as a lagit device
Jim

Originally posted by trojahn
I am running SQL 7...

I had a database on a Sql Server on a WinXP machine but I needed to reinstall that machine and I installed Win2k...

Before I format the machine I have made a backup from my database. Now, on the Win2k, I cant restore this backup. Sql Server shows the following error message:

The volume on device 'c:\backup.bak' is not a member of the media family.

Plz, help me on this... I dont know much about Sqlserver and this is the ONLY backup I have... The backup file seems fine... There was no errors during the backup proccess...

If u dont know whats happening, could u tell if exists some program that can read the backup file and extracts its data to another format?|||JDionne,

I need to ask u for a little more favor... Could u give me more details on how to do that? I really dont know much about Sql Server... I just follow the setup procedure of my so called technical support that now says that I did something wrong...

Edit -=-=-=-=-=-
I just figure out how to do what u said but theres a major problem... I dont know where the backup device was on the first machine... I there a way to figure that out?|||The location of the first back up dosent mater. I would create the backup device in eh mssql\backups directory just to stick to a standard.
Once u have created that device with the same name as the old backup file and move it to that dir, the server will use the file.

the following code will tell u whats in the backup when u go to restore.
run this in query analizer substituting your backup device name

RESTORE FILELISTONLY
FROM [Maersk Data Warehouse Full Backup]

after u know whats in the device u can use the following code to restore it. u will need to change the database name, backup device and mdf,ldf, (and if u have a ndf) file names
the To line indicates wehre u want it to restore to and again i would follow the standard just so u know where they are. If u have any questions just post it and ill see if i can help
Regards Jim

RESTORE DATABASE [Maersk Data Warehouse]
FROM [Maersk Data Warehouse Full Backup]
with recovery
, move 'Maersk Data Warehouse_Data'to 'E:\MSSQL\Data\Maersk Data Warehouse_Data.MDF'
, move 'Maersk Data Warehouse_Log' to 'F:\MSSQL\Data\Maersk Data Warehouse_Log.LDF'
, move 'Maersk Data Warehouse User Tables'to 'E:\MSSQL\Data\Maersk Data Warehouse_Data.NDF'

Originally posted by trojahn
JDionne,

I need to ask u for a little more favor... Could u give me more details on how to do that? I really dont know much about Sql Server... I just follow the setup procedure of my so called technical support that now says that I did something wrong...

Edit -=-=-=-=-=-
I just figure out how to do what u said but theres a major problem... I dont know where the backup device was on the first machine... I there a way to figure that out?

Problem installing SQL2K on WinXP Home

Hello there!

I am trying to install MS SQL 2000 Server on Windows XP Home edition.
I found in Microsoft that the above installation is possible.
But when i run the installation, i am getting a black screen that is
closes after a second. Nothing else happens.
Any ideas how to troubleshoot this?

Thank youLook for a log file named sqlstp.log. This is the log file created during the installation process. There should be some information in that log which might help you.|||Originally posted by rnealejr
Look for a log file named sqlstp.log. This is the log file created during the installation process. There should be some information in that log which might help you.

I searched for the file you are referring but with no success. I cannot find such a file anywhere on my disk.

Any other ideas?!

Thanks for the reply.