Re: Writing a script to stop and start a service

From: Axel Larson (Axel_at_office.reliasense.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 15:42:58 -0800

Since the Act! database is controlled by MSSQL service, the database is
either SQL or more likely, MDSE. If it is SQL, you can use Enterprise
Manager to schedule a database backup. You can either go directly to tape or
to a disk file that you backup to tape. If it is MSDE, www.msde.biz has an
MSDE Backup/Restore tool for $18. 

-- 
- Axel Larson
Contribute what you know,
  Learn what you don't
"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: Writing a script to stop and start a service
    ... If you register the database in SQL enterprise manager, ... Also, you're not completely ruined without a SQL native backup, SBS backup ... Here at my company we use Act! ...
    (microsoft.public.windows.server.sbs)
  • Re: ACT! 2005 Complaints with MS .Net
    ... > utilize that had not been carried forward to the new version, ... > Supposedly the previous versions of ACT! ... > complete code rewrite, and there have been many references to .Net being some ... The old database was pretty ghastly. ...
    (microsoft.public.dotnet.general)
  • Re: Writing a script to stop and start a service
    ... Yes it does use a SQL service but it is ... not actually a SQL database file. ... > Also, you're not completely ruined without a SQL native backup, SBS backup ... Here at my company we use Act! ...
    (microsoft.public.windows.server.sbs)
  • Re: Interfacing with act database using API (i think)
    ... Please refer to the SDK docs on those type libraries. ... My guess is what you should try first is using the tlbimp.exe tool to create interop assemblies for the TLB files supplied in Act SDK and then figuring out from the SDK docs what is the right way to use the COM automation interface. ... I need to interface with the act database and add ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Master Contact Database
    ... I haven't use act since ... Database Developer ... management of the outlook ... >> from the outlooks into a cvs ...
    (microsoft.public.office.misc)