Post reply

BACKUP TO NON-EXISTING DESTINATION

  • July 20, 2009 at 1:58 am

    #155985

    Is there any way I can create a folder on my destination for my backup using a script? Because when I tested to specify a folder that does not exist in the destination of my backup, it returned the error "Device error or device off-line". How can i automate the folder creation on my script?

  • July 21, 2009 at 7:59 am

    #1027623

    What script are we talking? You could do it in DOS using a batch file, right?

  • July 21, 2009 at 8:10 am

    #1027631

    I am with David on this one. Use a batch file in dos with sqlcmd to execute your sql or use xp_cmdshell in sql to execute your dos commands.

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

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