Mark Minasi's Reader Forum
Mark Minasi's Reader Forum
Home | Profile | Register | Active Topics | Active Polls | Members | Search | FAQ | Minasi Forum RSS Feed
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Email, Databases, Sharepoint and more
 SQL Server
 moving databases from SQL2000 to SQL2005 without l		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ranjb
Seasoned But Casual Onlooker

31 Posts
Status: offline
Posted - 10/05/2011 :  09:13:34 AM  Show Profile  Reply with Quote
Hi All

You will have to excuse my lack of knowledge with SQL but I have been tasked with retirting some of our oldest servers which are currently still used in production. Most of them are fine but I have hit an Windows 2000 Server with SQL 2000 and one of the databases is for our intraserver. I need to devise a plan to move this database over to an SQL 2005 or 2008 server.

Any ideas on where I should start.

Also as its a really old server I think there could be other db running on there. Does anyone know how I can find out what other databases are running on that server. If I go to SQL server enterprise manager, go to databases they are absolutely loads of db's but I have been told that most of them have been migrated over to other servers since.

I went to current activity and checked the locks/object section and this I think is showing me what databases are currently used because I am assuming if they are locked it means that they are in use.

Does anyone know of a better way?

Any sites/books others would recommend for a newbie DB administrator it would be greatly appreciated. BTW these servers are VM's on a VMware ESX4 cluster.

Thanks
ACTC, VCP5-DV

Playwell
Honorable But Hopeless Addict

Netherlands
4828 Posts
Status: offline
Posted - 10/05/2011 :  09:37:13 AM  Show Profile  Visit Playwell's Homepage  Click to see Playwell's MSN Messenger address  Reply with Quote
Use the profiler to check for logons.

Am not a SQL guru, but as i understood it works like this:
As for the databases you could back them up using SQL and restore them to the SQL 2005/2008 server. The logins are a pain, because only the database is restored, not the logins on the server.

An easier method is to replicate the databases to the newer servers. The logins are then created automatically.
'People who think they know everything are a great annoyance to those of us who do. '
Quote by Isaac Asimov
Go to Top of Page

ranjb
Seasoned But Casual Onlooker

31 Posts
Status: offline
Posted - 10/05/2011 :  10:18:34 AM  Show Profile  Reply with Quote
Thanks

I am assuming any applications that are currently pointing to the old server would need to the config changing to the new server?
ACTC, VCP5-DV
Go to Top of Page

Playwell
Honorable But Hopeless Addict

Netherlands
4828 Posts
Status: offline
Posted - 10/05/2011 :  10:42:45 AM  Show Profile  Visit Playwell's Homepage  Click to see Playwell's MSN Messenger address  Reply with Quote
Yes, ofc
'People who think they know everything are a great annoyance to those of us who do. '
Quote by Isaac Asimov
Go to Top of Page

NMDANGE
Honorable But Hopeless Addict

USA
2063 Posts
Status: offline
Posted - 10/05/2011 :  11:32:25 AM  Show Profile  Visit NMDANGE's Homepage  Reply with Quote
See this KB article on how to copy logins from SQL 2000 to SQL 2005:
http://support.microsoft.com/kb/246133

You can then detach and attach all the databases you move. You could rename the new server to match the old server's name during the cutover, if it is difficult to update the configuration of the applications in question.
Michael D'Angelo
(former)MVP-MIIS, Pace University Senior Systems Administrator (Windows)
(MS)NMDANGE
PhoeniX WorX Systems Administrator. If you play Total Annihilation, please join us. http://www.phoenixworx.org
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Mark Minasi's Reader Forum © 2002-2011 Mark Minasi Go To Top Of Page
This page was generated in 0.14 seconds. Snitz Forums 2000