Database oppgrade 2000->2005

Hi

I have an application databse that I'm about to move from our old SQL Server
2000 installation and over to an new SQL Server 2005 installation. I'm
planning to do a simple backup on the old server, and restore the database
on the new one. The database user is a SQL user, and I'm planning to make a
new one on the 2005 server.
Are there any other things I should do after the database is restored on the
new server?

/A

A,

You should update statistics on the restored database so as to have 2005
statistics available to the optimizer.

I trust that you have already resolved any SQL Server version issues. If
not, the Upgrade Advisor is handy for finding problems before the database
is moved to a SQL Server 2005 server.
http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05...22-A677

RLF

"A." <spamblocker DeleteThis @gmail.com> wrote in message
news:%23xddBTVJJHA.5704@TK2MSFTNGP02.phx.gbl...
> Hi
>
> I have an application databse that I'm about to move from our old SQL
> Server 2000 installation and over to an new SQL Server 2005 installation.
> I'm planning to do a simple backup on the old server, and restore the
> database on the new one. The database user is a SQL user, and I'm planning
> to make a new one on the 2005 server.
> Are there any other things I should do after the database is restored on
> the new server?
>
> /A