| Author |
Topic |
|
kdterrell
Starting Member
5 Posts |
 Posted - 2011-05-03 : 14:56:51
|
| First off, Hi. I am David, new to these forums and I hope to learn alot from reading through them.Now to my issue! I have just installed SQL 2008 on a new server. Our current (live) sql is 2000 and is on a different physical box. My problem at this time is (to me anyways) complicated.I need to move my databases from the 2000 server to the 2008 server, but here is the kicker, I need the DBs on the 2000 server to stay live while I move these things and test them on the new server. These DBs are used by applications and have to remain available until I can test everything on the new system.Can anybody help?I would love to change the world, but I don't have the source code! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kdterrell
Starting Member
5 Posts |
Posted - 2011-05-03 : 15:17:26
|
| TY, I will give that a shot. If I am using backups for this, will there be any need to Manually move any files from one server to the other? (Other than the backup file of course)I would love to change the world, but I don't have the source code! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kdterrell
Starting Member
5 Posts |
Posted - 2011-05-03 : 15:39:11
|
| I am sorry to say that I really don't know what I am doing. With times as they are, I am learning as I go on most of this stuff. I did a backup and restore of 1 of my DBs. Also, did a backup and restore of the files/filegroups all using the backup engine in server 2000. Now, if there are files/users/jobs that need to be moved, where are they located? How do I find out by looking at the DB properties?I would love to change the world, but I don't have the source code! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kdterrell
Starting Member
5 Posts |
Posted - 2011-05-04 : 08:25:09
|
| Ok, well I am attempting to move a DB that is no longer used by a production application. At least if I break this one, I havent lost anything.I make a backup of the database and the files/filegroups. I have moved that to the new server and used those in a restore process. The database has been "restoring" for over 15 hours now. There are no errors in the logs and it comes back to the same state even after a reboot of the server. I am guessing that this is not the norm? What is the proper way to stop this and start over? Or should it actually be taking this long? The database I am using was very small with very little data.I would love to change the world, but I don't have the source code! |
|
|
|
kdterrell
Starting Member
5 Posts |
Posted - 2011-05-04 : 09:40:36
|
| Small update to last post. I ended up deleting that and starting over. When I did a restore of the DB and refresh the list of DBs it shows up and I can browse through the tables ect. When I do a restore on the file/filegroups from the 2000 backup and associate them to the new DB, it then goes back to Restoring on that DB and just stays there. There is no drive activity on the array either.Any thoughts?I would love to change the world, but I don't have the source code! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-05-06 : 07:35:58
|
| First of all take a backup and restore on SQL SERVER 2008 Box and do testAfter successfully tested drop it,if there any change during testing then generate script of these changes then take a recent full backup of live 2000 database and then restore with norecovery on the SQL server 2008 box,if your database size is large then it will take time but there is no downtime on 2000 Database after successfully on box 2008 then restrict the end user and then take differential backup of live 2000 database and then restore with recovery ,if there is scripts of changes then apply it and then route the application to the new Box 2008that is not a good practice to do test during upgradation or movement of a production database,thats why do all test with a copy of 2000 database on 2008 Box then move or upgrade itRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
New to SQL, Need some advice/help