Home » Archive by category "Backups"

Hurricane Sandy

As the entire east coast prepares or was hit by hurricane Sandy we urge everyone to be safe and take precautions

  1. If you have an infant on a bottle, have enough bottles on hand so that you won’t have to worry about how you can wash them if there is no clean water. And be sure to either have single use sized cans of formula, or an ice chest with plenty of ice to store any opened cans of formula.
  2. Stock up on anti-bacterial hand wipes, gel hand cleaners and paper towels in the event there is no water for washing or bathing.
  3. Have a two week supply of any prescription medications, as well as personal care items (tooth brushes and paste, hygiene products, etc.).
  4. Have a well stocked first aid kit in the event of injuries. Disinfectants, antiseptics, antibiotic creams, bandanges, cotton balls, aspirin, Tylenol, and a thermometer are some of the basics you need.
  5. Make sure all vehicles have a full gas tank.
  6. Have several changes of clothing for each member of the household, and if you have a baby still in diapers, have a two week supply on hand.
  7. Go over emergency instructions with everyone in the household
  8. Make sure everyone is accounted for at all times
  9. Since water/flooding caused by tidal surge is the leading cause of death and destruction in hurricanes, it is crucial to be aware of your surroundings. If you observe water coming into your house, get to an upper floor immediately.
  10. If you have pets that stay outside, bring them in during the storm
  11. Have enough cash on hand to last for a while in the event you can’t get to the bank or an ATM.
  12. Secure all outdoor furniture to reduce the amount of damage to it, and to help prevent it from being thrown against your (or someone else’s) home, and causing more damage to the exterior of the home and the outdoor furniture.
  13. Stock up on bottled water, as well as non-perishable foods that can be prepared and eaten without having to be cooked. Be sure to have enough food and water to last for everyone in the home for a week, including pets. And don’t forget a can opener and a clean, sharp pocket knife.
  14. Stock up on battery powered flashlights, candles, and have a battery powered radio.
  15. Secure all outdoor furniture to reduce the amount of damage to it, and to help prevent it from being thrown against your (or someone else’s) home, and causing more damage to the exterior of the home and the outdoor furniture.

I know hams like myself have already been activated and ask to be on standby if communications go down and to run emergency communications for counties.  We have our go kits ready with 2 meter radios and j-pole antennas.

Ham radio operators were very important in the North Carolina Area when Sandy ripped thru there around October 26, 2012.  They were put on standby because amateur radio is reliable means of communications in emergencies since they do not rely on wires only on airwaves, and can be run on battery for a very long time.

Businesses are already thing disaster recovery filling generators, preparing warm sites, getting off site backup done making sure that if they lose power or internet connection they can continue running their business or protect their business by not losing data.  We are hosted on the west coast so our servers will stay dry and safe at all times.

I have already been told it could be 7 to 10 days without power.  Everyone be safe and be ready.

NetBackup Status Code 2 none of the requested files were backed up

STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 “none of the requested files were backed up”

SQL Client Configuration:
1. Configure the NetBackup client service (Admin ToolsServices) to run as the account that you are logged in as and then restart the service (Figure 1).
Figure 1

2. Open the NetBackup MS SQL GUI a prompt to ‘set your DBMS Login Parameters‘ will appear.  Reenter the same account info that the NetBackup client service is running as (Figure 2).
Figure 2

3. Choose ActionsBackupDatabase and select the database(s) to be backed up, enter the policy name (this is optional) and select ‘save for later execution‘ and then click on OK.  Enter a file name and then save.  If the script is saved in the default location, only the script name is necessary to be referenced in the policy.

4. Client configuration portion is now completed, please perform the next steps from the NetBackup Administration Console.

MS-SQL-Server Policy Configuration:
1. OpenCreate a MS-SQL-Server policy.  Verify that the Default-Application-Backup schedule is set to 24 x 7 and add a new schedule type ‘automatic backup‘ and set the start window to the desired schedule in which SQL backups are to be run.
2. On the Clients tab addverify that the client name is entered correctly.
3. On the Backup Selections tab, enter the name of the backup script that was created on the client (i.e. backup.bch).  NetBackup will look for this script in the default location on the client to run it.

NOTE:  If backing up multiple clients with a single policy then there must be a common script name on each of the clients listed!  The contents of each script will be unique for each client. For example: a policy exists on one SQL client with a script named DailyFull.bch in the default directory of ‘C:Program FilesVERITASNetBackupDbExtMsSql‘.  A month later, another SQL server is added with the above client configuration steps. The .bch file is saved on the new client as DailyFull.bch in the default directory.  At this point, it is only necessary to add the client name to the ‘Clients‘ tab of the MS-SQL-Server policy.  Figure 3 is an example of an MS-SQL-Server policy properly configured to backup multiple clients.
Figure 3

NetBackup SQL agent backup configuration is now completed, right click on the policy and choose ‘Manual Backup‘ to test.

Using Task Scheduler to schedule the computer to shut down and restart at a specific time

  1. Click Start, Run and type control schedtasks
  2. Double-click Add Scheduled Task. The Scheduled Task Wizard starts.
  3. Click Next.
  4. Under Click the program you want Windows to run, click Browse.
  5. In the Select Program to Schedule dialog box, locate the %SystemRoot%System32 folder, locate and click the Shutdown.exe file, and then click Open.
  6. Under Perform this task, specify a name for the task and how frequently you want this task to run, and then click Next.
  7. Under Select the time and day you want this task to start, specify a start time and date for the task, and then click Next.
  8. Type the user name and password to run this task under, and then click Next.
  9. Click to select the Open advanced properties for this task when I click Finish check box, and then click Finish.
  10. Click the Task tab. In the Run box, specify any additional parameters that you want to use with Shutdown.exe. Click OK.

Important: In the 10th step, you need to add the parameters for the Shutdown.exe command.

To immediately shutdown the system (0 second timeout), the command-line would be:
shutdown.exe -s -t 00

To reboot the system immediately, this command:
shutdown.exe -r -t 00

For additional help, type Shutdown /? at the Command Prompt. Scheduling the Shutdown.exe without any parameters will not help. It will just execute with a exit code 0 (success)

This site is protected by Comment SPAM Wiper.