URGENT : Unable to backup SQL databases

Discussion:

(too old to reply)

Shakes

2006-06-06 14:40:03 UTC

I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have attached a copy
of the error log below. As you can see I am unable to start the backup. Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a path on
another win2000 server for the backup file, which did'nt work either. Please
HELP!!

2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).

2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).

2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system error = 3(The
system cannot find the path specified.).

Michael Epprecht [MSFT]

2006-06-06 14:58:37 UTC

Permalink

Hi

Forget about who is logged onto the server. SQL Server does not care about
that.

SQL Server Service account must run under a domain account that has
privileges on the file share. If you do not have a domain, run SQL Server
under a local account that has the same username and password as the user
that has rights on the remote share.

Don't use mapped drives. Use UNC paths (\\servername\sharename\file.bak)
--
Mike

This posting is provided "AS IS" with no warranties, and confers no rights.

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have attached a copy
of the error log below. As you can see I am unable to start the backup. Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a path on
another win2000 server for the backup file, which did'nt work either. Please
HELP!!
2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).
2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system error = 3(The
system cannot find the path specified.).

Shakes

2006-06-06 15:11:03 UTC

Permalink

Hi Michael,

Thanks for the quick response. I'm a newbie to SQL server. I know for sure I
have not setup a domain. How can I check if SQL server is running under a
local account. I am quite sure I've setup a local account for sql server, but
can you tell me how I can check that. I setup the server more than a year ago
and with my other committments its hard to keep up with it. I did try UNC
paths and that did'nt work either.

However, in the time between my first post and your reply, I tried using the
wizard under tools in enterprise manager. And that seemed to have worked
without giving me those errors I posted. Why is that ? I backed up all the
databases individually to the same folder on the C drive of the 2003 server.
I recieved a popup telling me that the backup was verified successfully.
Should I copy these files to my other win2000 server just incase ? Should I
be backing up msdb, master and pubs databases regularly and if so how often ?
How can I backup or image the whole win2003 server so that I can have a back
up of all logins and other windows entities in case of a total system or hard
drive crash ? I currently have mirrorring setup through SATA RAID. I have no
resources/budget to go to hardware RAID at the moment.

Cheers,
Al

Post by Michael Epprecht [MSFT]
Hi
Forget about who is logged onto the server. SQL Server does not care about
that.
SQL Server Service account must run under a domain account that has
privileges on the file share. If you do not have a domain, run SQL Server
under a local account that has the same username and password as the user
that has rights on the remote share.
Don't use mapped drives. Use UNC paths (\\servername\sharename\file.bak)
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.

Keith Kratochvil

2006-06-06 14:58:58 UTC

Permalink

What a mess. It appears as though you are trying to backup to the following
locations:
X:\DATA\MSSQL\BACKUP
\\God\Dell_backup_May06\BACKUP
C:\BACKUP

Do those disk locations (disk and share or subdirectory) exist?

Execute this. What do you get?

exec master..xp_fixeddrives
--
Keith Kratochvil

Shakes

2006-06-06 15:16:03 UTC

Permalink

Hi Keith,

The disk locations do exist and as you can see in my reply to Michael , when
I used the Wizard with those same locations to perform the backups, it
worked. Why ? How ? lol

Cheers,
Al

Post by Keith Kratochvil
What a mess. It appears as though you are trying to backup to the following
X:\DATA\MSSQL\BACKUP
\\God\Dell_backup_May06\BACKUP
C:\BACKUP
Do those disk locations (disk and share or subdirectory) exist?
Execute this. What do you get?
exec master..xp_fixeddrives
--
Keith Kratochvil

Keith Kratochvil

2006-06-06 15:32:58 UTC

Permalink

As Michael pointed out, the SQL Server Services must be running under an
account that has write rights to those directories.

I am not sure what you mean by "naming a file"

This should work (It is Transact-SQL. You have to execute it from Query
Analyzer [or SSMS if you have SQL Server 2005])

BACKUP DATABASE master TO DISK = 'C:\master.bak' WITH INIT

It should create a file on the root of your C drive that contains a backup
of the master database.
If you want control over the backup jobs you might want to create them on
your own. This gives you more practice in backing up the databases.

Next step: restoring them. I would not advise trying to restore master as
it is a bit more complicated than other databases. You should be able to
take a backup from one server (production) and restore it to another server
(development). When you restore you can give the database that you are
restoring a new name. You can even move the data and log files around if
necessary. The RESTORE command is well documented within Books Online. I
recommend that you understand how to restore a database. Make sure that you
do any testing on a development server just to make sure you do not do
anything (like restore over a database) harmful to your production server.
--
Keith Kratochvil

Post by Shakes
Hi Keith,
The disk locations do exist and as you can see in my reply to Michael , when
I used the Wizard with those same locations to perform the backups, it
worked. Why ? How ? lol
Cheers,
Al

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have attached a copy
of the error log below. As you can see I am unable to start the backup. Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a
path
on
another win2000 server for the backup file, which did'nt work either. Please
HELP!!
2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).
2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system error = 3(The
system cannot find the path specified.).

Shakes

2006-06-06 15:59:01 UTC

Permalink

I forgot to mention, I have SQL server 2000 standard edition with service
pack 3a.

For now I am mainly concerned about backing up my production db for one of
my web applications and also any associated sql system databases. Since I
used the wizard, I now have the individual *.bak files for the master, msdb,
web application db and the pubs db. Like I said I did get the popup telling
me they had all been verified. Do I need to do anything else to make sure
those are good backups ?

I do not have a test server at this time. Budgets are very tight. But at the
same time I cannot afford to lose my data. I have SATA RAID hardware
mirrorring setup on the win2003 server.

I need to install some software upgrades on the web application which uses
sql server databases. Therefore I needed to backup the databases. Sine I
have mirrorring, what if I unmount the mirror and then disconnect the mirror
drive. By doing this I will have my best copy of the databases without the
upgrade to the web application intact. So in effect, if I then go ahead and
do the upgrade to the web app without the mirror and if something goes wrong,
I should have the mirror drive with the good copy from which I should be able
to just replace the primary drive right ? Or should I even bother doing this
? Secondly, if I do take this step and the upgrade is successful, can I then
re-install the mirror drive and then assume that the SATA RAID will
successfully replicate itself to the mirror with the upgraded web app ?

You guys are a great source of help !!

Cheers,
Al

Post by Keith Kratochvil
As Michael pointed out, the SQL Server Services must be running under an
account that has write rights to those directories.
I am not sure what you mean by "naming a file"
This should work (It is Transact-SQL. You have to execute it from Query
Analyzer [or SSMS if you have SQL Server 2005])
BACKUP DATABASE master TO DISK = 'C:\master.bak' WITH INIT
It should create a file on the root of your C drive that contains a backup
of the master database.
If you want control over the backup jobs you might want to create them on
your own. This gives you more practice in backing up the databases.
Next step: restoring them. I would not advise trying to restore master as
it is a bit more complicated than other databases. You should be able to
take a backup from one server (production) and restore it to another server
(development). When you restore you can give the database that you are
restoring a new name. You can even move the data and log files around if
necessary. The RESTORE command is well documented within Books Online. I
recommend that you understand how to restore a database. Make sure that you
do any testing on a development server just to make sure you do not do
anything (like restore over a database) harmful to your production server.
--
Keith Kratochvil

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have attached a copy
of the error log below. As you can see I am unable to start the backup. Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a
path
on
another win2000 server for the backup file, which did'nt work either. Please
HELP!!
2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).
2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system error = 3(The
system cannot find the path specified.).

Keith Kratochvil

2006-06-06 17:25:09 UTC

Permalink

I would not break the RAID mirror.
--
Keith Kratochvil

Post by Shakes
I forgot to mention, I have SQL server 2000 standard edition with service
pack 3a.
For now I am mainly concerned about backing up my production db for one of
my web applications and also any associated sql system databases. Since I
used the wizard, I now have the individual *.bak files for the master, msdb,
web application db and the pubs db. Like I said I did get the popup telling
me they had all been verified. Do I need to do anything else to make sure
those are good backups ?
I do not have a test server at this time. Budgets are very tight. But at the
same time I cannot afford to lose my data. I have SATA RAID hardware
mirrorring setup on the win2003 server.
I need to install some software upgrades on the web application which uses
sql server databases. Therefore I needed to backup the databases. Sine I
have mirrorring, what if I unmount the mirror and then disconnect the mirror
drive. By doing this I will have my best copy of the databases without the
upgrade to the web application intact. So in effect, if I then go ahead and
do the upgrade to the web app without the mirror and if something goes wrong,
I should have the mirror drive with the good copy from which I should be able
to just replace the primary drive right ? Or should I even bother doing this
? Secondly, if I do take this step and the upgrade is successful, can I then
re-install the mirror drive and then assume that the SATA RAID will
successfully replicate itself to the mirror with the upgraded web app ?
You guys are a great source of help !!
Cheers,
Al

