Create The Backup Database DB Maintenance Plan

  • Hey,

    i am planing to build daily backups for my databases.I want to create the backup folder name in the drive

    Like i having iwant to create 18-04-2011_TestDB

    CAN ANY ONE TELL HOW TO CREATE THE DATEBASED BACKUP FOLDERNAMES AND BACKUPDATAENAMES

  • EXEC xp_cmdshell 'md c:\whatever' --, nooutput --optional

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply