backing up to disk on another computer
From: Jyoti (jrazdan@yahoo.com)
Date: 01/10/03
- Next message: Tom Moreau: "Re: backing up to disk on another computer"
- Previous message: Jian-Hua Chen: "Re: Cannot Use Non-Administrator Account to Start SQL Server and Force Encryption"
- Next in thread: Tom Moreau: "Re: backing up to disk on another computer"
- Reply: Tom Moreau: "Re: backing up to disk on another computer"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Jyoti" <jrazdan@yahoo.com> Date: Fri, 10 Jan 2003 11:13:46 -0800
No domains but both servers are within
the same workgroup.
This is the scenario -
Server D and Server R
1. Both servers D and R are within a lan, within the
same workgroup, no domains, and i can map drives etc
easily between the 2 computers. I can see the shared
forlders of one from the other without any
problem.These are the steps i took -
2. Created a login x with same password on both server
D and Server R. Added that login to Administrator
group on both servers.
2. Shared drive C of server D and gave all permissions
to x. Shared a folder 'backups' on C: drive of server
D with all permissions. This is the dir where i will
eventually create the backup device and write the
backup file.
3. On server R logged in as x. Started SQL Server.Used
windows authentication. Went to database 'pubs' and
tried to backup pubs to device by creating new device
pointing to
\\serverD\C$\backups\netback.bck
When tried to backup got message backup cannot open
device netback. Device error or disk offline ....
In SQL Server Logs this is the message which gets
recorded :
BackupDiskFile::CreateMedia: Backup device
'\\serverD\C$\backups\netback.bck' failed to create.
Operating system error = 5(Access is denied.).
When i create device from QueryAnalyzer window it says
successful. If i look thru sp_helpdevices i can see
the devices created successfully with the physical
name pointing to \\serverD\C$\backups\netback.bck.
Any pointers would be helpful. Thanks in advance.
- Next message: Tom Moreau: "Re: backing up to disk on another computer"
- Previous message: Jian-Hua Chen: "Re: Cannot Use Non-Administrator Account to Start SQL Server and Force Encryption"
- Next in thread: Tom Moreau: "Re: backing up to disk on another computer"
- Reply: Tom Moreau: "Re: backing up to disk on another computer"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
