HHxx

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

POC

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

HHxx

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

POC

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