Today I got to see our PREVENT Small Business Backup Service in action. I was quite impressed! A service ticket was opened by one of our clients looking for assistance with accessing a database from a certain point in time. The client was concerned that one of their production SQL databases was not accurate so they wanted to be able to bring up the database from January 2nd and run it parallel to the production database for comparison. In the ‘old’ days this request may have made me a bit squeamish.
“In the old days, I would initially need to hunt down the tape from January 2nd, then I would need to import the tape into the drive on the backup server, and finally sit back and hope that the backup server would be able to find the data I was looking for. If I had made it that far I would then need to figure how to turn that backed up data into a database that would not interfere with the production version running on the same server.
Not only did PREVENT make this whole process a lot easier, but it also significantly reduced the amount of time needed for the restore. I started the restore by connecting to the client’s PREVENT box and launching the Backup Management Console. From there I was able to ‘Explore the backup’ by browsing to the location of the PREVENT backup files, sorting by date and choosing the incremental image of the server’s drive where the database was stored. I finished the explore backup wizard and two minutes later PREVENT presented me with an exact duplicate of the disk drive on the server as of January 2nd.
I quickly browsed into the SQL database folder and sure enough, there were the .mdf and .ldf SQL files that made up the database. I copied both files to the client’s server and used SQL Enterprise Manager to attach the database as a different name. The client was then able to go into the database and find the data they were looking for. The entire process took me about twenty minutes to complete.
With PREVENT, I was able to do the entire restore remotely, quickly, and most importantly, of all the data was reliable. What more could I ask for in a small business backup product?