• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

What kind of files have to be backed up on 2003 servers in order to reconstruct the server in the even of hardware failure.

I have a primary DC, secondary DCs, few Terminal servers, few  other servers running general applications. I want to start backing up important files/system state  from the servers so that in case of hardware failure, i should be able to restore the same functionality on new server. All the machines are win 2003 servers. Any information on how to back up mssql and mysql will be appreciated. I am planning on developing a back up plan for the servers. so any important information on backing up server is welcome.
0
kiranjana
Asked:
kiranjana
  • 2
  • 2
2 Solutions
 
David ToddSenior DBACommented:
Hi,

MS SQL has its own backup.

The catch is, you can't just copy the live data-files to tape. They won't recover.

The simplest approach with smallish databases is to use the SQL backup command to back up the databases to disk, and then use whatever backup system to copy those backup files to tape.

HTH
  David
0
 
TAB8Commented:
You also need to backup the system state data (registry) if you want to just restore the whole server rather than restore just a databse
0
 
kiranjanaAuthor Commented:
Thank you for the suggestions. Can you help me finding step by step instructions on how to backup the system state data. Todd, would appreciate any information on sql backup command. thank you once again.
kj
0
 
kiranjanaAuthor Commented:
Also, how often will i have to make a backup of that system state data.
Thank you
kj
0
 
David ToddSenior DBACommented:
Hi,

My guess is that the system state should be backed up at least weekly. It wont change that much. But since it is relatviely small, then it should be backed up with most backups.

SQL Backup looks something like this:
-- ===========================
-- Backup Database Template
-- ===========================
BACKUP DATABASE <Database_Name, sysname, Database_Name>
      TO  DISK = N'<Backup_Path,,C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\><Database_Name, sysname, Database_Name>.bak'
WITH
      NOFORMAT,
      NOINIT,  
      NAME = N'<Database_Name, sysname, Database_Name>-Full Database Backup',
      SKIP,
      STATS = 10;
GO

This was taken from the SSMS 2005 templates. The <> (angle brackets) denote things that need to be changed for the SQL to execute. It would look something like this

-- ===========================
-- Backup Database Template
-- ===========================
BACKUP DATABASE YourDatabaseName
      TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\YourDatabaseName.bak'
WITH
      NOFORMAT,
      NOINIT,  
      NAME = N'YourDatabaseName-Full Database Backup',
      SKIP,
      STATS = 10;
GO

HTH
  David
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now