Posted by Ben on 10/12/07 21:46

We recently upgraded our MS SQL Server 2000 to 2005.

Here is what we did:

1. Perform backup of the database from the old server.
2. Created a blank database in the new server.
3. Restored the database into the blank database located in the new server.

After this process, there was an obvious slowness in the MS Access
application. Program-wise, I did not do any code changes. The only thing
that we did was just this upgrade.

I am leaning towards the netwok causing the slowness. But I do not know the
issues that might slow down the application just because we upgraded the
same database into SQL 2005.

[Back to original message]