Ok it's no secret I have trouble with the DBA crap.
One thing I'm doing is DTSing the entire database from the production server to our development/backup server at night. It seems to fail when the production server hasn't been rebooted in serveral weeks - I get SQL-DMO bulk copy Execution Error.
I have a scheduled DTS that copies "All objects". The database is still pretty small (~15 meg). Is there a better way to do this, like using replication or whatever.
It's handy when we have issues to compare data from previous data and such to help figure out what happened.
Thanks for any helpfulness.
One thing I'm doing is DTSing the entire database from the production server to our development/backup server at night. It seems to fail when the production server hasn't been rebooted in serveral weeks - I get SQL-DMO bulk copy Execution Error.
I have a scheduled DTS that copies "All objects". The database is still pretty small (~15 meg). Is there a better way to do this, like using replication or whatever.
It's handy when we have issues to compare data from previous data and such to help figure out what happened.
Thanks for any helpfulness.
