Ok, I have a Ms Sql 2000 server running on Win2k Server. I want to copy the database of to another server so we can rebuild the first machine and then put it back. I have tried DTS, but fails on "cannot copy object". That is as helpful as the error message gets.

There is no backup of the database so I don't fancy playing with the detach/attach unless necessary......

Am I doing something wrong. Or am I being thick today

Helllppppppp ppllllleeeaaassseeeeeee.

H

 

Both servers on the same LAN I take it?

Create a new DB on the second server.

Create a backup of the DB you want too keep.

Move the backup file to the new server, Restore the backup to the new DB.

Walla!

Paul

 

Thanks Paul for the reply.

I had tried that before but the paths are different so it came up with errors. I managed to copy it by shutting down sql and copying the ldf and mdf files over and attach it to the new sql server. Job done..... I think, just have to check the data out, but its looking good

Cheers
H

 

Glad you have got it resolved

I think you can edit the paths to agree with the source and target location.... oh well, never mind

P