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 |
|
Baileygodawgs
Starting Member
4 Posts |
 Posted - 2008-01-22 : 12:38:35
|
| We have a SQL Server 2000 Standard Edition database that we moved to a brand new box with SQL Server Enterprise Edition. The first thing we noticed was when we went to copy the database (35GB) over using Backup/Restore we never got any progress on the progress bar while doing the Restore. We waited for hours then tried again. Same result. We finally performed a Detach/Attach and was able to get the database moved over. Now whenever we are copying our Production database to our Development environment (Standard Edition) we always get Consistency Errors when the restore is about to complete. Has anyone else experienced this? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-22 : 22:56:05
|
| What's link speed between those servers? Did you backup to remote or restore from remote? Tried with restore command in query window? |
 |
|
|
Baileygodawgs
Starting Member
4 Posts |
Posted - 2008-01-23 : 08:54:08
|
| Thanks for responding. The first attempt was simply a backup to a .BAK file and then copy locally to the new server. Never got a progress bar during the Restore. Then the 2nd attempt was to copy the .mdf and .ldf locally and then attach. That was successful but now we still have the problems when we try to push a copy of Production to Development, no matter which method we choose. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-23 : 23:07:50
|
| Are those files in good shape after copying over? |
|
|
|
Baileygodawgs
Starting Member
4 Posts |
Posted - 2008-01-24 : 08:02:35
|
| Yes. By that I mean they seem to be of the same size and there were no errors. I had this problem again yesterday. I have narrowed it down to the fact I cannot restore a Backup of a database created in Enterprise Edition to a database created in Standard Edition. As crazy as that sounds. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-24 : 23:10:25
|
| Never saw that. What's sp level on those servers? |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-01-30 : 10:52:07
|
| Is the shiney new box sql 2005?I dont believe you can go backwards with a backup. |
|
|
|
|
|
|
Standard Edition to Enterprise Edition