Backup to network drive

  • 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

  • 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)

  • 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

  • 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

  • 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)

  • Thank you Jeff,

    We use Enterprise version of SQL 2008.

  • I have not tried that yet but I will. Thanks

  • 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.

  • 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