Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimjen
Yak Posting Veteran
61 Posts |
 Posted - 2007-03-17 : 23:41:12
|
| I am trying to copy a database from sql 2000 to sql 2005. I used the copy database feature and followed the instructions to the letter. When the SSIS package run, it fails. It tells me to check te error log, but it doesn't explain why it's failing. Please help me find why. I'm told that I can use backup and restore to achieve the same task but I can't find out the steps to do this. Please helpThanks |
|
|
prpball
Starting Member
19 Posts |
Posted - 2007-03-29 : 13:45:35
|
| It could be failing because your server does not meet the pre-reqs for Sql 2005 installation. Check to see if your processors is a P3 or above. If not, then that is why you are having trouble. You can still import back backing up the SQL 2000 db and restoring it on sql 2005. Go into Sql 2000 and backup the database. If Sql 2000 and sql 2005 are on different servers then you will need to copy the backup file and put it on the sql 2005 server. Next go into sql 2005. Right click on the database folder and click new. Type in the name of the database and click OK, NOT ADD. This will create a database for you to restore an old one onto. Next Right Click on the newly created database. Hightlight tasks, restore, database. This will bring up a Restore DB window. The destination should be set to the name of the newly created db. Under the source choose the radio button FROM FILE, then click on the ... button. Next click ADD and locate the file that you backed up from sql 2000 and click ok and OK again. You should now be back at the original restore screen and in the select backup to restore window there should be your file. Check the box that says restore and click OPTIONS on the left hand side. Under RESTORE OPTIONS make sure you check overwrite existing DB and then click OK. This will restore your existing sql 2000 db. |
 |
|
|
|
|
|
copy database