Re: Automating SQL Service start and shut down

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

anonymous_at_discussions.microsoft.com
Date: 06/16/04 

Date: Wed, 16 Jun 2004 03:15:17 -0700

I didn't make myself very clear, sorry.

I need to backup the whole server, unattended late at
night. I didn't know how to schedule to turn off/on SQL
to ensure that the DBs were backed up along with the rest
of the server. If the service is running then the DBs are
skipped.

Many thanks for the feedback/advice. Its an approach I
wasn't aware of. :-)

>-----Original Message-----
>Why not just issue a Transact-SQL BACKUP command to
backup the databases to disk? You can come along with
your backup software and backup the backup files. This
is the best method, as "backups" taken of the database
and log files without performing sp_detach_db are not
guaranteed to be re-attachable. You can create jobs
within SQL Server that backup your databases to disk on a
particular schedule.
>
>Another benefit of the T-SQL BACKUP command is that the
server (and databases) remain available throughout the
process. You do not experience any downtime.
>
>
>
>--
>Keith
>
>
>"GW" <Graham.Wilcox@en-dc.co.uk> wrote in message
news:1c82601c452f4$4462ccc0$a301280a@phx.gbl...
>> Can anybody advise me on how to schedule the SQL
service
>> to close before a backup is run and restart afterwards?
>>
>> Many thanks
>.
>

Relevant Pages

  • Re: DB architecture for WSS sites on SPS server
    ... sharepoint servers or use it for other products such as SQL, ... Commvault will require a different server to be installed on (you dont ... We had purchased the Veritas SharePoint backup agent to plug into our ... recommended to create seperate databases for the content. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: DB architecture for WSS sites on SPS server
    ... sharepoint servers or use it for other products such as SQL, ... Commvault will require a different server to be installed on (you dont ... We had purchased the Veritas SharePoint backup agent to plug into our ... recommended to create seperate databases for the content. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: SBS 2008, Exchange Backup fails backup marked as completed suc
    ... I also dismounted both mail databases (public folders and mail ... and the /mh returned an info that the exchange backup hasn't been run ... There is another problem with the same server. ... No service has been started prior to the freeze ...
    (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: 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)