Tech Tip of the Day: How to create a new database in Microsoft Access 2010

Delete Restoration Data and Proceed to System Boot Menu Windows 7

A resume from hibernation is interrupted or fails to complete a resume. When you restart, the Windows Resume Loader appears.

1. When you restart your computer after a failed resume from hibernation you see the following window:
   
   
   
2. If you had any documents with unsaved changes you should try the "Continue with system resume" option. Use the arrow keys to highlight the option and press "Enter."
3. If it still fails to boot to Windows, turn the computer off and then on.
4. The Windows Resume Loader will come up again.
5. Make sure "Delete restoration data and proceed to system boot menu" is selected. If not, use the up and down arrows to highlight it and press "Enter."
6. Windows should start normally. Unfortunately, you may not be able to recover any unsaved changes to documents.

For more assistance contact Technical Support here.

Backups and Archiving

1) Plan your backup

The first step is to determine what needs to be backed up. How and what to backup are personal decisions based on how you use your computer. The following are some examples.

Basic system: Data only

Do you use your computer for personal use with its original factory configuration and perhaps an additional program or two? Consider a Data Only Backup Solution. Frequency of Backups would depend on how often information is added or changed. The more often you add or change files, the more often you should back them up. For programs like Outlook and Quicken, where it’s not obvious where their data are kept; their help files usually describe how to back them up.

Complex system: Hard drive imaging plus separate data backup

Do you have a large number of programs installed and/or complex configurations that would take many hours to recreate? Would you or your business suffer if you had to take the time to set everything up from scratch? Consider a disk imaging solution. A disk image, created with a program such as Symantec’s Ghost, is an exact copy of an entire hard drive. Create a new disk image every time a major system change is made. Then Backup your data as needed.

Business system: Automated, complete system backup

Does your computer contain real-time business data that changes frequently? Consider an automated software backup solution and redundant hardware systems. Implement a backup media rotation system and rotate a set off site. Super critical systems warrant complete backup computers and even entire off-premise facilities, called hot-sites.

Things to consider

Try to implement the simplest plan possible which will still accomplish your goals. The less effort it takes to back up your computer, the more likely you will have a current backup when you need it. For example: configure your applications so they keep their data in a central location. By doing this, a backup can be accomplished by simply copying that one folder to a blank CD.

The programs and operating system on your computer are interconnected. A portion (Just the OS or a single Application) will not function apart from the whole. Data files, on the other hand, are portable. Backup (and restore) either the entire computer or just the data; anything else won’t work. In addition, operating systems are unique to the machine on which they were installed. If you restore an OS onto a different computer, it most likely will not work. There are ways around this problem, but they are difficult to implement. If you are dealing with irreparable or stolen hardware, your most straightforward option is to install your programs onto a replacement computer and restore only data.

Even if you choose a complete disk backup solution, not all the files need to be backed up. Some commercial music or video files are encoded so they will only work on the unit where they were originally downloaded. Whether they can be used on a different or recovered system depends on the Digital Rights Management (DRM) scheme used. Also, things like the Internet Cache and temporary files folders have no value. Backing them up will only waste your time and space on your backup media.

2) Determine if backup software is necessary

For most basic backups, simply copying the files to external media is adequate. For more complex situations, backup software can provide added flexibility. Backup software allows you to specify what parts of your computer you wish to include and exclude from the backup. They allow you to make Incremental or Differential backups, where only the files that have changed since the last backup session are copied, speeding the backup process.

Most backup programs also have a schedule or timer feature, which can perform the backup after office hours. If the selected media cannot contain the entire archive, some programs allow backups to span multiple pieces of media. The resulting media can contain the following: Plain files (copy), disk images (Ghost), and archive files (backup programs). Everything except for the plain file copy requires using the creating program to restore files.

In order to restore a backup, you need a functioning computer. Some backup programs come with bootable disks, which will allow you to use a computer with a corrupted (non-bootable) operating system. Many programs even support performing a data restore over network connections.

3) Select where you are going to put your backup

Once you know what needs to be backed up and how you can select appropriate media, some things to consider include the following:

• Will the media hold the entire backup, or will you have to "babysit" and swap in blank media as needed?


• How long it will take to run the backup?


