Re: Database Backup

From: lauren (lfisher@press.plconline.com)
Date: 03/10/03 

From: "lauren" <lfisher@press.plconline.com>
Date: Mon, 10 Mar 2003 10:01:13 -0800

Tom,

Thank you for responding. As far what the domain account
is, I don't know why that affects it. We just have one
domain account here and it should have the permissions to
write to the folder, it always did before. The SQL
program was backing up the database until about a month
ago. The last time it backed up was on Feb 11, 2003. We
had a bad snow storm that caused some problems, so maybe
that could have affected it.

Since it keeps giving an Operating System error = 2, would
I be able to fix the problem by putting in the OS cd and
running a repair on the SQL server OS. I was able to do a
windows backup, where I just saved the hard drive space
and the system state. that way the data won't be lost if
anything were to happen with the SQL cd.

But anyway, yet the file that the database was backee up
to is local.

So, what do you think?

lauren
>-----Original Message-----
>It is possible that SQL Server does not have read/write
permission in the directory. What domain account are you
using for the MSSQLServer service and does it have
permission to write to the folder? Is the folder local or
on another machine?
>
>--
>Tom
>
>----------------------------------------------------------
-----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada tom@cips.ca
>www.pinnaclepublishing.com/sql
>
> "Lauren" <lfisher@press.plconline.com> wrote in message
news:051801c2e720$02ad0b60$a401280a@phx.gbl...
> Hi,
> I have a Windows 2000 Server machine with SQl Server
> installed as well.
>
> I am trying to backup the database, but everytime I
tell
> it to backup nothing happens and when I look in the
backup
> folder there is nothing there.
>
> I have looked at the log files and the error messages
that
> appear say Operating System Error - 2(can't find the
file
> specified).
>
> If there is anyway someone could help me out with this,
I
> would greatly appreciate any insight to this dilemma
>
> Thanks
> Lauren
>

Relevant Pages

  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
  • Re: Backu plan
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > but if i use the codes, the folder will have so many backup files after ... >> Why not simply use a different file name for each backup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Why BACKUP do not work to NET folder ?
    ... SQL Server does not have permission to write to the folder ... Wayne Snyder, MCDBA, SQL Server MVP ... > Why BACKUP is not work to NET folder of computer named GLOBUS? ...
    (microsoft.public.sqlserver.server)
  • Re: Service account in cluster sql 2008
    ... In most cases people define a domain account with an appropriate permissions ... (to backup to ohter computer and etc..) ... SQL Server Agent ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error while generating Snapshot
    ... another box then it'll need to be a domain account with the correct ... impersonating it in the sql server agent and not using a proxy (SQL Server ... in the creation of the snapshot folder. ... full and no account can create a folder in the snapshot share - can you just ...
    (microsoft.public.sqlserver.replication)