what do I need to backup when apply sp3 from sp2 in sql se..

No, you don't need to backup the system files of your SQL Server
installation.

In case you experience a problem and can't start your SQL Server services,
you have two options:
1) Uninstall the current installation and install a new SQL Server instance
with the same instance name
2) Install another SQL Server instance with a different name (as you can't
have two instances on the same system with the same names) and redirect your
users to the new instance.

After performing emergency 1 or 2 then you can restore your system and user
databases.

--
Ekrem Önsoy



"Iter" wrote in message

> Hi Guy,
> I want to inquire what do I need to backup when apply sp3 from sp2 in sql
> server 2005? I plan to backup all databases include system and user
> databases. Except these, what else do I need to backup? Such as sql server
> system files. Do I need to backup sql server system files? Thanks.
>