Re: Master backup failing but not user db backups (SQL Server 2000)
From: Hassan (fatima_ja_at_hotmail.com)
Date: 11/19/04
- Next message: Kalen Delaney: "Re: who can execute DBCC commands ?"
- Previous message: Hassan: "Re: who can execute DBCC commands ?"
- In reply to: Mike Hodgson: "Re: Master backup failing but not user db backups (SQL Server 2000)"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 18 Nov 2004 21:18:29 -0800
If you go to the SQL error log if will give more info such as the file may
be in use by another process,etc..
"Mike Hodgson" <mwh_junk@hotmail.com> wrote in message
news:eatEu6ezEHA.2936@TK2MSFTNGP10.phx.gbl...
> What are the NTFS permissions (I'm assuming you've formatted F: drive with
> NTFS) of the Master subdirectory? Has the NTFS permissions inheritance
> chain been broken at that point for some reason?
>
> I'd try logging on to the production box using the service account SQL
> server is running under and try writing a junk text file into
<F:\Microsoft
> SQL Server\MSSQL\BACKUP\Master>.
>
> The master DB is almost certainly fine (otherwise you'd have more obvious
> issues than not being able to back it up). It seems to me this is purely
> just an NTFS file system issue. Something to do with that particular
> directory. Can you back it up to a different directory?
>
> --
> Cheers,
> Mike
>
> "mdb777" <mdb777@discussions.microsoft.com> wrote in message
> news:4E942127-2202-4F86-B13E-FB42D7E90959@microsoft.com...
> >I am having problems with my master db backup. If I try to run it
(general
> > backup to file) I get this error.
> >
> > "Cannot open backup device 'F:\Microsoft SQL
Server\MSSQL\BACKUP\Master'.
> > Device error or device off-line. See the SQL Server error log for more
> > details. [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating
> > abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
> >
> > The weird thing is that I can backup all my other db's (including model,
> > msdb) using the same command and under the same user. They are backed
up
> > into the same parent directory and each have the same security. Why is
the
> > Master db giving me problems with this? The error seems
> >
> > I already removed the reference to attempting to repair small problems,
> > under the integrity tab on the backup wizard, which I found as a bug
> > listed
> > for SQL Server 2000.
> >
> > thanks for any help in advance
> >
> > mark
>
>
- Next message: Kalen Delaney: "Re: who can execute DBCC commands ?"
- Previous message: Hassan: "Re: who can execute DBCC commands ?"
- In reply to: Mike Hodgson: "Re: Master backup failing but not user db backups (SQL Server 2000)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
