Taking backup into different server through Database Maintenance Plan

Posted on 2007-10-02
Last Modified: 2012-06-27
Sql Server 2000

I have two servers

1) accsrv
2) sdmsrv

In sdmsrv I have shared folder \\sdmsrv\ACCSRV_BACKUP with administrative rights.

In accsrv I have created a Database Maintenance Plan and in tab [complete backup] I have ticked use this directory and Here I am writing folder name \\sdmsrv\ACCSRV_BACKUP it says

"The complete database backup directory \\sdmsrv\ACCSRV_BACKUP is invalid. Are you sure this is what you want?"

In short , I am unable to take database backup into different server/machine.
Question by:Mehram
    LVL 14

    Expert Comment

    one good suggestion will be to MAP the drive...right click netwrosk -- map network drive..and map you server path to a drive...and use the drive as the back that you can be sure that the connection is always proper...

    Author Comment

    It does not accept even mapped network drive.

    Author Comment

    Hi jaganeshsrinivasan

    Finally, I found that to backup on network location the SQL Server service must be run under domain account and not local system account.

    Please, put a comment on this opinion so that the correct answer could be accepted.

    LVL 14

    Accepted Solution

    yes, when its under a domain I would also suggest to have the domain account rather than local system account....

    but i have tried before that even when i am on local system account i was able to back up my db into another network drive (provided i had all hte priviliges of that network drive)...

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now