Hi Sundar,

If you are using the SQL Server 2005 Enterprise version, you can setuo the email feature. Please go through the URL as it has very good step by step...

I am not very good in Scripting. You can read the Log Shipping doc from below URL and then update the script as per your requirements. The article has good...

Yes, you can change the Backup Path even after Logshipping configuration and it works well. You need to go to the properties and change the path in Backup Settings...

In general, you can't access your Local Drive ( C drive) on clsuter node. This is because of nature of cluster architecture. Cluster services access the resources which can be...

He wanted to take a database backup if remote server and save the file on remote server itself. This is simple as you open any SQL Server Enterprise Manager and...

As it is not an OLTP database and point in time recovery is not required, you should put the database in Simple recovery mode.

You sould take Weekly Full backup of...

This may help you...

/**** Below query can be used to directly pull the failed job on a

particular day and other relevant information. It can be modified to

match the exact requirement...

You can also find the information from your server Application or System event log files.

You can use the Maintenance plan for the scheduled database backup option as suggested by Henrico Bekker.

You can read more about maintenance plan on SQL Book on Line. Some summary...

The permission of xp_cmdshell execution can be given to Domain NT users as well as SQL Login users.

Permissions

Execute permissions for xp_cmdshell default to members of the sysadmin fixed server role,...

You can look at SQL Server Error log file to find out the reason for your backup failure issue. Some details can also be found on Event Viewer.

See the error...

.:-)

This is a good point. A new learning for me. Thanks 🙂

A limited information may be retrived from the Transaction Log file if your database is in Full recovery mode. Otherwise it is almost impossible to get the info.

RECOVERY stands here for database is recovered from sinle/multiple backup files after applying them sequencially. The database is ready to use for any further actions.

NORECOVERY stands here for database...