Reinstalling sql 2005

please ... really need some guidance...
I have removed the old and reinstalled SQL server 2005 standard...
Getting the following message:
Your OS doesn't meet Service pack levels requirements
for this SQL server releaseSo I installed Microsoft SQL Server 2005 Service Pack 1 (SP1)
Getting the following message: This machine does not have a product that matches this installation package.

I have Windows XP Professional 2002 32-bit (Dell), Windows XP Service Pack 2, IIS, NET Framework 2.0., 13GB , processor intel 1,5 GHz, 256MB RAM

1. What is the SKU of SQL Server 2005 are you installing? On Windows XP SP2, SQL Server Enterprise edition cannot be installed.

2. SP1 cannot be installed directly except SQL Express, which is rebuilt in SP1. SP1 should be applied after RTM is installed.

|||

I posted this question to your other thread, but I'll post it here as well to try to get you going again. The error you are getting is a result of trying to instal a version of SQL 2005 on an OS that does not contain the appropriate OS SP, not a SQL service pack. If you can supply us with the exact OS & service pack level and the version of SQL you are trying to install, we can help out.

I'm a little confused on your OS. Can you do start -> Run and type in "winver". This will tell you your OS and SP level. Can you let me know what that shows? That way we'll be able to figure out what you need to install to get going.

Thanks,
Sam

|||Thank you so much! Actually I need SQL standard or develope, but it didn't work yet. So the trial version will not work, or?
Windows XP Professional
Version 5.1 (Build 2600.xpsp_sp2_gdr.050301-1519: Service Pack 2)
(Windows XP Professional version 2002 32-bit, Windows XP
Service Pack 2, IIS, .NET Framework 2.0., 13GB free space,
processor intel 1,5 GHz, 256MB RAM)

Reinstalling DB Server - Backup/Restore Help

Hi,
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>

Reinstalling DB Server - Backup/Restore Help

Hi,
Seems my old thread doesnt have any response anymore.
reposting it again with only relavent info..
For some reasons I need to reinstall my Production SQL
Server 2000 Database Server from OS level and infact
recreating arrays etc.
My point of Intrest is How to plan the backup of databases
from existing server to restore them after reinstallation.
1. Can I just create the .BAK files of user/system
databases copy it to other server and restore it on
freshly installed server.
or
2. I detach the user/system databases.. copy the .mdf
& .ldf files to other server and restore it on freshly
installed server using attach db sp.
In both cases what is the difference and what are the
advantages and disadvantages? and which one is followed in
practice?
Also, the server on which I am going to backup database
has SP3a for SQL Server.
Do I first need to up to date the SP's(2,3a) for SQL
server on fresh Installation then restore the Databases or
Vice-versa? (keeping in mind I want to restore the
master,msdb backups). Also does restoring masterdb backup
on fresh Installation makes any sense?
Thanks In advance for all the patience and replies.
Sincere Regards
ChipCheck these out:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
Andrew J. Kelly
SQL Server MVP
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:d32b01c3ef36$ab9d21a0$a001280a@.phx.gbl...
> Hi,
> Seems my old thread doesnt have any response anymore.
> reposting it again with only relavent info..
> For some reasons I need to reinstall my Production SQL
> Server 2000 Database Server from OS level and infact
> recreating arrays etc.
> My point of Intrest is How to plan the backup of databases
> from existing server to restore them after reinstallation.
> 1. Can I just create the .BAK files of user/system
> databases copy it to other server and restore it on
> freshly installed server.
> or
> 2. I detach the user/system databases.. copy the .mdf
> & .ldf files to other server and restore it on freshly
> installed server using attach db sp.
> In both cases what is the difference and what are the
> advantages and disadvantages? and which one is followed in
> practice?
> Also, the server on which I am going to backup database
> has SP3a for SQL Server.
> Do I first need to up to date the SP's(2,3a) for SQL
> server on fresh Installation then restore the Databases or
> Vice-versa? (keeping in mind I want to restore the
> master,msdb backups). Also does restoring masterdb backup
> on fresh Installation makes any sense?
> Thanks In advance for all the patience and replies.
> Sincere Regards
> Chip
>