Re: Backup Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 15:36:42 +0200

Member of Adminstrators Group.(Domain Administrators)

"André Almeida Maldonado" <deweb@bol.com.br> wrote in message
news:uFh4sMi9DHA.3428@tk2msftngp13.phx.gbl...
>
> Is the sa account.......
>
>
> "Uri Dimant" <urid@iscar.co.il> escreveu na mensagem
> news:%23hIYJCi9DHA.3348@TK2MSFTNGP09.phx.gbl...
> > Hi
> > Make sure that appropriate file permissions are given to the account
under
> > which SQL Server was started.
> >
> >
> >
> > "André Almeida Maldonado" <deweb@bol.com.br> wrote in message
> > news:eMxTuwh9DHA.1592@TK2MSFTNGP10.phx.gbl...
> > > Hey Guys... So...
> > >
> > > I have to backup my database, and to do it, I'm executing this code:
> > >
> > > USE master
> > > EXEC sp_addumpdevice 'disk', 'backup_folder', 'c:\backup.dat'
> > >
> > > GO
> > >
> > > BACKUP DATABASE EVARTE
> > > TO backup_folder
> > >
> > > But I'm receiving the following error:
> > >
> > > Server: Msg 3201, Level 16, State 1, Line 2
> > > Cannot open backup device 'backup_folder'. Device error or device
> > off-line.
> > > See the SQL Server error log for more details.
> > > Server: Msg 3013, Level 16, State 1, Line 2
> > > BACKUP DATABASE is terminating abnormally.
> > >
> > > WHY????????
> > >
> > > My code is equal to the Sql Server Books Online example.....
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Event ID: 1202
    ... No mapping between account names and security IDs was ... SeIncreaseBasePriorityPrivilege = Administrators ... "Meinolf Weber" wrote: ... A user account in one or more Group policy objects (GPOs) could not ...
    (microsoft.public.win2000.active_directory)
  • Re: Rid AD of Circular Group Membership
    ... I'll try to keep this going; because it might be useful to another admin ... The quess is each has an account and uses it, ... part of stations) into the machine local Administrators group. ... Administrators Group has a members: ...
    (microsoft.public.windows.group_policy)
  • Re: Event ID: 1202
    ... No mapping between account names and security IDs was done. ... User Rights configuration completed with error. ... SeIncreaseBasePriorityPrivilege = Administrators ... unresolvable account exists only in one GPO. ...
    (microsoft.public.win2000.active_directory)
  • Re: Program Problems for non-administrators
    ... The user cant burn CDs because the media player absolutely wont function in her account but switch it to an administrator and all is well. ... User accounts will say they have an older version of a program but the administrators account says everything is up to speed. ... Quite simply, the installation routine for this application doesn't "know" how to handle individual user profiles, or the application tries to make changes to "off-limits" sections of the registry or protected Windows system folders. ... you can make this software available to other users by _copying_ the Start Menu folder and Desktop folder shortcuts from the user profile from which the software was installed in the corresponding folders in the user profilein which you'd like the software to be accessible. ...
    (microsoft.public.windowsxp.general)
  • Re: How to prevent ownership change by users with admin rights?
    ... I also have my private account on the ... > other private account is a member of the "Administrators" group. ... > I have created a private folder on the machine that has its security ...
    (microsoft.public.windowsxp.security_admin)