Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error with upgrading sql 7 to sql 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-10-29 : 08:32:24
Ricardo writes "Hi, I´m trying to upgrade from SQL server 7 to SQL 2000, but I have some problems:



-When I detach my database from SQL 7, then I attach it on SQL 2000 but I get an error about it can not upgrade it…!!! (SQL Server with Service Pack 3a)



-What could happen with my clients about conection. Should I make any changes in my clients when I upgrade to SQL 2000…????



I have one data file data.mdf and two log files log1.ldf and log2.ldf…



Thanks for all.

Ricardo."

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-10-29 : 15:00:36
What EXACTLY does the error say?

As long as you're using the same alias and port settings on the new server, the clients should be fine.

-----------------------------------------------------
Words of Wisdom from AjarnMark, owner of Infoneering
Go to Top of Page
   

- Advertisement -