In The Mix

As a SharePoint architect I have the business behind me and the Developers and IT Pro on my shoulders.

Useful tools: Maintenance Express February 23, 2009

Filed under: Backup,SQL — fmuntean @ 9:35 am

Do you find yourself creating maintenance plans for SQL server every day or so?

Do you use SQL Server Express edition?

Then you want to take a look into this simple and useful tool: MaintenanceExpress on Codeplex.

It does provide a quick and simple solution to re-index, backup, etc.

It keeps the backups and reports for a specified amount of time.

And the best thing is that is all command line based so it can be scheduled.

The only piece missing is the email alert in case something goes wrong or of the reports generated.

Advertisements
 

Online Backup for free May 28, 2008

Filed under: Backup,Online storage — fmuntean @ 1:55 pm

I am writing this blog as I still find people who do not backup their documents and important files from their computer.

I personally have had few disasters in the past and have helped others to recover the files from floppies or hard drives. None of them were 100% successful and the process was quite painful.

I have used online backup for my important files for over a year now on a daily basis and I think that this is the most reliable way for a home user to keep their files safe. Even with this system in place, I still back-up my files few times a year on DVDs or HDD and keep them as a second line of defense.

Right now it is easy to get 2Gb of space online for backup for free.

Following is my review of few online backup solutions:

  MOZY iDrive Carbonite xDrive SpiderOak Diino
Set&Forget

X

X

X

 

 

 

Encryption

X

X

X

 

X

 

Backup History

X

X

?

 

X

 

Free Space

2Gb

12Gb

0Gb

5Gb

2Gb

2Gb

Easy Restore

X

X

?

 

 

 

Open Files Backup

X

X

X

 

 

 

And the winners are:

MOZY:

  • It is a “set and forget” way to backup your files.
  • Keeps full history of backups.
  • All files are encrypted locally and then transferred.
  • Open Files support (backup of the outlook files).
  • Get 2Gb for free.
  • A Referral mechanism allows for 250Mb per referral. Many people don’t know but I found out that currently MOZY gives 250Mb to both the referee and the referrer making it very attractive. If you plan to test it or use it you can use my referral code https://mozy.com/?code=MEF5GC thus giving each of us 250Mb for free. Don’t worry, by using this code, I would not have access to you files.
  • For a $5 per computer per month you can get unlimited backup.
  • There are multiple options for restoring from mounting the backup as a virtual disk to receiving one or more DVDs by mail.
  • You can’t backup network drives.
  • The free version can’t be installed on a Windows 2003 server, use the Pro version for this.

iDrive:

  • Another “set and forget” online backup.
  • All files are encrypted locally and then transferred.
  • Only keeps the last 30 versions of a file. The history counts to the quota.
  • Performs reliable backups of open/locked files like Outlook files.
  • Supports mapped drives and works on a windows 2003 server machine.
  • E-Mail notification.
  • Get 2Gb for free and another 10Gb free by refering 5 friends.
  • For a $5 per month you get 150Gb of storage.

If you know of any other options let me know so I can review them.