Protect Your Data with an External Backup Drive

Computers are a very important part of our society, both in a business environment and personally. Having a home computer has been very common for both fun and work purposes. It is common to have pictures saved on your computer as well as some of your financial information. Losing data due to a virus or computer crash can be devastating. The process of recovering all that information is very time consuming and expensive.

Continue reading “Protect Your Data with an External Backup Drive”

Where does Netflix store the offline downloads?

Netflix announced a few months back that subscribers will be able to download select movies and TV shows for offline playback. The feature had been requested by users for a long time, and it’s reportedly been in the works since June. Now, anyone with a Netflix subscription can download movies and TV shows to watch when they’re not connected to the internet.

How to start downloading movies

You can only download Netflix videos using the iOS or Android app. Netflix requires users to have the iOS 8.0 or later and Android 4.4.2 or later, in addition to having the latest version of the app. Downloading videos will consume about as much data as streaming, so if you plan on saving a bunch of videos, we’d recommend connecting to a reliable WiFi connection to prevent any unexpected mobile data charges.

Where are they stored?


Where c: is your system drive and Username gets replaced with the user you are logged in with.

Once you navigate to the above directory, you will see all downloaded movies and TV shows. Netflix doesn’t use descriptive names for downloaded contents, so you cannot identify them. However, the size of the file might give you some clue. The biggest catch is that these contents cannot be opened with media players like VLC or GOM Player.

Black Mirror said it first: You aren’t anything if you aren’t online!

According to a Netflix spokesperson,

“The downloads can only be viewed within the Netflix mobile app; they aren’t like videos you download from the internet and store to your device.” It’s safe to say this is a digital rights management (DRM) scheme to protect the copyrights of videos being offered.

Please bear in mind that Netflix app will not recognize or play contents if you rename or change the files. So, don’t try to rename downloaded Netflix contents.

The whole reason this entire concept of the offline storage and playback took THIS long to implement is Netflix had to spend years finding out every possible way this kind of functionality could and more than likely would be exploited for people to steal the media content and then re-distribute it aka pirate it. The system they’ve created now that’s rolling out is pretty damned bulletproof from every research report I’ve read about it so far and they spent almost 8 months in a beta program asking people to hack the hell out of it and rip ’em off for that content and so far as I’m aware nobody was ever successful in their attempts and I’m pretty certain some very talented coders/developers and “hackers” went to work on that system with nothing positive for all their efforts.

Sure, it’s entirely possible someone might find a particular exploit that could potentially make it a snap or even a click or two to decrypt and break the DRM on the local content once it’s downloaded – we already know Netflix streams can be captured, so even with all the time and expense put into this new functionality it could eventually get itself cracked pretty fast, or never, that remains to be seen.

How to restore all SQL Server database backups from a folder

Sometimes, as a DBA, you will need to restore in bulk hundreds of databases from a server backup to another server.
To do this easily, we created this script that will back up all databases.

This is the “Restore” script at the other end.



SET nocount ON
— 1 – Variable declaration 
DECLARE @backupPath NVARCHAR(500)
backupfile NVARCHAR(255)

DECLARE @lastFullBackup NVARCHAR(500)

DECLARE @lastDiffBackup NVARCHAR(500)

DECLARE @backupFile NVARCHAR(500)


logicalname          NVARCHAR(128) NOT NULL,
physicalname         NVARCHAR(260) NOT NULL,
type                 CHAR(1) NOT NULL,
filegroupname        NVARCHAR(120) NULL,
size                 NUMERIC(20, 0) NOT NULL,
maxsize              NUMERIC(20, 0) NOT NULL,
fileid               BIGINT NULL,
createlsn            NUMERIC(25, 0) NULL,
droplsn              NUMERIC(25, 0) NULL,
uniqueid             UNIQUEIDENTIFIER NULL,
readonlylsn          NUMERIC(25, 0) NULL,
readwritelsn         NUMERIC(25, 0) NULL,
backupsizeinbytes    BIGINT NULL,
sourceblocksize      INT NULL,
filegroupid          INT NULL,
loggroupguid         UNIQUEIDENTIFIER NULL,
differentialbaselsn  NUMERIC(25, 0) NULL,
differentialbaseguid UNIQUEIDENTIFIER NULL,
isreadonly           BIT NULL,
ispresent            BIT NULL,
tdethumbprint        VARBINARY(32) NULL

— 2 – Initialize variables 

SET @dbName = 

SET @backupPath = ‘D:SQLBackup20150306’