• Do you want multiple sets of backup media to rotate off-site? (This can be difficult with an external hard disk drive, but easier with tapes or recordable DVDs if the amount of data is not too great.)

Some people opt not to use removable media at all and instead synchronize their data across multiple computers, such as between their home and office. Others choose on-line data warehouses on the Internet where they can store their backups. And still others put their trust in redundant (mirrored) drive systems. In the end, it’s up to you to decide what’s right for you.

Media	Avg. Capacity	Speed	Pros and Cons
USB "Thumb" Drives	2GB and up	Fast	Small, easily lost or damaged
Recordable Optical Disks	650MB (CD) 4.7 - 9.4GB (DVD)	Medium	Inexpensive, easily damaged
Removable Disks	1.4MB (floppy) 500MB+ (MO)	Varies	Media can be expensive, availability issues
External Hard Drives	80 - 1TB	Very Fast	Huge capacity, fast, may not be very portable
Local Area Network (Shared server storage)	Varies	Medium	Requires network, ties up network bandwidth
Internet-Based Backup	Varies	Slow	Off-Site, accessible anywhere, requires broadband; ongoing cost
Network Attached Storage (NAS) Stand-Alone Storage (SAS)	Varies	Medium	Requires network, can tie up network bandwidth
RAID (mirroring)	Varies	Very Fast	Real time, requires no user intervention, no off-site storage or history

4) Make a recovery plan and recovery kit

The best time to determine how to restore a system is not in the middle of a crisis. Consider making a written plan of the steps necessary to restore your computer before it is needed. Keep this plan updated and, if possible, test it to make sure it works. In addition, test your backups, making sure the media is readable and that it contains everything it is supposed to.



If your hard drive fails catastrophically, having a current backup can be
critical.

Be aware that viruses and other malicious programs are just files on the
hard drive and can inadvertently be included. A comprehensive anti-virus package should be used on every computer.

Create a recovery kit and keep it in a secure, but accessible, location.
If your backup contains critical Business information, two copies are suggested, keep on on-site for immediate access, and a second copy off-site as a precaution against catastrophic events.

Your recovery kit should contain the following:

• An up-to-date copy of your recovery plan


• Operating System or restore CDs and product key


• All application installation CDs and their product keys


• All programs needed to recover the backup data


• Anything else needed to make this or another computer functional

Windows XP includes a backup utility that can save your files to removable media, a different hard drive, or a network drive.

Note: It does not directly support burning to recordable CD or DVD media.

Windows 7 Backup application adds an option to create an emergency boot disk and can make a complete system backup or incremental backup either at a scheduled time or on demand.



Backup 2.0.2 is available to .Mac members by selecting the Backup icon on the .Mac website and via Automatic Software Update to .Mac members who have already installed a previous version of Backup.

If you use OS X 10.5 or 10.6 and are a subscriber to MobileMe, download the current version of MobileMe Backup to keep items in your Home folder in sync across multiple computers and devices. This includes email, contacts, calendar, bookmarks and other content. To backup items outside of the Home folder, Apple suggests using Time Machine, which can back up your entire hard drive to a Time Capsule, hard drive, or network volume.

Data Recovery and Securing Your Personal Information

[caption id="attachment_315" align="aligncenter" width="257" caption="Erasing files is not enough. "][/caption]

It's getting dark outside; do you know where your data is?
Although various operating systems handle file allocation and directory organization differently, they all pretty much do the same thing when it comes to erasing data. To keep the process simple and fast when a file is "erased", the name is usually modified and the portion of the drive where the content is actually stored is simply made available to store new information on.

In other words, your data is not "gone" when you erase a file. Similarly, when you format a drive or even perform a full system recovery, data can still exist on the drive where new information has not been copied.

Data Recovery programs vary in their sophistication, from something as simple as un-erasing deleted files to scanning the "unused" data space for recognizable data. In either case, the program can only work as long as nothing has overwritten the information you are trying to recover.

Software programs such as RecoverSoft Data Rescue PC (Prosoft Engineering, Inc.), Recover My Files (Get Data) and Search and Recover (Iolo), typically have simple un-erase capability if the drive is partitioned as FAT, or can scan a drive looking for data still hiding in unused data areas.

