Re: Writing a script to stop and start a service

From: Les Connor [SBS Community Member] (les.connor_at_DEL.cfive.ca)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 16:47:07 -0600

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)