August 5, 2002 at 10:06 am
We are facing some problem regarding backing up the database.
We have a machine say A installed with WIN 2000 which acts as a server(SQL Server). Another machine say B installed with WIN 98 acts as a client.
We are trying to take backup using Query Analyzer from machine B to a local folder in
M/C B itself. The T-SQL command used is given below
"backup database XXXX to disk = '\\machine B\C\testbak.bak' with init"
Backup process terminates with the error message 'Cannot open backup device....'
This is also the case when a WIN 2000 is involved as both client and server.
Whereas a WIN NT server and a WIN 98 client allows the backup to be taken in the local folder (M/C B).
Can anyone help to overcome this problem.
August 5, 2002 at 10:15 am
Is SQL Server running under a domain account? That is what needs rights to access the backup drive.
Steve Jones
August 8, 2002 at 10:25 am
Hi steve,
We don't understand what
"Is SQL Server running under a domain account? ". Can you please explain it a bit more.
Thank you,
Suresh Kumar.N
August 9, 2002 at 9:35 am
All services, including SQL Server, run under some account. By default, this is the local system account on the server, which CANNOT access domain resources, or any resource not located on that computer.
In control panel/services, what is the log on account for the mssql service?
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply