SQL Server2000/2005 - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

SQL Server2000/2005

Author

Topic

tripleM
Starting Member

8 Posts

Posted - 2009-12-01 : 06:14:54

Hi All,

If i take backup from SQLServer2000 and restored in SQLServer2005.
Do i need any modifications or changes not required, if i need to access the DB from my programming language.

tripleM

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-01 : 10:54:24

After the restore, you may want to change the compatibility level to 90 if your app can support that. Otheriwse keep it at 80.

You should run update stats after an upgrade like that.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

tripleM
Starting Member

8 Posts

Posted - 2009-12-02 : 03:03:42

quote:
Originally posted by tkizer

After the restore, you may want to change the compatibility level to 90 if your app can support that. Otheriwse keep it at 80.

You should run update stats after an upgrade like that.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Hi,

My Problem is
I am trying to setup a webapplication developed in PHP, Apache2.0 and SQLServer2000 as backend which is running smoothly on a system in UK. I got the code and database backup from the Production Server.
Restored the DB backup into SQLServer2005 . Same structure i got in my local system. When i try to run the application, i am getting error DBConnect Failed. I analysed the problem and made changes to the very first query like prefixed the ObjectOwner to the tablename in the code.

In simple words,
Data Backup from SQLServer2000 and restored in SQLserver2005
from the PHP code if i run query like
" select * from users " is not running . if i modify query in the code like
" select * from sf.users ". its working fine.

Then login and validation done succesfully. But i cant change it everywhere. and its not required as in the production its running without the Object Owner(say here sf). So i am not sure if any change is required on SQLServer side. So pls let me know if any configuration/setting is required from SQLServer2005 side?

tripleM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources