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?

C:\Users\UserName\AppData\Local\Packages\4DF9E0F8.Netflix_mcm4njqhnhss8\LocalState\offlineInfo\downloads

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.

Advertisements

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.


CREATE PROCEDURE Restorealldbs

AS

SET nocount ON
— 1 – Variable declaration 
DECLARE @dbName SYSNAME
DECLARE @backupPath NVARCHAR(500)
DECLARE @cmd NVARCHAR(500)
DECLARE @fileList TABLE
(
backupfile NVARCHAR(255)
)

DECLARE @lastFullBackup NVARCHAR(500)

DECLARE @lastDiffBackup NVARCHAR(500)

DECLARE @backupFile NVARCHAR(500)

DECLARE @FileListTbl TABLE

(
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

INSERT INTO @fileList

(backupfile)

EXEC master.sys.Xp_cmdshell

@cmd

DECLARE @SQL NVARCHAR(1500)

DECLARE @BiGSQL NVARCHAR(max)

SET @BiGSQL=

DECLARE db_cursor CURSOR FOR
SELECT backupfile
FROM   @fileList
OPEN db_cursor

FETCH next FROM db_cursor INTO @dbName

WHILE @@FETCH_STATUS = 0

BEGIN

DECLARE @file NVARCHAR(255)

DECLARE @RestoreStatement NVARCHAR(max)

SET @BackupFile = @backupPath + @dbName

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

DELETE FROM @FileListTbl
INSERT INTO @FileListTbl
EXEC(@RestoreStatement);

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, ) <> 

SET @BiGSQL = @BiGSQL + 
 + @SQL

FETCH next FROM db_cursor INTO @dbName

END

CLOSE db_cursor
DEALLOCATE db_cursor
PRINT @BiGSQL
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

http://uk.norton.com/online-backup/

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

http://www.prodigitaltips.com/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.

 

NetBackup

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.


CREATE PROCEDURE Tblbackup

AS

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)

DECLARE db_cursor CURSOR FOR
SELECT name
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

    WHILE @@FETCH_STATUS = 0
BEGIN
SET @fileName = @path + @fileDate +  + @name + ‘.BAK’
BACKUP DATABASE @name TO DISK = @fileName
FETCH next FROM db_cursor INTO @name
END
CLOSE db_cursor
DEALLOCATE db_cursor

Cooling Your Hard Drive

For several different reasons, storage is a very important part of a computer. These days, computers do far more than they ever have in the past. From businesses to family photo’s, storage is the ideal way to keep documents on your computer. The most popular method of storage is the hard disk drive, which we all count on for keeping our data safe.

Even though the hard drive stores data, it isn’t perfect by any means. Hard drive failure is very common with all computers, with no real way to prevent it. Although there are several different reasons why a hard drive can fail, the most common is overheating. Viruses and crashes are common as well, along with theft and accidental deletion.

When your laptop is on fire... backup your data
When your laptop is on fire… backup your data

With the older style and mechanics of hard drives, the RPM speed was low, meaning that the drives wouldn’t overheat. The hard drives we use now days, have speeds between 7,200 and 10,000 RPM, meaning that they can get quite hot when they start working. Computers of this day and age come with fans to cool everything down, with most hard drives including temperature sensors as well, so you can keep track of just how hot your hard drive becomes.

With hard drives today, overheating is a very common problem. The faster hard drives come with speeds of 10,000 RPM, which can make the temperature soar above 70 degrees F, really heating things up inside the drive. The mechanics on the inside are built to withstand the heat, although if things become too hot, you’ll encounter problems. If a drive becomes too hot and ends up losing the data, it may be next to impossible to retrieve the information – no matter how good your data recovery specialists may be.

One area that suffers from the drive overheating is the platters, which are magnetic media. Platters are what carry the data throughout the hard drive. Platters are constructed from optical glass, aluminum, or ceramic and normally coated with a layer of magnetic material. Once the hard drive begins to heat up, the platters will start to expand, which changes their size. When this happens, the magnetic surface on the platters will get destroyed, which results in a loss of data. If the physical area of the platters are damaged, it will result in unreadable sectors.

Other areas of the hard drive that can be damaged due to overheating are the read and write heads, head actuator, and the controller chip. Hard drives are very sophisticated pieces of hardware, and can’t handle overheating. The read and write heads are a common example, as they can easily render the drive useless if they become damaged. If they get too hot, they don’t make any contact with media, which pretty much stops the flow of transfer from information to the computer.

To prevent your hard drive from overheating, you should always make sure that it is cooled properly and well ventilated. You can always get additional fans and coolers, which will improve both ventilation and the flow of air in your computer. You can buy fans and coolers at very affordable prices, which makes them an ideal investment for keeping your hard drive or hard drives cool.

You can also get software that monitors the temperature of your hard drive as well. Whether it’s software, or additional fans, you should always ensure that your hard drives are kept cool. By keeping them cool, you’ll greatly reduce the amount of crashes. You’ll also increase the stability of your hard drive as well, which will make your entire computer perform much better.