— 3 – get list of files 

SET @cmd = ‘DIR /b ‘ + @backupPath



EXEC master.sys.Xp_cmdshell





SELECT backupfile
FROM   @fileList
OPEN db_cursor

FETCH next FROM db_cursor INTO @dbName




DECLARE @RestoreStatement NVARCHAR(max)

SET @BackupFile = @backupPath + @dbName

SET @RestoreStatement = N’RESTORE FILELISTONLY  FROM DISK=N”’ + @BackupFile + ””


DECLARE @logical_data NVARCHAR(max),

@logical_log  NVARCHAR(max);

SET @logical_data = (SELECT logicalname FROM   @FileListTbl WHERE  type = ‘D’ AND fileid = 1)

SET @logical_log = (SELECT logicalname FROM   @FileListTbl WHERE  type = ‘L’ AND fileid = 2)

SET @dbName = Replace(@DbName, ‘.BAK’, )

SET @sql = N’RESTORE database ‘ + @dbName + ‘ from disk =N”’ + @BackupFile + ”’ with ‘;

SET @sql = @sql + N’ move ”’ + @logical_data + N”’ to ”D:SQL Databases’ + @logical_data + ‘.mdf” ,’ 

SET @sql = @sql + N’ move ”’ + @logical_log + N”’ to ”D:SQL Databases’ + @logical_log + ‘.ldf”  ‘

IF Isnull(@SQL, ) <> 

 + @SQL

FETCH next FROM db_cursor INTO @dbName


CLOSE db_cursor
DEALLOCATE db_cursor
EXEC Sp_executesql @BiGSQL

Digital photo recovery and backup

Bird holding a cheetos
Do not lose your precious photos

Digital photographs are something that are important to all of us. Most of the pictures we take happen once in a lifetime, which is why they are so very important. From your child’s first steps to pictures of your family, photographs are very important. As important as they are, nothing is worse than losing them. This can be very traumatic and frustrating, especially knowing that you’ll never to capture the picture again.

Even though it may appear that the camera malfunctioned, all hope isn’t completely lost. There are ways that you can recover your digital photographs, even though you may not be aware of it. Most digital camera’s for instance, use smart cards that will store the information. To be on the safe side, you should always safe your photographs to your card, and transfer them to your computer the first chance you get – then back them up to a CD or DVD.

Sometimes, when you have your photographs on your computer, you may move them to the recycle bin and not even realize it. You can always correct this, by right mouse clicking the recycle bin then choosing to open it up. If the pictures are there, simply drag them to your desktop or right click them and choose restore. This will put them back in the location they were in before they were moved to the recycle bin.

There are other instances where your photographs aren’t this easy to recover. If the card in your camera has become corrupted or if your camera has experienced hardware problems, then it won’t be so easy to recover your pictures. If this is the case, you should always look towards software or professional repairmen. There is software out there that is designed for most types of digital camera problems, and it can normally recover your pictures in the case of malfunction.

Most services and software can recover almost all files that you have on your camera, from JPEG pictures to video files. Most people transfer their pictures to their computer as soon as they can, which can be recovered using data recovery methods. On the other hand, those who don’t, will need a professional to take a look at the camera. If you don’t waste any time and seek a professional immediately, your pictures can normally be recovered.

Digital cameras are something that most of us own these days, as they take professional quality photos. Anytime that it appears you have lost your pictures, you can turn to software and professional recovery services to get your pictures back. Your digital photographs are very important, which is why you’ll want to take care of them. Mistakes and disasters do happen though – which is why there are recovery services.


Tips For Data Recovery

Anytime your hard drive crashes or you lose your data, you’ll need to turn to data recovery to properly restore your information. Data recovery is something most computer users are familiar with, as a majority of us have had to turn to data recovery at some point in time. Even though hard drives are becoming better and better, they are still mechanical and will always encounter problems.

The first thing to do, before any problems happen, is to always back up your data. If you create backups of your information, you’ll be well prepared in the event of a disaster. This way, even if your hard drive cannot be repaired and the data is lost forever, you’ll have the back ups to continue going as normal. If you didn’t make back ups, you’ll find the situation very traumatic when you discover that your data cannot be recovered.

Most hard drives will last for years before they start to encounter any type of malfunction or hardware problems. You can help prevent data loss by turning off your computer when it isn’t in use, or shutting it down when you hear the hard drive making an odd noise. If the hard drive starts to malfunction, letting it continue to run will only do more damage. If you shut it off immediately and take it to a specialist, you’ll have a much better chance of getting it repaired.

