We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

backup exec - need help preparing for a possible restore

Medium Priority
369 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.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
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
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

Author

Commented:
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
CERTIFIED EXPERT

Commented:
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

Author

Commented:
thanks David,

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

Commented:
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
CERTIFIED EXPERT

Commented:
Many thanks David
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.