Post reply

Backup SQL Server Database with Move/Copy File

  • September 23, 2007 at 9:29 pm

    #181129

    Comments posted to this topic are about the item Backup SQL Server Database with Move/Copy File

    Marvin Dillard
    Senior Consultant
    Claraview Inc

  • January 23, 2008 at 2:23 pm

    #771057

    hi,

    its soo helpful script for me. so simple to run. really appreaciatable.

    thx

    sreejith

    MCAD

  • July 3, 2008 at 2:49 am

    #837666

    somebody pls explain step by step to me to use this query. because i have to set back on a network computer. i dont know how to use this. but it seems very help full

    VENKAT

  • February 27, 2009 at 6:48 am

    #951125

    Marvin,

    Thank you So much for the script, this is so helpful. I have one question, if you can provide some suggestion. I have to backup all the databases but I do not have enough disk space on my local to do them all at a time is there a way to backup one database, move the .bak file and then backup the next one. My question is how can you make sure the move/copy was successful before you delete the bakup file on the local and backup the next one.

    Thanks

    Shri

  • May 1, 2009 at 8:55 am

    #987356

    Shri

    I sent you a new script. Let me know if that works for you

    MD

    Marvin Dillard
    Senior Consultant
    Claraview Inc

  • July 3, 2009 at 2:25 am

    #1019659

    sreejith and all,

    Please i really need your assistance asap on how to use this script if you don't mind.

    I'll be really greatful if i can get some assistance on how exactly to use this sript.

    He mention something about not forgetting to set the local drive path and network share for each backup in the backupretention table. (Is this after the script has been run for the first time or before it's run at all?

    Also remember, to set the relocation action of copy or move. (Not sure how to do this too)??? Guys am new on the job please 😛 help!!!:

  • August 17, 2009 at 1:55 pm

    #1040461

    Hi Marvin

    Could you please also send me the script to backup one database at a time like Shri asked for or post it here. I would really appreciate it.

    Thanks,

    Lynn

  • December 17, 2009 at 6:38 pm

    #1093835

    Sorry

    Been busy and haven't been around on a regular basis, let me know if you still need it and I will dig it out.

    Thanks

    MD

    Marvin Dillard
    Senior Consultant
    Claraview Inc

  • September 28, 2010 at 12:26 pm

    #1228595

    Hi,

    Great job, I was develop a symilar way, but encounter error whem copy to network drive.

    I was set the permissions to everyone, change the user for SQL Agent, try to put this user in Administrator Group and nothing.

    Always the job in sql command say:

    move /Y \\backup\aaaa_20100927.bak \\192.168.10.1\BACKUPS\bbbb.bak

    output

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Access is denied.

    Any Ideas?

  • December 5, 2011 at 2:03 pm

    #1417028

    can you explain me how to run this SP .

    I am trying to run but nothing is happeing even though saying execute successfully .

  • December 5, 2011 at 2:05 pm

    #1417030

    Hi Marvin.

    Your Stored Procedure looks great but when i am trying to run i didn't see anything happening so if you explain detail where to make changes and which parameter to pass would be nice .

    pls explaing with one example

    thanks

  • December 5, 2011 at 2:34 pm

    #1417044

    It's been awhile since I logged on to SSCentral and unfortunately I have not been getting the from the people requesting new information. The basic premise of this stored proc was to pass values stored in a table to a proc that could then automate your backup to include zipping and moving the files across the network. I have not looked at the proc in over two years as I am no longer doing DBA type of functions. However, if someone really needs the help, I'll dig into the code and update it.

    Thanks

    MD

    Marvin Dillard
    Senior Consultant
    Claraview Inc

Viewing 12 posts - 1 through 11 (of 11 total)

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