jchen (8/25/2008)

---

I got one DTS job failed, it showed me below error, how can I from this error to drill down exactly failed reason. Can you help?

Thank you,

PS:

The job...

Go here:

http://www.sqlservercentral.com/Forums/

Then post in the most appropriate section ... ie,...

When I used replication across domains, I created a Windows account on each server with the same name & same password.

I had a similar problem. I loaded Windows XP pro on my laptop instead, then installed SQL 2005 developer edition.

This sounds a bit like a generic homework assignment ..... so here's a generic answer

1) Copy records older than 6 months into archive tables.

insert into Archive_table select * from Prod_table

where...

Adam Bean (8/22/2008)

---

sayfrend (8/22/2008)

---

Thanks homebrew ,

I guessed its because of DTS packages... Its really wierd though, it means when ever you are working on DTS packages you cannot use SSMS...

Are you running a maint plan that deletes the previous backup ?? If so, then the space problem is caused by the fact that the old backup is not...

Even though you can't browse to the path to select it, you can use Copy-Paste to enter the path you want.

Could you just add a DOS copy command as the next step in your backup procedure ?? I used to do something similar.

Legacy DTS does cause some odd behaviour when it's open. I've experienced problems similar to yours, but they clear up when I close DTS.

I just used a regular .BAT file executed in a Scheduled SQL Job.

Step 1, Backup the DB.

Step 2, Copy the .BAK to another location. Either using...

Wasn't there a problem with the Maint Plan Cleanup Task not working correctly ?? I think I heard that SP2 fixes that.

A restore would be expected to take longer than the initial backup because you have to write to the disks, not just read from them. Your RAID type can also...

"... shutdown the app server ..." Or just stop the service ?

Or delete the database. Then restore.

Deepak (6/4/2008)

---

I guess you might have the Sql Server collation as case sensitive and hence the error. Can you try using xp_msver or XP_MSVER check the procedure and see the...