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 |
|
macca
Posting Yak Master
146 Posts |
 Posted - 2009-09-18 : 10:08:20
|
| I have a DB in sql 2000 but I want to move it to sql 2005.I have tried to use the .bak file to restore the 2000 to 2005 but this wont work.Is there a number of steps I need to undertake to do this transfer ?macca |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-09-18 : 12:27:32
|
| how r u restoring the database? post your script. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-09-18 : 17:50:03
|
| what error message are you getting.Also are you creating the new db, before restoring ? |
|
|
|
macca
Posting Yak Master
146 Posts |
Posted - 2009-09-21 : 04:17:10
|
| Thanks for the replies guys.I got this sorted. |
|
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2009-09-23 : 09:07:42
|
| Run database upgrade wiz to see the log details ....With RegardsBSR |
|
|
|
|
|
|
Moving sql 2000 DB to sql 2005