Hi Elliot,

The above syntax is generated despite my expicitly defining the set option -

/DTS "\MSDB\Package1" /SET "\Package.Variables[variable name].Value";"T:\"

Hi Elliot,

The above syntax generated itself despite my adding the Set statement.

Hi,

I'm as well getting an error some-thing like -

Option " /SET" is not valid. The command line parameters are invalid. The step failed.

My cmd line says:

/DTS...

Thanks Lowell!

I did try the code sent by you but I'm still getting the same error message as before -

CTLIB Message: - L6/O8/S5/N3/5/0:

ct_connect(): directory service layer: internal directory...

I have setup a new maintenance cleanup task in SP2 without any issues. The problem exists only while specifying the expiry of BackUp set while creating a new backup schedule...

I agree that syslogin helps in providing the key answers but not the system/host name that has a specific role attached to it.

Jeffery: Do you have any script that uses the net start command utility that sufices such scenario? If so, do you mind forwarding it to me? Thanks!

Hi Jeff, Jeffery, mobasha

Thank you so much for your suggestions. This is the answer I wanted to confirm. Although I knew what you all have extended over to me but...

I mean that for whatever reason- If I need to start the SQL Server services including the agent, how do I do it through a script? I want to avoid...

Richard: What is the Salary? I understand the job is permanent, so will the candidiate get a visa for UK likewise?

what is the actual reqmt.? Professionals from any other country allowed?

Whatever you do, please be sure that you do not restart the server while the transaction is in the rollback state...this might lead to database going into 'SUSPECT'. Then you...

Sure Andras/Peter,

I will be testing this before making it live. I will be working on the Dev env. first. Thank for the confirmation!

Thanks Andras! Just wanted to be doubley sure before going-ahead on a critical DB.

So, this means that trans log is only affected when there is any trans backup taken and...

You can restore it through the last backup taken by the DBA or the DB engine.