I think your job contains some code, which takes lots of space in the tempdb. Is the autogrow option in your tempdb on.

Peter,

           Yes its a domain account. If that is a control issue then all the jobs will fail. But only this particular DTS jobs are failing other backup and other maintenance...

Peter,

Yes I am able to run the DTS package from the design mode or the from the DTS designer. I even tried to re create the job in the fail...

There is no error log location set up either in Job or in the DTS packages. Do you have any suggesitions?

Jeff,

 Thanks for your reply. I have saved the DTS package in side the SQL Server itself. I did not save the package externally. Can you let me know in which...

While Installing the SQL Server in the cluster, you have to create the alias name for both nodes. Like you should create the alias name for the SQL Server mapping the...

You have to have these servers connected or you should find any way to move those backup files to the destination server. Once its done restore those databases using EM...

can you lets us know what was the problem?

Hi,

 Did you check whether you have enough space in the drive.

Hi Alon,

I dont think there is any possibility of an unauthorised person viewing the tables or copying it? May be I might have not understood what you ment actually.

With...

Hi Shilesh,

The better way is to create a role containing all the privileges u want and assign to the users.Which will be handy if u want to modify or remove...