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

MsSql , VPS , plsek software .... PROBLEM ! [:(]

Hi ,

like i said i have VPS plan but on this plan the plsek sofware does not support
MsSql , the stuff that host my website told me that they will not support anything that invovled to MsSql

so ... what i was doing till now ?

i download SqlExpress 2005 on the remote machine . and i can login to the Database engine using Windows Authentication ,

also , i have 'webs develeoper express' (asp.net) on my PC and also have SQLExpress 2005 - when i run my website on my PC i successfuly
insert some data into the DataTables .

but when i run the same file on the VPS (after i upload them using FTP)
that does not work and i see this message :

Cannot open database "horse" requested by the login. The login failed. Login failed for user 'VE326\IWPD_4(main)'.

my connectin string on my "DBLayer" class looks like this :

connString = @."Server=(local)\sqlexpress;Integrated Security=True;Database=horse";

ANY IDEA ?

thanks .

Hi greekhand,

The error messaged indicates that it's a login failure. So, just make sure the user account VE326\IWPD_4(main) has sufficient permission to the "horse" database. Open your Management Studio and connect to your db, select the "horse" database and expand it. In the "security" section, choose "Users" and verify if account "ve326\iwpd_4(main)" has been included. And if not, right click and slect "new users", you can assign permissions to that account here.

Hope my suggestion helps