Sameer,

Thanks for your reply. How do I go about writing this job as my DBA knowledge is very limited.

Regards

Dipendra

Hi,

The db is backed up daily - Monday to Friday and no Transaction log backups are happening during the day.

As my SQL Server knowledge is slightly limited, what is the...

Hi,

RECOVERY=FULL

Regards

Dipendra

Hi,

Thanks for your response. For backup purposes, we are using CA Brightstor Arcserv 11.5 and using the SQL Server agent to backup the database daily therefore we would use Brightstor...