Re: Scheduled Task

Tech-Archive recommends: Fix windows errors by optimizing your registry

Basically the according to the vendor in order to back up their databse we
have to shutdown the service that is running. I normall have two batch files
to accomplish this task that run through a scheduled task and just want to
verify that the a scheduled task will run when the server is logged off.

"Vincent Xu [MSFT]" wrote:

Hi,

Normaly, when the scheduled task is configured well, I think it will work
if the server is just logged off (not shutdown). However, I think database
has its own backup plans. I'm not sure why you do it manually. Let us know
your concerns in detail that we can provide the correct information.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Date: Thu, 1 Jun 2006 20:48:19 +0000 (UTC)
Message-ID: <d3b0958617dbb8c8538007ca87ac@xxxxxxxxxxxxxxxxxxxx>
From: Ben M. Schorr - MVP <bens@xxxxxxxxxxxxxxxx>
Subject: Re: Scheduled Task
References: <5A02FB8C-69C6-4EE4-B250-F01919BA42F5@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 993.3
Newsgroups: microsoft.public.win2000.networking
NNTP-Posting-Host: rrcs-67-52-71-234.west.biz.rr.com 67.52.71.234
Lines: 1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.win2000.networking:91168
X-Tomcat-NG: microsoft.public.win2000.networking

Aloha George,

I'm not clear what your question is. Are you asking if the server that
hosts
the database is logged off will the scheduled tasks still run? I would
guess
not, but I'd need more information about what kind of server it is, what
kind of database it is and how you've set up your scheduled tasks.

Depending upon the type of database I would generally recommend a backup
solution that doesn't require the database to be shut down during
backups.
There can be all kinds of log file issues and other such that you may
have
to address if you're doing off-line backups.

-Ben-
Ben M. Schorr - MVP
http://www.rolandschorr.com
Microsoft OneNote FAQ: http://www.factplace.com/onenote.html

I have a database that I backup every night. I have two batch files
one to stop the service at the end of the day prior to the backup
strating and another one to strat the service once the backup
finishes. If I keep the server logged off with the scheduled task
still run.






.

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • RE: Adventures in Server restore
    ... SP1 for exchange change the db jet and should fix this problem ... > I thought I'd pass on my experience in bringing back an exchange server ... I'm not sure what happened (but a online backup was going on) ... > persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)