Hands-ups, I have no idea what I'm doing!
We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the databases from the old to the new and highlight any potential pitfalls or things to bear in mind.
Any advice is much appreciated.