Post reply

configure the backup on a Network location where user name and password is required

  • December 30, 2011 at 2:39 am

    #250630

    I have to configure the backup on a Network location where user name and password is required to save the file.

    How can I proceed?

    Thanks

  • December 30, 2011 at 2:45 am

    #1426810

    Do you want to create backup on Network Drive or do you want to copy backups on Network Drive?

    If first, it’s not advised. The solution on second scenario depends on your copy tool / command.

  • December 30, 2011 at 3:04 am

    #1426819

    I want to create backup on Network Drive ....

    Thanks

  • December 30, 2011 at 3:13 am

    #1426824

    forsqlserver (12/30/2011)

    I want to create backup on Network Drive ....

    Any particular reason for that?

  • December 30, 2011 at 3:18 am

    #1426828

    This n/w SAN storage location is provided by the SAN Admin and this SAN storage location is shared between 4 servers.

    Thanks

  • December 30, 2011 at 4:14 am

    #1426851

    You would have to issue a NET USE command for the SQL Server service account.

    Ugly and unreliable. Are you sure you don't have other options?

    -- Gianluca Sartori

  • December 30, 2011 at 4:25 am

    #1426859

    Thanks Dev...it is really helpful.

    In this it is asking for user_id and password and I want to schedule it using job in automatic completion of backup.

    How can user_id and password be provide without manual intervention.

    Thanks

  • December 30, 2011 at 4:30 am

    #1426863

    forsqlserver (12/30/2011)

    How can user_id and password be provide without manual intervention.

    NET USE X: \\servername\sharename password /USER:domainname\username

    -- Gianluca Sartori

  • December 30, 2011 at 4:37 am

    #1426867

    Thanx Thanx Thanx

    Thanks

  • December 30, 2011 at 4:39 am

    #1426869

    Can you not just get your network admin to grant permission for the SQL Server service account to write to the share?

    John

  • December 30, 2011 at 4:42 am

    #1426871

    forsqlserver (12/30/2011)

    Thanks Dev...it is really helpful.

    In this it is asking for user_id and password and I want to schedule it using job in automatic completion of backup.

    How can user_id and password be provide without manual intervention.

    errrrrrr... Gianluca helped you. 🙂

  • December 30, 2011 at 4:43 am

    #1426873

    Yes may be I have not discussed.

    After completion how can I disconnect the session with that shared san location?

    Thanks

  • December 30, 2011 at 4:47 am

    #1426876

    forsqlserver (12/30/2011)

    Yes may be I have not discussed.

    That would be the best way. Talk to your admins, I'm sure you can set up something sensible.

    After completion how can I disconnect the session with that shared san location?

    NET USE X: /delete

    However, I would prefer taking the backup locally and copy the file after the backup completes. I think it's much safer.

    If you have Enterprise Edition, you can take mirrored backups[/url], but I'm not a big fan of that feature.

    -- Gianluca Sartori

  • December 30, 2011 at 4:49 am

    #1426878

    I will check and revert.

    Thanks

Viewing 14 posts - 1 through 13 (of 13 total)

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