Restore Deleted Instance of SQL 2000

We had a server with SQL 2000 on it. It had two instances. Worked
great.
We decided to upgrade to SQL 2005. We ran the upgrade on the default
instance. Everything was great.
Before we upgraded the second instance, someone went into 'add remove
programs' and removed the second instance of SQL 2000. Can I get it
back?
I created a second instance in SQL 2005 and attached the single
important DB from that second instance of SQL 2000 and the data is all
there, but we are having connection issues. I'm afraid it may be
because we deleted the second instance of SQL 2000 before we got a
chance to upgrade.
Any ideas?
-BDOn Nov 2, 3:16 am, i...@.clowwater.com wrote:
> We had a server with SQL 2000 on it. It had two instances. Worked
> great.
> We decided to upgrade to SQL 2005. We ran the upgrade on the default
> instance. Everything was great.
> Before we upgraded the second instance, someone went into 'add remove
> programs' and removed the second instance of SQL 2000. Can I get it
> back?
> I created a second instance in SQL 2005 and attached the single
> important DB from that second instance of SQL 2000 and the data is all
> there, but we are having connection issues. I'm afraid it may be
> because we deleted the second instance of SQL 2000 before we got a
> chance to upgrade.
> Any ideas?
> -BD
I don't think that this has something to do with the fact that the
second instance was deleted. Can you post more details? What is the
error that you get? Do you get it each time that you try to connect
to the server? Do you also get it if you try to connect to the SQL
Server from the server it self?
Adi

Restore 2005 SQL DB to SQL 2005

Support,

I have a client that recently purchased the SBS 2003 Premium upgrade so that they would have SQL Server 2005 installed for use. They had a gentleman create a DB for them using SQL 2005 Developers Edition. When I try to restore the backup that he created it gives me the following error message:

Error 3169 :
The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.

After doing several searches around the internet and on Microsofts Support site I see many people who are having this issue trying to restore SQL 2005 DB to SQL 2000, but my issue is not with SQL 2000.

Here are the versions of the SQL 2005 installed on the server:

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

Can someone please help?

Those are the version for your tools. Log onto the SQL Server box and in Management Studio, execute:

select @.@.version

That will give you the version of the database engine. It looks like the tools are SQL Server 2005 but that the engine is SQL Server 2000, SP 4.

-Sue

|||

Yes, 539 was the latest interal version of the datafile strcuture for SQL Server 2000. 611 is the new internal version which came up with SQL Server 2005. If you are getting an error message like this you ARE connecting to a server which only supports 539, so it HAS to be a pre-SQL Server 2005.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Why is it that our database engine would be SQL 2000 SP4, when we just purchased the SBS 2003 Premium Upgrade which comes with SQL 2005.

Also can you please give me the info on upgrading the database engine to SQL 2005, so that I can restore the database backup that the SQL guru has created for our client.

Please help....I am really needing this information so that we can continue forward and begin using this database.

Thanks

|||Hi Aaoron,
As already requested by Sue and Jens can you pls confirm if the db engine pre-sql 2005 ? if yes and if you have a backup of all the dbs you can uninstall it and install sql 2005 and restore the dbs from the backup...............

Restore 2005 SQL DB to SQL 2005

Support,

I have a client that recently purchased the SBS 2003 Premium upgrade so that they would have SQL Server 2005 installed for use. They had a gentleman create a DB for them using SQL 2005 Developers Edition. When I try to restore the backup that he created it gives me the following error message:

Error 3169 :
The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.

After doing several searches around the internet and on Microsofts Support site I see many people who are having this issue trying to restore SQL 2005 DB to SQL 2000, but my issue is not with SQL 2000.

Here are the versions of the SQL 2005 installed on the server:

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

Can someone please help?

Those are the version for your tools. Log onto the SQL Server box and in Management Studio, execute:

select @.@.version

That will give you the version of the database engine. It looks like the tools are SQL Server 2005 but that the engine is SQL Server 2000, SP 4.

-Sue

|||

Yes, 539 was the latest interal version of the datafile strcuture for SQL Server 2000. 611 is the new internal version which came up with SQL Server 2005. If you are getting an error message like this you ARE connecting to a server which only supports 539, so it HAS to be a pre-SQL Server 2005.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Why is it that our database engine would be SQL 2000 SP4, when we just purchased the SBS 2003 Premium Upgrade which comes with SQL 2005.

Also can you please give me the info on upgrading the database engine to SQL 2005, so that I can restore the database backup that the SQL guru has created for our client.

Please help....I am really needing this information so that we can continue forward and begin using this database.

Thanks

|||Hi Aaoron,
As already requested by Sue and Jens can you pls confirm if the db engine pre-sql 2005 ? if yes and if you have a backup of all the dbs you can uninstall it and install sql 2005 and restore the dbs from the backup...............