Post reply

Backup file copy

  • October 18, 2007 at 5:47 am

    #118693

    Hi,

    I have a database on sqlserver 2005.I usually take a full db backup and sequential transaction log backups and append each of the backups it to a backup file on E drive.Now if i want to copy my second transaction log file to a specific folder on D drive on my server.Do we have any procedure to do it.

    Regards

    Arvind L

  • October 18, 2007 at 5:06 pm

    #743340

    you can create any stored procedure

    and use sqlcmd which a command line utility use robocopy or move any of O/S commands. It would work

    Create procedure movefile

    as

    (

    exec xp_cmdshell or sqlcmd 'write your OS command here like robocopy [sourcefoler] [destinationfolder] filename'

    )

    Razi, M.
    http://questivity.com/it-training.html

  • October 20, 2007 at 8:36 pm

    #743903

    I'm a little confused. What does your second log file have to do with backups?

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

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