-
SQL server 2008 - Database Backup and Restore - using Network IP
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|