Grant them only the EXEC permissions on the Stored Procedures

Hi Suresh,

On the outset I feel that the FULL TEXT index which you might have created earlier is OFFLINE. You can try deleting it under "FULL TEXT CATALOGS" in SSMS.

This...

Hi Suresh,

What is the error that you get while taking the backup?

Regards,

Pradeep Adiga

Hi Sourav,

You may find this link useful.

The stored procedure to start the job is sp_start_job

As suggested by Markus use "RESTORE HEADERONLY.." to verify that you are restoring from the right backup set. If you backup file has only one FILE, then you have to...

Try appending "REPLACE" in the restore command.

SELECT COUNT(*) FROM TABLE

Hi Eswin,

Looks like there was some corruption in the Original database and the same is available in the backup. Hence the restore is failing. Please verify whether the backup is...

Looks like the user with which you have logged on to SQL Server, does not have access to the path. Please check the User Permission on this share and also...

Hi Salma,

In the above query you have missed the Backup File Name. Please...

You may find this article useful.

Hi Durgesh,

You can call the "DTSRUN" utility via "xp_cmdshell". Read more about DTSRUN here

Please let us know the error with which the jobs are failing. Also check the Start-up account for SQL Agent and the owner of the jobs have sufficient privileges.

The Error Log time is ;

1. The Time when SQL server was last re-started.

2. The time when the SQL Log was recycled.

Details are here