Solved

backup exec - need help preparing for a possible restore

Posted on 2006-10-25
8
340 Views
Last Modified: 2013-12-01
Greetings.

I am facing a possible failure of another disk on a Raid 5 (down to 3 at the moment) that might push it over the edge!

I am running SBS 2000 and using backup exec 8.6 server edition.

I need a complete and useful backup on standby in case i have to reinstall.

I am happy with the general back ups i have done for the sql server and general websites.

I am new to all of this so pls tell me the best way to end up with a back up that will restore the whole database without problems.


Thanks for any guidance you can offer.
0
Comment
Question by:sunny-j
  • 4
  • 3
8 Comments
 
LVL 12

Assisted Solution

by:WallD
WallD earned 250 total points
ID: 17802375
You will need to do a full backup so you need to backup the whole machine including the system state and the registry, This will enable you to restore the whole machine should the need arise.

David
0
 

Author Comment

by:sunny-j
ID: 17802866
Ok, so in addition to the E drive and sql server back ups, i am going to run a backup to copy the C drive plus the system state. Will that cover the registry or is that covered within the system state? Is there any other considerations? Apart from verifying the backup after running the back up, is there a way to text the data is ok bearing in mind i don't have another machine to restore it too. Thanks David.  Much appreciated. J
0
 
LVL 9

Accepted Solution

by:
IPKON_Networks earned 250 total points
ID: 17802911
Why don't you replace the failed drive to restore you resilience in RAID 5.
Generally, I would do the following for SQL server if you are looking for a full system backup. Remove the bits not relevant to your server config.

1. Using BE agent on server, with direct attached, or networked tape drive/library
2. In SQL perform a System Dump to a spare portion of disk
3. Pause the SQL server
4. configure your backup job to do the following streams
  a. system state of c: drive (registry and DLL's)
  b. full c: drive backup (all binaries and boot drive files)
  c. full d: drive backup (assuming SQL server binaries are on d: drive)
  d. full backup of all transaction files (e: drive)
  e. full backup of all dump files (f: drive)

This should be good enough to recover the server to a point in time that you know will work. As the SQL service will be paused, there is no real need to do and backup the dump files. However, I have found these to be useful if you have problems restarting the system following a checkpoint restart.

Hope this helps
Barny
0
 

Author Comment

by:sunny-j
ID: 17802969
Thanks Barny

This is super. I will replace the drive. The drive that i will replace it with will not be a new one but one that i am sure has been wiped but haven't had a chance to check. Will the system simply rebuild it without damaging the other drives. Sorry for the extra question. Will close on your reply. Thanks. J
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 12

Expert Comment

by:WallD
ID: 17804829
Providing the raid is setup on a hardware raid you should get the array to rebuild itself, can you provide details of your hardware setup, please.

David
0
 

Author Comment

by:sunny-j
ID: 17804921
thanks David,

Compaq Proliant 8000. It has smartstart installed but it would be good to expand the raid from windows. Thanks.
0
 
LVL 12

Expert Comment

by:WallD
ID: 17806811
If you have a compaq proliant it is liekly you have a compaq raid card.

Look through the programs and see if you have any hp apps such as HP array configuration array manager.

in there you can see manage your arrays .


David
0
 
LVL 12

Expert Comment

by:WallD
ID: 17810363
Many thanks David
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now