Scheduling backup of SQL 2005 while database is in use

I use a patch scanner/deployer, Shavlik NetChk, with a SQL 2005 w/SP1
backend. This is setup on a server 2003 w/SP1 computer with multiple drives
for OS, APP, SQL, LOGS, SWAP.

I run this at odd times, but, would like to also schedule a maintenance plan
to run on a regular basis, and can't really plan on any particular time for
the server to be "quiet".

Should I just setup and schedule a plan, trusting on SQL and VSS to allow
things to work, especially the backups, while in use?

I presume I should schedule one maintenance plan to do everything but the
transaction log, and, another to do the log.

The Books On Line section on this seems WAY overly complicated in this
area...

Thanks.


.

Relevant Pages

  • SQL 2005 Database Mail Fails - HERES HELP - Maintenance Plan, SMTP
    ... Here is how I got SQL 2005 Database Mail to work .... ... Send email from Database Maintenance Plan. ... Computer B = Windowns 2003 Server with a named instance of SQL Server ...
    (microsoft.public.sqlserver.setup)
  • SQL Server 2005 CTP Installation
    ... nachdem ich mich vor einer Weile schon einmal mit der Installation der SQL ... Refer to server error logs and setup logs for more information. ...
    (microsoft.public.de.sqlserver)
  • Re: SQL Server Developer Edtn 2005 - WMI Error during installation - Error:2147500034 (0x800
    ... Here is some information from the Log files that are created from the SQL ... Server setup (C:\Program Files\Microsoft SQL Server\90\Setup ... Condition "Setup is running locally." ... Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp ...
    (microsoft.public.sqlserver.setup)
  • RE: migrating from wmsde to sql server
    ... but should I not be able to see a compnayweb instance in SQL ... I understand that the SQL Server 2000 Setup Control ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Domain or Workgroup
    ... What is your current infrastructure setup? ... Administrators or would you be administering the domain? ... How many SQL ... or to remain in their work group and access SQL Server through Server ...
    (microsoft.public.sqlserver.clients)
Loading