Showing posts with label reinstall. Show all posts
Showing posts with label reinstall. Show all posts

Wednesday, March 28, 2012

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?

Monday, March 26, 2012

problem reinstalling SQL Server 2005 Beta2

I am testing SQL Server 2005. I tried to uninstall Beta2 and ended up having
issues. Now, I cannot get the setup to run to do reinstall. Okay, the
uninstall didn't work. How can I get machine XP Pro cleaned Up and get the
product reinstall? Do I have to reinstall the OS and Reformat my disk drive?
Is there a tool that I can used to get going again?
Thanks,
Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Orville" <Orville@.discussions.microsoft.com> wrote in message
news:1BE768DE-CC3F-4820-870C-1CD7B3A98AF5@.microsoft.com...
> I am testing SQL Server 2005. I tried to uninstall Beta2 and ended up
having
> issues. Now, I cannot get the setup to run to do reinstall. Okay, the
> uninstall didn't work. How can I get machine XP Pro cleaned Up and get the
> product reinstall? Do I have to reinstall the OS and Reformat my disk
drive?
> Is there a tool that I can used to get going again?
> Thanks,

problem reinstalling SQL Server 2005 Beta2

I am testing SQL Server 2005. I tried to uninstall Beta2 and ended up having
issues. Now, I cannot get the setup to run to do reinstall. Okay, the
uninstall didn't work. How can I get machine XP Pro cleaned Up and get the
product reinstall? Do I have to reinstall the OS and Reformat my disk drive?
Is there a tool that I can used to get going again?
Thanks,Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Orville" <Orville@.discussions.microsoft.com> wrote in message
news:1BE768DE-CC3F-4820-870C-1CD7B3A98AF5@.microsoft.com...
> I am testing SQL Server 2005. I tried to uninstall Beta2 and ended up
having
> issues. Now, I cannot get the setup to run to do reinstall. Okay, the
> uninstall didn't work. How can I get machine XP Pro cleaned Up and get the
> product reinstall? Do I have to reinstall the OS and Reformat my disk
drive?
> Is there a tool that I can used to get going again?
> Thanks,

problem reinstalling SQL Server 2005 Beta2

I am testing SQL Server 2005. I tried to uninstall Beta2 and ended up having
issues. Now, I cannot get the setup to run to do reinstall. Okay, the
uninstall didn't work. How can I get machine XP Pro cleaned Up and get the
product reinstall? Do I have to reinstall the OS and Reformat my disk drive?
Is there a tool that I can used to get going again?
Thanks,Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Orville" <Orville@.discussions.microsoft.com> wrote in message
news:1BE768DE-CC3F-4820-870C-1CD7B3A98AF5@.microsoft.com...
> I am testing SQL Server 2005. I tried to uninstall Beta2 and ended up
having
> issues. Now, I cannot get the setup to run to do reinstall. Okay, the
> uninstall didn't work. How can I get machine XP Pro cleaned Up and get the
> product reinstall? Do I have to reinstall the OS and Reformat my disk
drive?
> Is there a tool that I can used to get going again?
> Thanks,

Saturday, February 25, 2012

problem installing msde

after uninstalling my msde now i am not able to reinstall it. In logfile message in "failed due to stop my service of control manager".
i couldnot understand it means.
plz help.that doesn't sound like an MS error message to me. please provide the error messageexactly, word for word (makes searching easier)