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 |
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
 Posted - 2001-08-11 : 08:25:28
|
| OK GuysThis one is bugging me so I thought I would post it.I am using DTS to back up the data from one of my sites. I am using "Copy Objects" and have it set to copy objects and data.The source server is SQL 7, I have a job running nightly from an SQL 2000 install at work and it works fine. However, if I try to run it from either of my SQL 7 machines at home, it works except for one table which it won't copy data from, the object is created fine but the data data isn't there. Only one table too, same table on both servers, and there is not anything unusual about that table.I had a search around the MS knowledge base and can not find it, but it seems like a weirdo bug of some sort.Has anyone seen anything like this ?The machines that won't copy properly are both Windows 2000, one server, one workstation, running SQL 7, no service packs though (I haven't been bothered downloading them on a 56k line ).Any thoughts ???ThanksDamian |
|
|
|
|
|
DTS Not copying some data