Prosoft Engineering has a Mac and a Windows version of their Data Rescue software. Although, in some cases, the utility may not even need to recognize or specifically support the operating system, allowing it to find information on Linux, Macintosh, Windows, or other partition types.

[caption id="attachment_316" align="aligncenter" width="300" caption="Iolo Search and Recover 3 includes tools to make exact image copies of your drive and to perform quick or intensive file recovery of a drive."][/caption]

If the drive is physically damaged such as where the electronics have failed or the motor no longer spins, then these software programs cannot help at all. Under these circumstances, your only real alternative is to send the drive off to a company that can try things like replacing or repairing the defective electronics.

If you have the money and the need, they can go to the extreme, and physically remove the data platters from your drive and place them in an functioning unit to access the data. This type of clean-room recovery is usually very expensive, but may be worthwhile if your information is truly irreplaceable.

[caption id="attachment_318" align="aligncenter" width="300" caption="Physical damage to the drive platters makes it difficult to recover any data, even if the platters were to be moved to a functional drive mechanism. The damaged platters are likely to immediately destroy the heads in the new drive, and make the surface damage even worse."][/caption]

Physical damage to the drive platters makes it difficult to recover any data, even if the platters were to be moved to a functional drive mechanism. The damaged platters are likely to immediately destroy the heads in the new drive, and make the surface damage even worse.

It's not unusual for a drive platter transplant to cost users $1500-$2000 to recover their critical corporate data. If a head crashed and physically damaged the disk, it may not matter how much money you are willing to spend... damaged platters are generally a lost cause for recovery.

Some conditions can make it difficult for full recovery. What can you do to make recovery more successful or at least can minimize the degree of loss?:

• Stop saving to the drive. The most important condition is that no new data be saved on the drive until you can run a recovery program. Once your old data has been overwritten with new information, recovery is no longer really an option.


• Defragment your drive regularly. Depending on the type of file system and how large your files and drive are, fragmentation of your data could result in only partial recovery or of corrupted content. Performing a regular defragmentation of your hard drive keeps the data in your files contiguous on the disk, and therefore, much easier to recover.


• Don't encrypt files, or keep unencrypted backups of critical data.
  File encryption may protect your data from prying eyes, but it scrambles the contents of the data file, this would probably reduce your chances of recovery, at least where the application tries to identify file types by scanning for specific data headers.

Tips to improve your chances of recovering a file:

• Attempt recovery as quickly as possible. The longer a file goes unrecovered, the more chance that some other data will be saved over the top.


• Don't install, create, or copy anything new to a formatted or re-imaged drive.


• Recommended: If you have software like Symantec Ghost, or Acronis True Image, make an exact image copy (sometimes called a forensic copy) to an identical or larger drive. This gives you an additional backup to work with if things don't go well with the original drive. (Recovery programs should not alter the content of the source drive; having an exact copy provides some insurance against Murphy...)


• Have a spare drive or enough free space: recovery of your data will need to be to a target drive of equal or larger capacity. Some recovery programs will scan the source drive and give you an estimate of required space for the files.


• When all else fails - restore a backup (you DO have a backup, right?)

Is your privacy at risk?
The first time you successfully perform a data recovery on a drive and save data you were sure were gone, it can be a great relief. At least right up until the moment it sinks in that anyone with one of these products might be able to access your files, pictures, and other personal information on any drive you left in an old computer.

I already mentioned that formatting a drive or even restoring a factory system image only overwrites only a small portion of the data on the disk. Any unused space on the drive may hold data that can be rediscovered, and copied off for good, malicious, or just voyeuristic reasons.

If it's so easy to recover files you thought lost or erased, what about securing data on hard drives you might have in old computers or external enclosures or even flash drives? There are several different ways to approach securing your old data drives.

1. Encryption: If you actively use or need access to the information, data encryption may be the easiest. File level encryption may be tied to a user login under your operating system. But encryption is more useful when you can move and maintain the scrambled file between systems, drives, and even to optical media or flash drives. Stand alone-encryption programs use a password to scramble and unscramble your information on demand, as long as you have the program installed on the system with the data.


2. Low level format: Another approach is to wipe or low-level format the drive.


3. Physically destruction: The last and most permanent method is physical destruction of the drive media.

