how to take DataBase Backup from remote server to local system

Use same process as specified i.e, using Map Network Drive.

thanks..

i dont know how to pass the crediantial for server..

Do you want to take backup from SQL Server installed in a machine that is exposed to internet with public IP? If this is your question then yes, you can. If you know the credential and if your local machine can ping that public IP, you can surely do it.

thank you very much i've got it..

but one more thing is.. can i take a backup of public IP into my system..

how to do that...?

Make a shared drive in your local machine and give the shared drive path.

thanks..
i've two system one is server which uses OS windows server2008
and another is my system which uses OS XP prof SP3
i've created one folder called backup in my system and in sharing mode
the sql command when i run i server system it will fine..

but now..
the same i've created one folder in server and kept in sharing mode.
now when i run the command the error is displayed..

how to pass login crediantial

wat to do..

thanks for replying..
i want to take backup from remote server.
the following is what i did..
sql command= backup database employee to disk='//123.123.1.12/backup/back.bak'
"Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\123.123.1.12\backup\back.bak'. Operating system error 1326(Logon failure: unknown user name or bad password.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally."

wat to do..

This is specific to credential issue... Please provide correct password to logon to 192.168.4.122

Connect to Remote SQL Server 2008 then right click on Database -> Task -> Backup.

Then put Backup destination and click options to specify which type of backup do u need.

Then click OK to take backup