Re: Scheduled Backup for SQL Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 09/30/04 

Date: Thu, 30 Sep 2004 02:33:05 -0700

Yes they are both started by local administrator and the
local administrator owns the backup job as well
>-----Original Message-----
>Is the SQL Server Agent service startup account the same
account as the SQL
>Server service?
>
>--
>Peter Yeoh
>http://www.yohz.com
>Need smaller SQL2K backup files? Use MiniSQLBackup
Lite, free!
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:45ec01c4a634$9c1441e0$a301280a@phx.gbl...
>> Hi,
>>
>> The backup is just running to another drive on the same
>> machine. My nightly backup routine goes and copies that
>> directory to the central server for nightly backup
>> >-----Original Message-----
>> >Hi
>> >
>> >Make sure that the agent is running on a domain
account
>> that has access to
>> >the other server. Are you
>> using '\\machinename\sharename\file.bak' (UNC path)
>> >as your naming standard for the backup file?
>> >
>> >You can not make a maintenance plan that uses a UNC
>> share, so you have to
>> >code it manually and setup a job (see BOL for BACKUP
>> DATABASE).
>> >
>> >Cheers
>> >Mike
>> >
>> >"Chris" wrote:
>> >
>> >> Hi All,
>> >>
>> >> Very new user to SQL admin. I need to backup a sql
>> >> database, when I run it manually it runs fine and
>> creates
>> >> a backup without any issue. However when I try to
>> >> schedule the job it does not save the schedule or
run
>> the
>> >> backup.
>> >>
>> >> I am using Windows 2000 Server and SQL2000. Both are
>> >> fully patched and have latest service packs.
>> >>
>> >> Am I doing something wrong or is this a bug. The SQL
>> >> agent is running on the local machine, and the job
>> >> appears in the backup list but always fails. I am
>> trying
>> >> to write to another data disk on the server with the
>> >> routine to overwrite the file everytime.
>> >>
>> >> Any help would be great
>> >>
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: Move from POP3 Connector to Exchange SMTP
    ... Do I need to account for all these alias accounts right form the start? ... If we setup a POP3 account for a backup MX we could read and reply to mail but we would need to keep the accounts in sync with exchange which kind of defeats the purpose. ... If their server cannot contact your server they should get a 'delivery delayed' message at periods defined by their mail admin. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS Back up Failure
    ... attached the log and report from yesterday's backup also. ... One or more components of Small Business Server Backup failed. ... recommended that you review errors in the Event log related to the service. ... Notifications task in the Server Management Monitoring and Reporting taskpad. ...
    (microsoft.public.windows.server.sbs)
  • Re: Backup Exec question on SBS 2003, Backup Failed 0xe000fe29
    ... Make sure that the user account has the appropriate ... Keep in mind, this is a single server, no remote agents, no netware, ... if when defining the backup I use the "test" access ... But the backup always fails. ...
    (microsoft.public.windows.server.sbs)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... Well, it turns out the RDP connection dropping issue won't go away, ... level to the server in the office may have an affect on the issue. ... I just remembered I also re-installed RDP Client V6 last night as ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... I left the connection sit idle and checked back in an hour. ... server and browsed around for a few minutes. ... it would seem that there is still some issue with the V6 RDP ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)