Backing up "instance" of sql server

[sqlgracie]

Hi,

I think what I need clarification on is how to back up an "instance" of sql server. This is the recommendation before upgrading to 2005.

What does backing up an "instance" involve? Obviously, the user db's, but everything else as well? Is there a step by step FAQ that discusses this, and also how to restore the entire instance, if necessary? If I end up in this situation, I would like to have everything clearly outlined!

THANKS MUCH

 

[mrdenny]

Backup the system and userdatabases (except for tempdb).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com