With natural disasters, hackers, viruses, or other problems, you won’t have the time to react. Before you know it, your hard drive will be damaged and your data will be gone. Although this can be very frustrating, data recovery can normally bring your information back. All you need to do is take the hard drive to a local specialist, then let them work their magic and show you the power of data recovery.

There are software programs out there that claim to recover lost data, although you should avoid them at all costs. Most of time, these software programs will do your hard drive more bad than good. Even though software may cost a lot less than professional data recovery services, the professional services will guarantee their work. If you turn to software and it only makes things worse – your more or less out of luck, as the software doesn’t guarantee anything.

Anytime your hard drive fails and you seem to have lost your data, you should turn to professional data recovery services immediately. They may cost you a lot of money, although they do the job right the first time. When it comes to your data, you really don’t want to take any chances – especially if you had important documents and files stored on your hard drive.

A great tool we have been trying out lately is:

Set-it and Forget-it File and Photo Backup
Norton™ Online Backup 25GB

A hard drive crash can happen at any time. Expect the unexpected.

  • Automatically backs up your photos and files
  • Provides government-grade encryption for your sensitive information
  • Transfers files between computers seamlessly
  • Works with Windows™ and Mac® computers
File Recovery Software Download – File & Disk Management Software for Small Business & Home Office




Protection You Can Afford

There are numerous ways you can lose the information on your computer. Your child decides to play Chopin on your keyboard, a power surge, lightening, a virus, or even simple equipment failure. Therefore, backing up the contents of your hard drive is an absolute MUST.  By regularly making backup copies of your files and storing them in a separate location, you can typically get some, if not all, of your information back in the event your computer crashes.

While a regular backup to DVD, BluRay, or external drive will save your files, wouldn’t it be great if you could create an exact copy (a drive image) of your hard disk?  That means backups of all your files, programs, and user settings.  This would definitely save you time when it came to reloading.  Symantec helps out the private sector as well as the business sector with a range of products designed to efficiently backup data securely.



Get data recovery services for next generation data centers from Symantec – protect completely, store efficiently and recover anywhere.
NetBackup with V-Ray technology is the single solution when recovery is needed—whether from tape, disk, snapshot, cloud—in a physical or virtual environment. Only NetBackup with V-Ray unifies backup, deduplication, replication, snapshots, and appliances with support for VMware and Hyper-V in a single product.

Backup Exec

Protects virtual and physical environments, simplifies both backup and disaster recovery, and offers unmatched recovery capabilities.
Backup Exec 2012 is a single integrated product that protects virtual and physical environments, simplifies both backup and disaster recovery, and offers unmatched recovery capabilities. Powered by Symantec V-Ray technology, Backup Exec 2012 instantly restores entire servers, critical Microsoft applications, and VMware or Microsoft Hyper-V virtual environments to dramatically minimize business downtime.

Backup Exec Small Business Edition

Small Business Edition offers data protection, system restore, and disaster recovery through three simple steps in less than ten minutes.
It is packaged with the backup and recovery needs of small business in mind, supporting any Windows Server, or Windows Small Business Server environment, and providing total protection in a single-license for Microsoft Exchange, Active Directory, SQL Server, SharePoint, and Hyper-V applications.

Backup all Databases in MSSQL – SQL Script

If you have a server you would have been presented at one point with the need to backup all databases in one go. Here’s a script that would do just that.



DECLARE @name VARCHAR(50) — database name  

DECLARE @path VARCHAR(256) — path for backup files  
DECLARE @fileName VARCHAR(256) — filename for backup  
DECLARE @fileDate VARCHAR(20) — used for file name

— specify database backup directory
SET @path = ‘D:SQLBackup’
— specify filename format
SELECT @fileDate = CONVERT(VARCHAR(20), Getdate(), 112)

FROM   master.dbo.sysdatabases
WHERE  name NOT IN ( ‘master’, ‘model’, ‘msdb’, ‘tempdb’ )
— exclude these databases
DECLARE @DatabaseFolder NVARCHAR(255)
SET @DatabaseFolder = @path + @fileDate
EXEC master.sys.Xp_create_subdir      @DatabaseFolder;

    OPEN db_cursor
FETCH next FROM db_cursor INTO @name

SET @fileName = @path + @fileDate +  + @name + ‘.BAK’
FETCH next FROM db_cursor INTO @name
CLOSE db_cursor
DEALLOCATE db_cursor