MSSQL 2000- Backup Activity on a Network Machine

Hi,
I am using an Enterprise Manager and i have created a Database Maintainance Plan, can anybody guide me as to how to create backup on a remote machine.

I also mapped that device(say M/c B) onto my server box(M/c A) but i am not able to see that particular location in my backup activity screen.

Can this be done in the first place ?

Regards,
Tahirwe need some clarification.

do you want to backup databases on machine A to machine B or do you want to manage backups of databases that are on machine B from machine A?|||Yes i want to backup databases on machine A to machine B through Enterprize manager.|||While doing the backup on a networked remote machine which has been given full rights the job fails giving this error

BACKUP failed to complete the command BACKUP DATABASE [qa_tm_bdr_fix2] TO DISK = N'\\192.168.156.7\DBBackup\MUMSV075\qa_tm_bdr_fix2 _db_200612262300.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT|||Is your SQL Instance on A running under the system-account? The system account had no rights on B.

But there should be a more useful messge somewhere about why the job fails. Maybe in the errorlog? Have looked at the details in the jobhistory?|||Lexiflex is right. Make sure that the service account running the SQL server on B has enough permissions on the share (on A) where it should write the backup file. So in your case the account under which SQL Server B is running should have the permissions on the \\192.168.156.7\DBBackup share. I assume you allready shared the folder ... The problem Lexiflex is referring to is that the 'local system account' from machine A is not the same as the 'local system account' on machine B ... although it looks like it's the same one, it's definitely not ! You shouldn't run SQL Server under the local system account ... ever.

Been there, done that, worked fine.

Gr,
Yveau|||I am betting this is the problem as well. You will need to change the sql server and sql agent accounts to run under a domain account that has rights to your backup location.|||Thanks a lot for all ur help......it works......

Regards,
Tahir

MS-DTC...Some vulnerability info required

hi...
Sorry if i am putting question at wrong place, guide me.
I have tried 2 exploits (available on net) of Distributed
Transaction Coordinator at 4 different 2k machines.
But after execution of exploit, i dont see any change in
behavior of DTC. It works as it was. The target systems
do not have the required patch/service pack.
Kindly put some suggestions or take me to appropriate group.
Take care...bye
Ok, why 2000 and not 2003 R2? Why are you trying to get in? From the inside
of the network or outside? What exactly did you try? What patches did you
think would fix it?
This could be the case where a later patch fixes the issue or your testing
is a little off. Either way - move to 2003!!!!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Umer" <Umer@.discussions.microsoft.com> wrote in message
news:DC4A6615-30F7-44C2-BD81-97D4262B14C4@.microsoft.com...
> hi...
> Sorry if i am putting question at wrong place, guide me.
> I have tried 2 exploits (available on net) of Distributed
> Transaction Coordinator at 4 different 2k machines.
> But after execution of exploit, i dont see any change in
> behavior of DTC. It works as it was. The target systems
> do not have the required patch/service pack.
> Kindly put some suggestions or take me to appropriate group.
> Take care...bye