MIGRATING AN 8GB DB FROM SQL2000 TO SQL2005

Giganews Newsgroups
Subject: MIGRATING AN 8GB DB FROM SQL2000 TO SQL2005
Posted by:  Peter (Vik)
Date: Wed, 2 Aug 2006

Issue:
I migrate an 8GB db from sql2000 to sql2005 from a backup version that I
have in the network.

It moved over the users, but they can't authenticate to the new server. All
new users work fine.

SO my questions will be
What is the best to my MIGRATE AND SQL2000 DB TO A NEW SERVER RUNNING
SQL2005 ALONG WITH WITH ALL THE USERS AND THEIR PERMISSIONS.

Replies