what about this easy tool which called dtsbackup2000

http://www.sqldts.com/default.aspx?272

Thanks all_

It is very nice from you to help me.

can any one tell me the best way to study sql server 2005 ,I'm a sql server 2000 user and I...

Guys it work with out any permissions or dbcc traceon(1807)   ..... it simply work with    "SA" user .

don't ask me why all that happened but when i remove "c:" and change...

oooooh finaly it's work

thanks Rookie it's true we don't need c:

also:

it only work when i write the name of the PC not the IP address (i don't know why but...

sorry guys but it return the same error

Hey Rookie , take it easy and don't be angry.

I'm not Expert DBA for that am asking!

i understand that the account which i have to access the DB with must...

No Rookie , i don't want to sneak the DB .

but i can't make changes to production server untill i make sure that every thing is okay. i hope u...

thank u mohammad

i will ask the network admin to give me db_owner permition , and i hope that will solve the problem.

thanks

in fact i try to backup DB in another server ,, and i want the backup file to be saved in my local machine.

both the server and my PC is...

thank you for your help

but i try it and got this error

Server: Msg 3201, Level 16, State 1, Line 1

Cannot open backup device '\\10.0.2.83\d:\aa\northwind.bkp'. Device error or device off-line. See...

Very thanks , this articles is great and also xp_cmdshell is great and i wasn't hear about them before .

but i still having aproblem with greating a custom DTS task...