Post reply

Backup to network drive

  • February 11, 2012 at 5:51 pm

    #268205

    Hi,

    I have a challenging task which is to backup databases to a network drive without changing server service to a domain account. The server service runs under local admin account and vendor does not want that to be different. I have tried to use proxy but it did not work. Does anyone offer a suggestion?

    Thank you.

    Hai

  • February 11, 2012 at 10:16 pm

    #1445998

    Just grant the user name for the SQL Service the privs to read and write to folder on the network drive and use a UNC name instead of a shared drive letter.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 12, 2012 at 12:45 am

    #1446004

    Thank you Jeff for your response.

    Sorry for misstating, in fact the server service runs under built-in local system account instead of local admin. My question is: Is there any way to make it work without using domain account?

    Thanks again.

    Hai

  • February 12, 2012 at 7:15 am

    #1446035

    If you were using network service then all would be good.

    Really your only option is to use a proxy along with (I'd recommend) an SSIS package to back everything up.


    Shamless self promotion - read my blog http://sirsql.net

  • February 12, 2012 at 9:21 am

    #1446047

    hai21century (2/12/2012)

    Thank you Jeff for your response.

    Sorry for misstating, in fact the server service runs under built-in local system account instead of local admin. My question is: Is there any way to make it work without using domain account?

    Thanks again.

    Hai

    What version and edition of SQL Server are you running? I ask because the Standard and Enterprise Editions require a Windows Server backbone and doing what I said should work just fine.

    If it's the Developer's Edition or Express Edition, then you'll probably need to create a Windows User for it so that you can do backups to the network drive as I said.

    As a sidebar, if it is the Developer's Edition, make sure you're using the licensing correctly or you'll fail just about every audit I know of.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 12, 2012 at 2:36 pm

    #1446069

    Thank you Jeff,

    We use Enterprise version of SQL 2008.

  • February 12, 2012 at 2:37 pm

    #1446070

    I have not tried that yet but I will. Thanks

  • February 13, 2012 at 3:34 am

    #1446144

    The LocalSystem account acts as the computer on the network, so if you give permissions for the computer account of the SQL server to the remote folder, SQL server should be able to back up to it. Note that this is actually a LESS secure configuration than just changing the SQL service to run as a domain account, because it means almost any service on the SQL server will have access to that remote share, rather than allowing you to narrow it down to the SQL service alone.

  • February 13, 2012 at 1:34 pm

    #1446481

    Hi Paul,

    Thank you very much. Great idea!

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

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