Help with SQL 2000

[alduath]

Hi,

I'm moving my server to another, where SQL 2000 is installed.
My DB changed a lot since I first downloaded it a month ago, as I've been improving it. But now I need to move to that SQL 2k and I've already tried:

- Backup -> Restore: It says that "too many devices were selected", and I only selected 1 file (my .bak).
- Detach, copy .ldf and .mdf, attach on 2k server -> Error 602, something about sysindexes.
- Tasks -> Generate scripts -> Scripts won't run in 2k server.

Anyone knows any way to do this? I'm getting sick of it.

 

[RepublicOfAstra]

I'm not sure, but I don't think the DBs will work on 2K, I've always used 2K5. Why can't you use 2005 though, if I may ask?

 

[alduath]

Sure, first, it's not my server, and second, there are other db's on that mssql 2k. It's a DB server that is used for other games DBs.

I'll ask to upgrade it to 2005.. but I was trying to avoid that :S.

 

[RepublicOfAstra]

Eh. Sorry I can't help, but I've always used 2005, so I wouldn't know how to make it 2000 compatible.