Encryption: A variety of options exist to encrypt files. Windows NT, 2000, and XP Pro all have built-in encryption, but this requires that the drive be formatted NTFS. It is limited in that the OS-level encryption is only in place as long as the files remain on the drive.

If you move or copy an encrypted file to another drive, floppy disk, flash disk or optical media, the operating system removes the encryption to perform the copy.

If you have a version of the OS that does not support Encryption, or you want to keep your files scrambled even if they move, then you usually need some sort of third-party encryption program. This will allow you to password protect files or create encrypted archives with multiple files.

Kubicki Turbo Encrypter and TrueCrypt (free on download.cnet.com) are just a couple of the titles available for stand-alone encryption. Encryption is generally overkill for most users, but concerns about private information getting into the wrong hands make such methods more desirable for some.

Secure Wiping: Programs that securely wipe data can help make sure it does not turn up again later. These promise security because they will specifically target the existing file on the drive and deliberately save null or random information over the top before deleting the file. There are degrees of security available with most of these programs; depending on how many times information is written.

Most wiping programs will either use a "government acceptable standard" of scrambling and rewriting the surface of the disk enough times, that not even spies in high-tech laboratories will be likely to guess what had been previously saved on the drive. This presumes that there really do exist high-tech methods that could be used to determine if the random characters of information found on a disk platter really used to be a 1 and not a 0, and putting enough of these back together to make something coherent.

Programs that can securely wipe your data before erasing include DriveScrubber and System Mechanic (Iolo); Older programs like Symantec System Works or Norton Utilities both contained a wipe-info tool; and a quick search of download.cnet.com will even turn up free apps like Blowfish or Simple File Shredder.

[caption id="attachment_320" align="aligncenter" width="300" caption="Iolo Drive Scrubber is a tool to securely erase all of a drive or just unused space where your personal data might still exist even after being erased or formatted."][/caption]

 

Low Level Format: For the average user, even a single pass recording of (random) information over your files will equal permanent loss in terms of software programs that an average user or even computer hacker might have access. One tool that can be found on many hard drive manufacturer sites is a low-level format utility or diagnostic utility that performs a similar function.

Low level formatting of a drive will write zeros to every sector of the target drive to verify there are no bad or unusable blocks. Some drive diagnostic programs may do the same thing, by destructive (loss of data) testing of every sector with multiple data patterns to make sure the data read matches what was written. Fujitsu, Western Digital, Seagate (Maxtor) all have some sort of low-level format tool or diagnostic you can download that are specific to their brand of drive.

Physical Destruction: If your drive failed, but at one time had private information on it, you won't be able to perform a secure wipe of the information or low-level format the drive. Under these circumstances, about the only way to guarantee that your data does not get out, is to physically destroy the drive.

Have fun! Bash it with a sledge hammer or drill holes through the platters. Some hard drive platters are made of glass rather than aluminum, and will shatter when you "execute" this type of abuse on them.

I usually just like to disassemble them into interesting or useful parts, pulling the platters and magnets out. (I also try to look for anything that might be artistic in appearance for use in a case mod or other project.) Check for local regulations on disposing of electronics and what may be considered hazardous waste in your state or area; this may limit your options a bit.

 

[caption id="attachment_321" align="aligncenter" width="300" caption="Some hard drive platters are glass, not metal. It's unlikely any data is coming back from the one on the left."][/caption]

Tips to protect your data and your privacy:

• Encrypt data you use or need to access regularly. Stand-alone encryption software is required to use the information on multiple systems, or to move it to different media such as flash drives or CD-ROM without losing the encryption.


• Securely Wipe individual files, wipe disks before disposal, wipe free space periodically to destroy old information.


• When disposing of old drives or systems with hard drives, disk wipe or low level format the drive before reimaging with the factory recovery.


• Networking:
  
  
  
  • Share folders, not drives; restrict access with passwords; use read-only unless changes are needed
  
  
  • Turn off WiFi routers when not in use and use the highest possible security to prevent easy access to your network.
  
  
  
  


• Use both Anti-Virus and Anti-Malware protection and keep your OS current with critical updates


• Data backup anything you cannot afford to lose. Keep copies of your backup media or drives in a secure location.