Shakes

2006-06-06 17:56:02 UTC

Permalink

I take it I do not need to do anything more to make sure that all my
databases are backed up ? I have *.bak files for each of the databases listed
in SQL server enterprise manager. Am I good to go for the web app upgrade ?

Post by Keith Kratochvil
I would not break the RAID mirror.
--
Keith Kratochvil

Keith Kratochvil

2006-06-06 19:28:04 UTC

Permalink

You should be in good shape.
If you are not backing up the files to tape you might want to copy them
elsewhere just in case the machine dies on you.
--
Keith Kratochvil

Post by Shakes
I take it I do not need to do anything more to make sure that all my
databases are backed up ? I have *.bak files for each of the databases listed
in SQL server enterprise manager. Am I good to go for the web app upgrade ?

Post by Keith Kratochvil
I would not break the RAID mirror.
--
Keith Kratochvil

Shakes

2006-06-06 19:49:02 UTC

Permalink

Dont have backup tape drive. Just did backup to fixeddisk. Will copy files
to God. I'm able to share through file sharing for somereason , but as you
say not for the purpose of using god as a backup location.

Thanks for your help. Highly appreciated. Keep in touch.

Al

Post by Keith Kratochvil
You should be in good shape.
If you are not backing up the files to tape you might want to copy them
elsewhere just in case the machine dies on you.
--
Keith Kratochvil

Post by Keith Kratochvil
I would not break the RAID mirror.
--
Keith Kratochvil

Keith Kratochvil

2006-06-06 20:46:29 UTC

Permalink

No problem. You will probably find that there are a fair number of helpful
people out here.
--
Keith Kratochvil

Post by Shakes
Dont have backup tape drive. Just did backup to fixeddisk. Will copy files
to God. I'm able to share through file sharing for somereason , but as you
say not for the purpose of using god as a backup location.
Thanks for your help. Highly appreciated. Keep in touch.
Al

Shakes

2006-06-06 15:21:02 UTC

Permalink

That gives me all valid fixed drives. C: , H: , I: and X: with the
remaining free space.

Keith Kratochvil

2006-06-06 15:24:04 UTC

Permalink

Great. Can you do a "dir" and look at these locations?

exec master..xp_cmdshell 'dir X:\DATA\MSSQL\BACKUP\'

exec master..xp_cmdshell '\\God\Dell_backup_May06\BACKUP'

exec master..xp_cmdshell 'C:\BACKUP'
--
Keith Kratochvil

Post by Shakes
That gives me all valid fixed drives. C: , H: , I: and X: with the
remaining free space.

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have attached a copy
of the error log below. As you can see I am unable to start the backup. Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a
path
on
another win2000 server for the backup file, which did'nt work either. Please
HELP!!
2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).
2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system error = 3(The
system cannot find the path specified.).

Shakes

2006-06-06 15:50:02 UTC

Permalink

Here are the respective errors :

X:\
The system cannot find the path specified.

\\God....
The network path was not found.

'C:\BACKUP' is not recognized as an internal or external command,
operable program or batch file.

Post by Keith Kratochvil
Great. Can you do a "dir" and look at these locations?
exec master..xp_cmdshell 'dir X:\DATA\MSSQL\BACKUP\'
exec master..xp_cmdshell '\\God\Dell_backup_May06\BACKUP'
exec master..xp_cmdshell 'C:\BACKUP'
--
Keith Kratochvil

Post by Shakes
That gives me all valid fixed drives. C: , H: , I: and X: with the
remaining free space.

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have attached a copy
of the error log below. As you can see I am unable to start the backup. Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a
path
on
another win2000 server for the backup file, which did'nt work either. Please
HELP!!
2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).
2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system error = 3(The
system cannot find the path specified.).

Keith Kratochvil

2006-06-06 17:26:48 UTC

Permalink

oops, I forgot the "dir"

exec master..xp_cmdshell 'dir C:\'
exec master..xp_cmdshell 'dir C:\BACKUP'

