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?
Showing posts with label reinstall. Show all posts
Showing posts with label reinstall. Show all posts
Wednesday, March 28, 2012
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,
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,
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,
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)
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)
Subscribe to:
Posts (Atom)