• In addition, attached script also can be handy for backup and restore. However little modification is required as per the requirement. This is for log backup you can also use it for full backup.

    http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/71918/

    http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/72321/

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."