Re: Windows 2000 Server Backup Utility

Tech-Archive recommends: Speed Up your PC by fixing your registry

The backup utility will backup everything you select, but can not backup active
files that are opened for exclusive access.

The backup will capture icons, which are just themselves small files in your profile
tree, as well as Microsoft Office program files and anything else in the selection list.
Just not exclusive-open files. You should review the backup log to see what is
being missed: There will be a few files such as DHCP temp files and such that
really won't matter in a restore scenario, but you need to check each one. Of course
be sure to backup "system state" which is vital for any disaster recovery situation.

SQL Server needs to be backed up specially, as the mdf/ldf database files are
normally locked open all the time by the SQL Server engine. The simplest way to
do this is to schedule a SQL management task to create a SQL backup file
periodically - daily for example - and these files will then be captured on the
regular backup. If you don't need the SQL engine running during the backup,
you can write a script that stops and restarts the SQL service to allow the backup
to capture the database and logfiles directly.

It needs to be noted that for any decent business-class backup, you need better software
than the bundled MS Backup. This stuff is all overpriced IMO (the major backup programs
now list at more than the operating system they run on), but still in all they pay for
themselves the first time you really need them.

Steve Duff, MCSE, MVP
Ergodic Systems, Inc.


"DRTP" <DRTP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:CBE3A112-BE9E-4D0D-83D0-6A4EE0DF03C0@xxxxxxxxxxxxxxxx
> Hi All,
>
> Thanks very for your replies to my previous question regarding Win 2K Server
> back-up. Its appreciated. Please excuse my continued ignorance but would
> appreciate if you could answer one more query I have.
>
> If say I have something like MS SQL or any another program such as MS Office
> on the machine and its backed up using Win 2K server back up utility if
> recovery is needed would it put the program execution icons back on the
> recovered machine or would it only return the files from the hard disk. I am
> trying to understand whether it would recover the files only from the hard
> disk or would it also recover the programs and software loaded on the machine
> such as MS Office as well.
>
> Thanks in advance once again.
>
> Regards,
>
> DRTP


.

Relevant Pages

  • Re: Backup erros
    ... You may have a SQL ... Error 800423f4 appears in the backup log file when you back up a volume by ... > Reason: The process cannot access the file because it is being used by> another process. ...
    (microsoft.public.windows.server.sbs)
  • Re: ISA server 2004 disaster recovery
    ... by the regular file backup. ... > The good news is that most any SQL disaster recovery mechanisms are valid for ISA MSDE. ...
    (microsoft.public.isa)
  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: SQL 2005 Failing Backups Because it Exits The Query Prematurely
    ... it might be a behavior change in SQL 2005. ... SQL 2005 Failing Backups Because it Exits The Query Prematurely ... This same application (which uses ODBC) is able to backup SQL 7.0 and SQL ...
    (microsoft.public.sqlserver.odbc)
  • Re: hi, need help
    ... manual hand-jam on the SQL backend through a discovered parameter. ... restore from that backup you took last week. ... ask the provider for a backup (if you dont have a backup ...
    (Security-Basics)