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 |
|
csecharith
Starting Member
21 Posts |
 Posted - 2007-10-03 : 02:45:45
|
| Hi,I have a sql server 2000 backup and I want to restore it into a Sql Server 2005 database. I did the restore on the usual way. All the database tables were created, but the data didn't get restored.Pls help!Thanks! |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-10-03 : 02:46:30
|
| were there any errors reported?can you successfully restore that file on a SQL 2000 system?-ec |
 |
|
|
csecharith
Starting Member
21 Posts |
Posted - 2007-10-03 : 02:57:46
|
quote:
Originally posted by eyechart
were there any errors reported?can you successfully restore that file on a SQL 2000 system?-ec
Yes, it says successful |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-10-03 : 03:02:56
|
| what output do you get for sp_helpdb? what happens if you run DBCC UPDATEUSAGE?-ec |
|
|
|
csecharith
Starting Member
21 Posts |
Posted - 2007-10-03 : 04:38:47
|
| Yes I did, but no errors.I am restoring a SQL Server2000 database backup into SQL Server 2005 database. Is there any know issue when doing this kind of activity?Thanks! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-03 : 05:02:31
|
| "there any know issue when doing this kind of activity?"See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Migrating+to+SQL+2005+Hints+and+Tips |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-03 : 22:43:40
|
| How did you check that? Counted rows in table? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 02:03:24
|
quote:
Originally posted by csecharith
I did the restore on the usual way.
What does that mean? Could you elaborate?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Restoring SQL Server2000 backup to SQL Server 2005