Windows 2000 Backup

  • Thread starter Thread starter Do
  • Start date Start date
D

Do

Hi,

For processes such as IIS and SQL Server,
are there services that I need to stop before doing a backup
in order to backup all files and data successfully?

For SQL Server, should I do a database backup
before doing to file backup?

Is scripting the best way to approach all of this?

Thanks,

Do
 
Depends on what Backup product you are using and whether
they are aware of open files from IIS or SQL. To be safe,
you could stop the services before you backup. AFAIK, In
SQL, you can backup a live database (to files) and then have
your backup software back up those files.

--
--
Daniel Chang
Server Setup Team

Search our Knowledge Base at
http://support.microsoft.com/directory
Visit the Windows 2000 Homepage at
http://www.microsoft.com/windows2000/default.asp
See the Windows NT Homepage at
http://www.microsoft.com/ntserver/

NOTE: Please reply to the newsgroup and not directly to me.
This allows others to add to and benefit from these threads
and also helps to ensure a more timely response. Thank you!
This posting is provided "AS IS" without warranty either
expressed or implied, including, but not limited to, the
implied warranties of merchantability or fitness for a
particular purpose.
The views and opinions expressed in this newsgroup posting
are mine and do not necessarily express or reflect the views
and / or opinions of Microsoft.


: Hi,
:
: For processes such as IIS and SQL Server,
: are there services that I need to stop before doing a
backup
: in order to backup all files and data successfully?
:
: For SQL Server, should I do a database backup
: before doing to file backup?
:
: Is scripting the best way to approach all of this?
:
: Thanks,
:
: Do
:
:
 
Hi:

I'm simply using the Windows 2000 Backup and Recovery Tools.
Should I run a batch file in my scheduler and upon completion of the stop,
do the file system backup of IIS, and then start it up after?

I'm going to do what you mentioned for SQL Server.

Do
 
I'm simply using the Windows 2000 Backup and Recovery Tools.
Should I run a batch file in my scheduler and upon completion of the stop,
do the file system backup of IIS, and then start it up after?

I'm going to do what you mentioned for SQL Server.
Click to expand...
There is generally no need to stop services. A backup is for static
data rather than temporary files. If you have an application that
keeps files open and doesn't checkpoint and log them, perhaps you
should upgrade it!

One way to check would be to do a full backup, then see what files got
missed because they were open. Categorise them and see if any of them
would be a disaster if they were lost. If so, stop the application
before backup and restart it afterwards.

IIS is generally not a problem.

Cheers,

Cliff
 
Back
Top