exec master..xp_cmdshell 'dir \\God\Dell_backup_May06\BACKUP'
--
Keith Kratochvil

Post by Shakes
X:\
The system cannot find the path specified.
\\God....
The network path was not found.
'C:\BACKUP' is not recognized as an internal or external command,
operable program or batch file.

Post by Shakes
That gives me all valid fixed drives. C: , H: , I: and X: with the
remaining free space.

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have
attached a
copy
of the error log below. As you can see I am unable to start the
backup.
Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a
path
on
another win2000 server for the backup file, which did'nt work
either.
Please
HELP!!
2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).
2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system
error =
3(The
system cannot find the path specified.).

Shakes

2006-06-06 17:55:01 UTC

Permalink

Volume in drive C has no label.
Volume Serial Number is CCED-772F
NULL
Directory of C:\
NULL
04/29/2005 10:17 AM 0 AUTOEXEC.BAT
04/29/2005 10:17 AM 0 CONFIG.SYS
.....
08/31/2005 12:48 PM <DIR> Program Files
NULL

\\God...\...
The network path was not found.

Post by Keith Kratochvil
oops, I forgot the "dir"
exec master..xp_cmdshell 'dir C:\'
exec master..xp_cmdshell 'dir C:\BACKUP'
exec master..xp_cmdshell 'dir \\God\Dell_backup_May06\BACKUP'
--
Keith Kratochvil

Post by Shakes
That gives me all valid fixed drives. C: , H: , I: and X: with the
remaining free space.

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to get me
on the right track. I have never done this before. I am trying to creating
a complete backup of one of the SQL server databases. I have
attached a
copy
of the error log below. As you can see I am unable to start the
backup.
Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup. I've tried
to create the backup to a device by naming a file and also by just pointing
to a drive and giving it a file name.bak. I also tried specifying a
path
on
another win2000 server for the backup file, which did'nt work
either.
Please
HELP!!
2006-06-05 17:00:16.54 spid53 BackupDiskFile::OpenMedia: Backup device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
2006-06-06 10:19:26.33 spid53 BackupDiskFile::OpenMedia: Backup device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open. Operating
system error = 1326(Logon failure: unknown user name or bad password.).
2006-06-06 10:10:43.84 spid53 BackupDiskFile::CreateMedia: Backup device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system
error =
3(The
system cannot find the path specified.).

Keith Kratochvil

2006-06-06 19:29:44 UTC

Permalink

Cool. So, you can see your C drive but not the network (at least not the
path that you provided). Since you are not running on a domain you might
need to open up the file share on god so that everyone and everything has
rights to it.
--
Keith Kratochvil

Post by Shakes
Volume in drive C has no label.
Volume Serial Number is CCED-772F
NULL
Directory of C:\
NULL
04/29/2005 10:17 AM 0 AUTOEXEC.BAT
04/29/2005 10:17 AM 0 CONFIG.SYS
.....
08/31/2005 12:48 PM <DIR> Program Files
NULL
\\God...\...
The network path was not found.

Post by Shakes
That gives me all valid fixed drives. C: , H: , I: and X: with the
remaining free space.

Post by Shakes
I am in dire need of help. I hope someone can spare a few mins to
get
me
on the right track. I have never done this before. I am trying
to
creating
a complete backup of one of the SQL server databases. I have
attached a
copy
of the error log below. As you can see I am unable to start the
backup.
Can
you tell me
what the likely problem areas are ? Do you think this has something
to do with security or access ? I am logged into the server as
administrator and am trying to create the backup using Enterprise
Manager with a file location on one of the volumes on the server
itself. I do not have a domain, just a simple MS network setup.
I've
tried
to create the backup to a device by naming a file and also by
just
pointing
to a drive and giving it a file name.bak. I also tried specifying a
path
on
another win2000 server for the backup file, which did'nt work
either.
Please
HELP!!
Backup
device
'X:\DATA\MSSQL\BACKUP\enews05Jun06complete.bak' failed to open. Operating
system error = 3(The system cannot find the path specified.).
Backup
device
'\\God\Dell_backup_May06\BACKUP\eNews06Jun06.BAK' failed to open.
Operating
system error = 1326(Logon failure: unknown user name or bad password.).
Backup
device
'C:\BACKUP\eNews06Jun06.bak' failed to create. Operating system
error =
3(The
system cannot find the path specified.).