Re: Writing a script to stop and start a service

From: Allen M (allenmiyake_at_majaro.com)
Date: 12/16/04


Date: Thu, 16 Dec 2004 15:14:32 -0800

Hi Les,
Thanks but I'm not sure this is an answer to my dilema. Not sure how to put
this as it isn't to clear to myself. Yes it does use a SQL service but it is
not actually a SQL database file. huh???? Don't ask me to explain as when
they tried it to me I could say was huh!!!! No offense but I do need to do
it the way I explained and am still looking for an example of the command
line I need in my bat file. thanks for the attempt but I am not looking for
an alternative.

"Les Connor [SBS Community Member]" <les.connor@DEL.cfive.ca> wrote in
message news:%235RBuE84EHA.4040@TK2MSFTNGP14.phx.gbl...
> If you register the database in SQL enterprise manager, you should be able
> to schedule a backup there (I think - SQL is not my forte).
>
> Also, you're not completely ruined without a SQL native backup, SBS backup
> will be backing up the whole thing via VSS. In fact, you've probably even
> got previous versions you may or may not know about. I have used previous
> versions to successfully recover Pervasive SQL databases.
>
> --
> Les Connor [SBS Community Member]
> -----------------------------------------------------------
> SBS Rocks !
>
>
> "Allen M" <allenmiyake@majaro.com> wrote in message
> news:ukDCa$74EHA.3840@tk2msftngp13.phx.gbl...
>> OK here's is my dilema and scenario. Here at my company we use Act! 2005.
>> My boss is a big fan of Act! and has been since it's first DOS release.
>> Which means his whole life is in it's database so you can guess how
>> important it is to him that I get this database backed up regulary. With
>> Act! 2005 there is no atuomated way to backup. You must manually backup
>> the database file within the program and save it to a location where it
>> can then be backed up by an automated device. I know sounds stupid but I
>> did verify it with Act! tech support. Here's an added bonus for any of
>> you who are using Act! or have been thinking of doing so. They (the Act!
>> people) do not consider this an issue. Go figure. Valuable and sensitive
>> data that cannot be automated to be backed up to tape or any other
>> device.
>> So what I found out is that if I stop the MSSQL service for Act! that I
>> can then copy the file any way I want to. So with that said I want to
>> create a batch file to stop and start the service so that I can use my
>> tape device to automate the backup. I would use Task Scheduler to stop
>> the service before my backup begins and another schedule task to restart
>> it after it is finished. What is the command line I need to create to
>> stop and start this service? Thanks as I'm sure one of you great SBS'ers
>> got that line.
>>
>>
>
>



Relevant Pages

  • 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: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: Does NTBackup backup SQL Express?
    ... schedule backups of the SQL databases which were written to a backup ... models you would have to backup and flush things manually. ... if you load the backup set does the database appear to be ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Does NTBackup backup SQL Express?
    ... as I know enough that the logs must be flushed during every full backup. ... and the SBS server I regularly use runs MySQL not SQL ... if you load the backup set does the database appear to be listed ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT: SQL 6.5 Server Crash
    ... > Are these database backup done by SQL Server? ... > Or file backups performed by some Windows backup software? ... were they performed while SQL Server was running? ...
    (microsoft.public.sqlserver.server)