Re: Database Backup

From: Tom Moreau (tom@dont.spam.me.cips.ca)
Date: 03/10/03 

From: "Tom Moreau" <tom@dont.spam.me.cips.ca>
Date: Mon, 10 Mar 2003 13:06:52 -0500

Have you checked the actual permissions for the folder? Also, try running the MSSQLServer service under Local System (for now). If that works, try setting it back to the original domain account.

There is a possibility that there are some OD issues, perhaps some corruption if there was a power failure and you didn't have a UPS. 

-- 
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:03ec01c2e72f$09bc26c0$3401280a@phx.gbl...
  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: Backups HELP!
    ... One of your customer has encountered a backup issue on the SBS 2003 ... all child objects have inheritable permissions from the parent to propagate ... How to take ownership of a folder ... To take ownership of a folder, ...
    (microsoft.public.windows.server.sbs)
  • Re: Backups HELP!
    ... One of your customer has encountered a backup issue on the SBS 2003 ... all child objects have inheritable permissions from the parent to propagate ... How to take ownership of a folder ... To take ownership of a folder, ...
    (microsoft.public.windows.server.sbs)
  • Re: Clients overwrite default AD permissions intermittantly
    ... The "shared file array" is our file server storage volume. ... "Backup Domain" is that our backup is performed from a backup server ... I said AD permissions just to be brief. ... Also, other files in that folder will have the "default" permissions, ...
    (comp.os.ms-windows.nt.admin.security)
  • Re: Backup permission
    ... Other thing that i dont understand is that when a user is ... >to do backup is you are db_backupoerator. ... >Tibor Karaszi, SQL Server MVP ... >that this user have 'Sysadmin' permissions, ...
    (microsoft.public.sqlserver.server)
  • Re: Location for shared Access database
    ... Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network? ... I don't think that the "Programs" folder is the right place. ... For a network-shared database, use SQL Server instead: ... This will work on Vista as well, although you'll need to adjust the local folder permissions since users don't have write permissions on c:\ by default. ...
    (microsoft.public.dotnet.languages.vb)