thanks, you guys are very helpful.

Lowell (10/2/2007)

---

also, a DTS job is slower thant he time it takes to backup, copy and restore a database, as well as being prone to the changes you are seeing.

I'd...

homebrew01 (10/2/2007)

---

You can't reliably copy data from one database to another if the target is being changed without your knowledge. You need better communication with the developers, and then you...

i uninstalled SS2k and installed SS2k5. Then attached the 3 Databses, recreated the link servers and logins

Fixed the problem. Extra column on a table. Weird, it didnt show the error.

Thank you so much DBAs.

saved it as .dts. on SS2000 as storage file with extension .dts.

Went to SSMS / legacy / dts Tried to opened the package and the error popup.

Did upgrade...I unistalled 2000 and installed 2005. I think i did it wrong. Cause i lost all the user names and linked servers. But I dunnot what i did wrong.

thanks

once i shrank it back to 15GB from 35GB. then stopped the shrinking for 1 week and then it gew up to 40GB....and the disk ran out of space.

Thats why...

95 GB

grows 1.5gb per day.

i backed up with truncate only and shrink the file ...setup a job to run every 4 hours

i setup a job to shrink and truncate the log every 4 hours. I hope that works

how could i avoid the file from grow again.?