[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 665
  • Last Modified:

Taking backup into different server through Database Maintenance Plan

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.
0
Mehram
Asked:
Mehram
  • 2
  • 2
1 Solution
 
Jai STech ArchCommented:
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 up...so that you can be sure that the connection is always proper...
0
 
MehramAuthor Commented:
It does not accept even mapped network drive.
0
 
MehramAuthor Commented:
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.



0
 
Jai STech ArchCommented:
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)...
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now