Post reply

Backing up SQL SVR 7/2000 to a mapped network drive

  • October 22, 2004 at 2:01 pm

    #109606

    Hi folks I need help trying to backup SQL SVR to a mapped network drive. There seems to be some added permissions SQL SVR needs to view the drives. When I use the maintenance plan it only sees local drives. Any help would be greatly appreiciated.

    Thanking ALL in advance

    webdaddy 13

    dn4@nyu.edu

  • October 22, 2004 at 2:33 pm

    #527719

    Sounds like a permissions issue.  What is the account that the SQL Server service is running under?  If it's the local system account, it won't be able to see the other server drives.  Try using a domain account with administrative priveleges and see if that works.  Hope this helps.

    My hovercraft is full of eels.

  • October 22, 2004 at 2:42 pm

    #527721

    Try typing in the full UNC name anyway eg \\server\share_folder$ and make sure the SQL server service is not running in local system account.

  • October 26, 2004 at 1:49 pm

    #528055

    Hi Ramesh this is webdaddy13

    How would I go about creating another account for SQL SVR. I actually went in and created a new user called SQLSVR gave it admins privs and reatarted SQL SVR service with it. NO good ebterprise mgr wouldnt run and the SQL SVR service wouldnt start. Any ideas???

    Thanks

    webdaddy13

  • October 28, 2004 at 10:51 am

    #528328

    SQL Server is real picky about how it handles mapped drives. I've found that the easiest way to handle network drives is to use UNC naming conventions. Even when you think permissions are correctly set up, you can still run into problems but UNC's are much more relaxed.

  • October 28, 2004 at 12:34 pm

    #528332

    Jason you are so right!!!!

     I finally found out what my problem was and I hope this solution helps others. I had to go to my machines that have SQL SVR 2000 separately from my machines that have SQL SVR 7.0. The 2003 server/SQL 2000 machines behave normally. You change from the local system account to a domain administered account and it works. It doesnt quite work that way for SQL SVR 7.0 see

    http://support.microsoft.com/default.aspx?scid=kb;en-us;207187

    So I have solved this issue for 2000 but not 7.0 but I am working on it. When I get it I will try to post it here for others. Send an email to dn4@nyu.edu if I forget. I think the answer on 7.0 is to re-install the SQL SVR as a domain account server rather than local system account. I do not know at this point that this is the FINAL answer.

     

    Thanks for everyone's help it all led me in the correct direction!!!

    Central Rocks!!!

    webdaddy13

     

  • November 1, 2004 at 7:51 am

    #528492

    I have solved this issue for my win 2000/SQL SVR 7.0 installation. It is a permissions problem involving win 2K OS on that particular server.

    "Event ID: 7000" or "Event ID: 7013" Error Message When You Attempt to Start a Service

    http://support.microsoft.com/default.aspx?scid=kb;en-us;314357&Product=winxp

    Thanks for everyones help again

    webdaddy13

     

Viewing 7 posts - 1 through 6 (of 6 total)

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