Hi,

I having a problem in backup and restore, kindly anybody help me, by giving your suggestion.

I maintaining 2 server , 1 - Production server , 2 - Backup server
i want to take a backup from production server, and that file want to store in backup server directory.

For eg, my production server having a TEST as database, the regular backup handling in same system by
here i used production server ip.
BACKUP DATABASE [Test] TO
DISK = '\\xx.xx.xx.xx\D$\TEST.BAK'
WITH NOFORMAT, NOINIT

if i give a backup server ip, means it throwing an error that,

Cannot open backup device '\\xxx.xxx.xxx.xxx\E$\BACKUP\Test.BAK'. Operating system error 1326(Logon failure: unknown user name or bad password.).


Kindly provide me a solution