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 |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2009-08-23 : 01:41:41
|
| Hello,I had an sql 2000 database and attached it to sql 2008, now i need to re attach it to sql 2000 but get error: "Error 5123: CREATE FILE encountered operating system error 5(error not found) ...."How can correct this error ?Kind Regards,Sasan. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-08-23 : 01:46:18
|
you can't attach a SQL 2008 database in SQL 2000.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-08-23 : 05:06:15
|
| Databases cannot be downgraded, not using backup/restore, not using detach/attach. Once a database is on a SQL 2008 server it is a 2008 database in every way and the earlier versions of SQL cannot work with it. This is regardless of what compatibility level the DB is set toTo 'downgrade' a database, you need to script all the objects, export all the data, create a new database on SQL 2000, recreate all the objects and reload all the data.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Attach database error ?