How to Buy Network-Attached Storage (NAS) #nas #device #with #cloud #backup


How to Buy Network-Attached Storage (NAS)

At its most basic, a NAS is used largely for storage and sharing files across a network, but the newest devices can do so much more. We help you understand what to look for when shopping for network-attached storage.

A network-attached storage (NAS) device is primarily a centralized repository for data. It differs from a direct-attached storage (DAS) device in that instead of attaching directly to a computer, it attaches to (you guessed it) a network. Most NASes are used largely for storage and for sharing files across a network, but the newest NASes can do so much more. In fact, they can do so many things that shopping for one can be confusing. Here’s what you need to know when selecting network-attached storage.

A NAS is a server. Most NASes can be used as multimedia servers, as most support the UPnP and DLNA protocols. These protocols are for sharing and streaming multimedia files to devices such as gaming consoles, tablets, and phones on a network. NASes are also multifaceted devices that can often be configured as FTP, Web, e-mail, and print servers.

NAS Capacity
The main purpose of a NAS is to provide centralized, shared storage. Most consumer and small business NASes support SATA drives, but there are a few models out there that support SSD drives. It’s not unusual to see NASes for home users support up to 8TB storage capacity. Business-class NAS boxes typically scale even higher, with some offering petabytes of capacity.

NASes targeted for home users and small to mid-size business often have expandable capacity through USB ports to which users can connect direct-attached storage devices or though iSCSI support. The QNAP TurboNAS TS-470 . for example, not only has USB ports for expansion, but it also has built-in iSCSI support for creating virtual drives for even more storage.

Network Connectivity
Most current NAS devices have wired Gigabit Ethernet connectivity. Many business-class offerings have two or more Gigabit ports for Port Trunking, which provides connection redundancy if one port fails. Multiple Ethernet ports can also be link aggregated, combining the link speeds of the ports and thereby increasing network throughput.

NAS devices that are wirelessly accessible are still somewhat rare. The best we’ve looked at so far is Synology’s DS213air . For now, when you are working with large files wirelessly, you’ll likely experience more latency issues than with NASes connected over the wire. Still, more vendors are beginning to offer dongles for connecting wirelessly.

Measuring NAS Performance
Like PCs, NAS units perform better with improved processors and increased memory. Similarly, the better the processor and the more installed memory, the higher the price. One of the fastest performing NASes we’ve tested is ixSystems’ FreeNAS Mini . This device owes its superior performance to its Intel Core i3 processor and 8GB of RAM.

If you know your NAS will be handling a lot of I/O operations (such as users saving and retrieving high volumes of data on a regular basis) it pays to go with a NAS that has a nimble processor and to max out the memory. Most SMB NASes ship with Atom or Intel processors, while more inexpensive devices for home often use Marvell chips.

Backup and Recovery
The data you store is only as good as your last good backup. Higher-end NAS products often have sophisticated management options to configure redundancy (RAID ), as well as some sort of built-in monitoring system that can alert you of impending drive failure and other problems. If your data is mission critical, these are the kinds of features you’ll want.

Another important consideration in NAS disaster recovery is hot-swappable drives. Many newer HDD-based drives will allow you to “hot-swap” a dying disk drive with a new drive, without having to power the NAS down. Many NAS devices with this capability are aimed at businesses. The DroboPro FS is an example of a hot-swappable NAS.

Some NAS vendors are starting to use the cloud as a backup platform for a local, physical NAS. In this scenario, the data on the NAS is mirrored to a server in the cloud. Many NAS vendors partner with hosted providers such as ElephantDrive or Amazon S3. This type of solution is often known as a hybrid backup solution, and it gives you the best of both worlds, as data is stored in two separate locations. Having data reside in the cloud also provides a way to perform a restore in the event of disk failure in the local hardware.

NAS devices often can also back up their own settings and configurations. This is especially important in a business setting, where specific configurations may be required. If the NAS gets hosed, it can be pain to have to recreate all those settings again.

Remote Access and Personal Clouds
NAS devices aren’t just for local access either. Many NASes devices ship with remote access capabilities for managing the device and access the data on it. Cloud services are also useful for sharing content with friends and family, no matter where they are located. Western Digital’s My Cloud personal cloud service is one example.

NAS Security
Security is always a concern, whether it’s for home hardware or business networks. Many of the NAS devices we’ve reviewed support file encryption. Many also offer a variety of security controls to protect the NAS from intruders with firewall-like access protection. For example, business NAS devices often have physical security, such as locked enclosures or Kensington Security Locks (or K-Slots), which tether the NAS to a wall or desk. The QNAP TS-259 is one example of a NAS that has K-Slots on its chassis.

Finally, all NASes have user accounts and authentication methods requiring a username and password to access the device.

Which NAS Is Right for You?
There are many varieties of use cases for NAS products. Luckily, there’s a wide range of devices available and many of them are configurable as well, which lets you further tailor a solution for your specific needs. Whether it’s for home or a business, security, capacity, backup, and file compatibility should be key factors in determining which NAS you choose. The other features are mainly extras, which will be of greater or lesser importance depending on your particular needs.

Check out the 10 Best NAS Devices for the top-rated models we’ve tested.

Backup & Recovery Software: Virtual Server, Data Protection Analytics #backup #and #recovery,


Data Protector and Backup Navigator

Data Protector Trial

Data Protector

Adaptive Data Protection from the Core to the Edge

HPE Data Protector, our core data protection engine, provides high performing backup and recovery across various data repositories, applications and remote sites in physical and virtual environments. It standardizes and consolidates backup and recovery processes so that businesses can improve reliability, gain business resiliency, and reduce cost and complexity of backup operations. Data Protector is the foundation of the HPE Adaptive Backup and Recovery (ABR) suite which includes Storage Optimizer for analyzing, classifying and managing data based on its value, and Backup Navigator for optimizing the backup environment by using operational analytics and insight. Together, this suite enables our customers to gain a 360 degree view of their backup environments to constantly tune and adapt to deliver optimal results. Read more .

Why Data Protector Works the Best with HPE Storage

More organizations are moving away from fragmented point-based solutions to HPE’s unified data protection solution. Data Protector, through integrations with storage systems such as StoreOnce and 3PAR arrays, can provide you with advanced capabilities that accelerate the backup process in a cost-efficient, scalable way to provide the best reliability, lowest management complexity and highest level of innovation.

Best Practices for Reinventing Your Data Protector Strategy

Are you prepared to tackle the challenges of the new digital economy? Many organizations have underinvested in backup, running legacy solutions that are unable to keep pace with business demands. Watch this webinar replay with IDC and HPE to get a step-by-step strategy for rethinking your current data protection process.

Alternatives to Bankruptcy #backup #exec #alternatives


Alternatives to Bankruptcy

If you are struggling with debt, bankruptcy might be a good option. But before you file for Chapter 7 or Chapter 13 bankruptcy, explore alternatives to bankruptcy. In some situations, a non-bankruptcy course of action may be your best remedy. Read on to learn about the main alternatives to bankruptcy when dealing with debt issues.

Stop Harassment from Creditors

If your main concern is that creditors are harassing you, bankruptcy is not necessarily the best way to stop the abuse. You can get creditors off your back by taking advantage of federal and state debt collection laws that protect you from abusive and harassing debt collector conduct. For more information, see Nolo’s article What to Do If a Bill Collector Crosses the Line .

Negotiate With Your Creditors

If you have some income, or you have assets you’re willing to sell, you may be a lot better off negotiating with your creditors than filing for bankruptcy. Negotiation may buy you some time to get back on your feet, or your creditors may agree to settle your debts for less than you owe. (To learn more see, Debt Settlement Negotiating With Creditors .)

Get Help From a Credit Counseling Agency

Many people aren’t comfortable negotiating with their creditors or with collection agencies. Perhaps you aren’t confident with your negotiation skills, or the creditors and collectors are so hard-nosed that the process is too unpleasant to stomach.

If you don’t want to negotiate on your own, you can seek help from a nonprofit credit or debt counseling agency. These agencies can work with you to help you repay your debts and improve your financial picture. (To find out about agencies in your area, go to the website of the United States Trustee at and click “Credit Counseling and Debtor Education”; this will lead you to a state-by-state list of agencies that the Trustee has approved to provide the credit counseling that debtors are now required to complete before filing for bankruptcy.)

Debt Counseling vs. Chapter 13 Repayment Plans

Participating in a credit or debt counseling agency’s debt management program is a little bit like filing for Chapter 13 bankruptcy. The agency will help you come up with a plan to pay back your creditors over time, somewhat like a Chapter 13 plan. But working with a credit or debt counseling agency has one advantage: No bankruptcy will appear on your credit record.

However, a debt management program also has some disadvantages when compared to Chapter 13 bankruptcy. First, if you miss a payment, Chapter 13 protects you from creditors who would start collection actions. A debt management program has no such protection: Any one creditor can pull the plug on your plan. Also, a debt management program usually requires you to repay your debts in full. In Chapter 13 bankruptcy, you often pay only a small fraction of your unsecured debts. Finally, debt management and debt settlement scams abound. Many companies don’t care about helping you, they just want to collect fees for their services. So tread carefully before you sign up for a plan. (To learn more, see the articles in Options to Avoid When Negotiating or Settling Deb ts.)

Consumer advocates have also raised concerns about credit counseling agencies, because these agencies receive most of their funding from creditors. As a result, critics say, these agencies could face a conflict between the interests of their funders and the interests of their clients.

Do Nothing

Surprisingly, the best approach for some people deeply in debt is to take no action at all. If you’re living simply, with little income and property, and look forward to a similar life in the future, you may be what’s known as “judgment proof.” This means that anyone who sues you and obtains a court judgment won’t be able to collect from you simply because you don’t have anything they can legally take. (As a famous song of the 1970s said, “freedom’s just another word for nothing left to lose.”)

Except in unusual situations (for example, if you refuse to pay taxes as a protest against government policies or you willfully fail to pay child support), you can’t be thrown in jail for not paying your debts. Nor can a creditor take away such essentials as basic clothing, ordinary household furnishings, personal effects, food, or Social Security, unemployment, or public assistance benefits.

Next Step

For a thorough discussion of non-bankruptcy options, check out Solve Your Money Troubles: Debt, Credit Bankruptcy . by Robin Leonard and Margaret Reiter (Nolo).

Get debt relief now.

Web PC Suite #file #transfer, #transfer #files, #wireless #transfer, #wireless #file #transfer,


Web PC SuiteEasy and fast file transfer for Android and PC

Wireless Transfer

Transfer pictures, music, videos, files ect quickly via Wi-Fi or mobile network between Android devices and PC.

Transfer Methods

Support mainstream platforms: Windows, Mac, Unix, Linux etc. No software needs to be installed on PC. Connect your devices by scanning a QR code or logging in by account on a webpage.

Fully-featured Management

File Management: Categorize your files on smart phones: photos, music, videos, documents, Apps etc. Support file uploading and downloading of all formats.
Contact Management: Manage all your contacts on the phone via a webpage like adding and deleting contacts.
SMS Management: Send short messages via a webpage and make batch operations.

Secure transmission

Use HTTPS for transmission to prevent data being modified or corrupted during transfer.

Easy file transfer between Android and PC

Easy photos, documents and links transfer between PC and Android devices without data wire. Perfectly cover PC and Mac platforms.

  • Cross-Platform Service

    Free connection between PC, tablet and phone. Barrier-free transfer between Android and all OS, such as Mac OS, IOS (iPhone), Linux, Symbian (Nokia Phone), Windows Phone, Blackberry and etc.

  • Media Management on Your Phone

    Manage pictures, ringtone, music, video etc. Copy, rename, delete and move files with ease.

  • Contacts Manager

    Manage phone contacts via a web browser: view, delete, modify and send SMS to phone contacts.

    Account login

  • Professional PC and File Server Backup Software #backup #redundancy


    Monitor the status of your backup jobs from the dashboard

    Instantly restore single emails directly from MS Exchange Server VM backups

    Replicate VM backups to an offsite location

    • Save Space – Only back up sections of files that changed using ReverseDelta™ Technology – Using ReverseDelta™ incremental technology, Backup FS only backs up the actual changes you make to a file – without needing to back up the whole file again every time you make a change. Continuous Data Protection (CDP) for Best Protection – Highly tuned file-change-detection technology makes sure that you are protected at all time.
    • Double-Protection with Backup Drive Redundancy – Automatically keep a double-backup to protect against theft, fire or loss of your backup drive.
    • Back up to NAS, Network Drive & USB – Choose the locations where you want to back up to; offices can choose to backup to their server or NAS drive.
    • Automatic Backup on Connect with Plug & Protect™ – for Laptop Users – Automatically initiates a backup once the backup drive is connected to the computer.
    • Restore different versions of your files with inbuilt BackInTime Technology – Restore from multiple points in time rather than ‘the most recent backup’.
    • Email Notifications on Backup Success or Failure – Receive email reports when a backup takes place. Providing peace of mind knowing that all your data is backed up.
    • Flexible Scheduling fits your needs – With Backup Scheduling you can choose to backup multiple times a day or to back up automatically as soon as a file changes. You can also choose to back up multiple times a day at a pre-set time, say for example at lunch break and during the night.
    • Restore Files through Email – With Altaro Backup FS you have the option to send a copy of the restored files to employees via email automatically – wherever they are in the world.
    • Unattended Backups – Runs as a Windows service -ideal for unattended servers. Backs up even when users are not logged in.
    • Supports Windows 2012, 2008 (incl. R2), 2003 & Microsoft Small Business Server – Fully supports Windows server operating systems including Microsoft SBS. Ideal for Small & Mid-Sized Businesses.

    Altaro Backup FS works with:

    11 Top Free Backup Programs to Keep Your Windows Files Safe #best


    11 Top Free Backup Programs to Keep Your Windows Files Safe

    Backing up your files isn’t hard, but it’s amazing how many of us just don’t do it.

    And you can no longer hide behind needing expensive backup software, either. Aside from the free Windows Backup feature that actually works pretty well, there are some great free backup and disk cloning tools around.

    Here are 11 of the top free Windows backup apps around.

    1. AOMEI Backupper Standard

    If you like your backup programs to be simple than AOMEI Backupper ‘s straightforward interface will appeal immediately. Choose the drive or partition to back up, the destination drive, and a click later Backupper will be creating an image for you.

    The program has plenty of power, though, if you need it. There are options to encrypt or compress your backups. You can create incremental or differential backups for extra speed. You’re able to restore individual files and folders, or the entire image, and there are even disk and partition cloning tools.

    You can also schedule backups by day, week and month.

    2. EaseUS Todo Backup Free

    Just like most free (for personal use) editions of commercial products, EaseUS Todo Backup Free has a few limitations – but the package still has more than enough features for most people.

    The program can run both image and file-based backups, for instance, manually or on a schedule. You’re able to run full or incremental backups.

    An option to limit write speed reduces the impact backups have on your system performance. It’s possible to individual files or folders, or an entire image via the program’s recovery disc. And there are tools to clone and wipe drives, too.

    On the negative side, you don’t get encryption, there’s no differential backup, and you only get a Linux-based disc (not Windows PE). But EaseUS Todo Backup Free still looks like a great program to us.

    3. Redo Backup and Recovery

    Redo Backup and Recovery is an imaging backup tool with a difference. Instead of installing a program, you download a large (249MB) ISO file, and burn it to CD or USB key drive. Then just boot from it to launch a simple tool which can back up your drives, and restore them later (even if Windows won’t start).

    There’s also an undelete tool, and even a web browser if you need to look for help on your PC problems.

    The program isn’t exactly convenient, then. You can’t schedule backups, they all have to be run manually, and there are very few options.

    But it’s also easy to use and free for everyone, so if you only want to run backups occasionally – or want a system you can use on any PC, without installing software – then it might be worth a look.

    4. Cobian Backup

    Cobian Backup is an excellent file backup tool with lots of features. You get full, differential and incremental backups, for instance; zip or 7zip compression; AES 256-bit encryption; include and exclude filters; a strong scheduler, backup to or from FTP servers, and the list goes on. Every aspect of the program is extremely configurable, too (there are more than 100 settings you can tweak).

    PC or backup novices are likely to find this a little overwhelming. If you’re more experienced, though, you’ll love the amount of control Cobian Backup gives you over every aspect of the backup process.

    5. Macrium Reflect Free

    One of the most popular free (for home use) disk imaging programs around, Macrium Reflect Free delivers a solid, if basic feature set via an easy-to-use interface.

    The program doesn’t have incremental or differential backups. And you don’t get encryption or password protection. This does make creating a backup job very easy, though (choose the source drive, the destination, maybe set the compression level and you’re done).

    There’s a capable scheduler; you can mount images in Windows Explorer, or restore them entirely with both Linux and Windows PE-based recovery discs. And overall Macrium Reflect Free is a great choice for anyone who wants a simple but reliable image backup tool.

    6. DriveImage XML

    Free for personal use, DriveImage XML is a lightweight alternative to the more bulky imaging competition. Backup is as easy as choosing a source drive, a destination, and (optionally) setting your compression level.

    Restoration is just as simple, and the only significant extra is an option to copy directly from one drive to another.

    There are some complications elsewhere. Click “Task Scheduler”, for instance, and you’ll get instructions on how to manually set up Windows Task Scheduler to run your backups. But if you need just a basic drive imaging tool then give DriveImage XML a try.

    7. FBackup

    FBackup is a capable file backup tool, free for both personal and commercial use. The interface is simple and straightforward, and there are a number of features you don’t always see elsewhere.

    Plug-ins allow you to back up individual programs with a click; there’s support for include and exclude filters; and you can run “mirror” backups, which just copy everything without zipping it up (which makes restoring files very easy).

    Compression isn’t so good, though (it’s the weak Zip2), and the scheduler is also more basic than you’ll see elsewhere. But if your needs are simple (or you’re tired of “free for personal use” tools) then FBackup should appeal.

    8. Backup Maker

    At first the free-for-personal-use BackupMaker seems like any other file backup tool, with incremental or full backups available, scheduling, compression, encryption, include and exclude filters, and so on.

    But interesting extras include support for online backups to FTP servers, and running backups automatically when a USB device is connected.

    The program stores data in Zip files, too, making them very convenient to access. And Backup Maker comes in a tiny 6.5MB download, far more manageable than some of the bulky competition.

    If you’re a home user looking for capable file backup then Backup Maker could be ideal.

    9. Clonezilla

    Just like Redo Backup and Recovery, Clonezilla isn’t a program you install: it’s a bootable environment which you can launch from a CD or USB flash drive.

    And it’s seriously powerful, too: you’re able to create an image of a drive; restore an image (to one drive, or many at the same time); or clone a drive (copy one drive to another), with plenty of low-level control over how this works.

    While Redo Backup and Recovery focuses on ease of use, though, Clonezilla is more about providing advanced options, like “run unattended Clonezilla via PXE booting”. It’s not complicated – it’s probably the best free disk cloning software around – but the program is aimed at experienced users, and backup beginners should look elsewhere.

    10. Paragon Backup Recovery 2013 Free

    Another free (for personal use) version of a commercial drive imaging product, Paragon Backup Recovery 2013 Free is a good tool with some restrictions.

    There’s strong support for the basics: you can create image backups (full or differential), compress and encrypt them, use exclude filters to help define what’s included, run backups on a schedule, then restore specific files and folders or the entire image.

    Extras include the “capsule”, a separate partition to help keep your backups safe. And a good set of basic partition tools is included, too.

    Problems? You don’t get incremental backup; you can’t clone disks or partitions, and the interface occasionally feels a little complex. Still, Paragon Backup Recovery 2013 Free is a quality tool, and well worth your attention.

    11. Duplicati

    If you need online file backups then Duplicati is one of the most versatile tools around, with support for saving files to SkyDrive, Google Docs, FTP servers, Amazon S3, Rackspace Cloudfiles and WEBDAV-based storage.

    The program can also save to local and network drives, though, and includes plenty of useful options (AES-256 encryption, password protection, a capable scheduler, full and incremental backups, regular expression support for the include/ exclude filters, even upload and download speed limits to reduce any impact on your system).

    So whether you’re saving files to the web, or locally, there’s something for you here.

    Rafael Salas: SSIS: File System Task Move and rename files in one


    SSIS: File System Task Move and rename files in one step

    UPDATE: I have included a link to download the sample package at the end of the post!

    In some ETL scenarios, when processing files, it is necessary to rename the already processed files and move them to a different location. In SSIS you can accomplish that in a single step using the File System Task. The example I have prepared assumes the package will process a set of files using a ForEach Loop container; then for each file, using the ‘Rename’ operation in File System Task will do both; rename and move the file.

    Here are some screen shots and notes about the package:

    First of all, the big picture. The control flow has a ForEach Loop Container with a File System Task inside. Notice that the DataFlow task is empty and it is intended to show where the real ETL work should go; but this can be different or not required at all.

    Then details about the ForEach Loop container. Basically ,this container is configured to process all *.txt files in C:\Temp\Source folder, where all the files ‘to be processed’ are expected to be.

    Now the trick, few variables, some of them using expressions:

    The expressions are:

    Notice that SourcePath and ArchivePath variables hold only the origin and destination paths of the files.
    Note: Make sure you set EvaluateAsExpression property of the variable as TRUE.

    Lastly, the File System Task should be configured like this:

    I am pretty sure there are different ways of accomplishing this simple task; but I like this one because it does not require writing custom code and relies on expressions.

    You can download the sample package from here:

    Great example and thank you. Regarding the entry of the expression formulas, it’s actually F4 to open the variable properties window. I must have initiated debugging on my package a half-dozen times with the F5 key before I opened up the menu items and found F4. Also, when using the properties window of the variable, I couldn’t get the expression builder to come up. I ended up editing the expression in a text editor and then pasted the result back to the expression value field. Any thoughts on this?

    I want to thank you for putting up with us lesser skilled SSIS monkeys.

    It has not been necessary to post previously, as most thinks can be found from previous examples you’ve provided.

    However, the last post speaking about providing a path and filename for the rename method in the package bothers me some. We have multiple enviroments, and the package being developed in DEV may not use the same paths as PreProd or Staging. Currently, I’m receiving validation errors when I move the package from one Environment to the next. It’s not really a big deal to open the package in BIDS, and edit it, but, in theory, all values should be picked up from the Variables, and only the configuration XML need be changed while moving to other Environments.

    Unfortunately, I’m bumping my head trying to resolve this particular issue. We do not want, as DBA’s, to continue doing the deployments ourselves. we supply steps for the Tech teams to deploy when possible. Opening up a programming gui and modifying the program actually violates compliance protocols.

    I have a script task that sets all my current connections dynamically so passwords between environments work ok, but, the hard coded file paths in some of the controls fail validation, even though the get overwritten after the fact. I’m sure I’m just missing something.

    This is really very good.
    I had a bit confusion on how we can set the expression to a variable, but later on when i went through the conversation i found out the solution.

    In renaming the file if you want to rename the file with file name appended with date month year below is the code:

    With respect to validation errors, you can set the DelayValidation property on your tasks to True. This will delay validation until the package is executed. You can then have a script step to modify the variables based on a config file.

    This also speeds up package loading in the Designer.

    Thanks for posting this. One issue. The File System task uses the variable value instead of the expression and therefore is only allowed to go through the loop once and can’t rename or remove anything past that package.

    Any ideas on why the File System task wants to take the value over the expression. (Works fine for my dataflow if I disable the File System Task).

    Hi – I want to move all the files in one folder to an archive folder. But with this example it looks for the same file. After it moves the first file it comes back and looks for the same file instead of the next file to be moved. What am I doing wrong?

    I ve downloaded your sample file but it will not load. I get the following error: Error loading Move and Rename File 1 step.dtsx: Failed to load XML due to error 0xC00CE584 DTD is prohibited. Line 1, Column 11 . This happens when loading a package and the file cannot be opened or loaded correctly into XML document. This can be the result of either providing an incorrect file name to the LoadPackage method or the XML file specified having an incorrect format.

    I hope you or someone else might be able to me with this.

    I ve basically set up a package, like your example, but I get an unexplainable error.

    For a file that already existed in my chosen For Each Loop directory, the process works a treat, creating a renamed copy of a source file.
    If however I created a new file in that directory (simply a blank text document) it wont process the file.

    I get the error: [File System Task] Error: An error occurred with the following error message: The process cannot access the file C:\. \Documents\commtrac_jde\Myfile.txt because it is being used by another process. .

    The file isn t open or being accessed by anything else. I even restarted my machine and then run the package, but the same error occurs.

    I would really really appreciate your help

    Rafael ON MY sis package I need to rename each file and add date here only you add date you are not changing the file name how can I do it INSIDE foreach loop
    for instance my sources files are

    07) Jan 2010 data.txt

    and I need change to

    how do I create a variable at collection level that grabs the first part of the names and really rename my files?

    I am having a similar issue as described on Sonia s post,the timestamp and extension are added twice.
    At run time I get Could not find file \\Myfile_backup_201003242200.bak201003242200.bak though the expression evaluates OK.

    Any help appreciated.

    Great Example. My souce file is SPY_IMPORT.txt. This example helped me to move and rename the file. I have changed a bit and final file I am gettiing with following format SPY_IMPORT-2011_7_20.txt
    Specially the SAMPLE PACKAGE is very helpfull.
    However the Month is coming in single digit.
    How can we cahange that to two digits. I mean how to get the file as SPY_IMPORT-2011_07_20.txt?

    Thanks Rafael, I have been using this mechanism for sometime, but I notice it preserves the last modified date on the file. Do you know how I can make it change the last modified date to the date time the file was moved/renamed?

    Hi Rafael, your article is great. I learn a lot from this. One question, when clicking on Move and Rename File Step (Connection Managers) and select properties, how do I know it s related to this particular SSIS package and not another? Thanks. David.

    The connection managers as they appear in the bottom part of the editor are tie to package you have open in the active tab.

    Hi Rafael,
    I am getting below error. Please assist
    [File System Task] Error: An error occurred with the following error message: Could not find file C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\pankajtxt.txtpankajtxt.txt . .

    Progress: Operation Complete – 100 percent complete
    Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
    Task File System Task failed
    Finished, 3:09:52 PM, Elapsed time: 00:00:00.031
    Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
    Finished, 3:09:52 PM, Elapsed time: 00:00:00.063

    How can I restore a database backup file ( #sql #server #database


    A database that was originally from SQL Server 2008, was restored into SQL Server 2012. A backup from SQL Server 2012 was made and I am trying to restore it on my local SQL Server 2008 Express. However I get an error ‘Specified cast is not valid’ (SQLManagerUI).

    I have generated an SQL Script from 2012 and set it so that it will generate with compatibility to SQL Server 2008. However it is a large sql file, around 700mb.

    I recall before that I had tried to run a script of that size before on my local SQLExpress and also got an error.

    Is there a way I can get a “large” database from SQL Server 2012 into SQL Server 2008 Express?

    asked May 25 ’12 at 10:56

    Couple things to add that might be helpful to folks

    When scripting large databases using scripting wizard in SSMS it’s really important to check the execution order and be willing to re arrange it manually. Older versions of SSMS had this problem because they (probably) relied on sp_depends that has a bug .

    What I’ve found really useful in such cases are tools like ApexSQL Diff that you can use to read database backups and generate scripts that are in correct execution order.

    One thing that none of the methods will catch is the thing Aaron mentioned about using functions specific to higher version.

    answered Sep 10 ’13 at 15:18

    A better option than using the SSMS scripting wizard is to use a similar tool available on Codeplex called SQL Database Migration Wizard – You want the latest version v4.x to work with SQL Server 2012.

    The tool is originally intended to be used for migrating databases between SQL Server and Azure. However the tool works just as well as between SQL Server and SQL Server. The trick is to set SQL Server rather than Azure as the target in the advanced options.

    The reason this is a better option than the SSMS scripting wizard is that it uses BCP for the data transfer rather than TSQL and so is much more efficient.

    answered Jan 26 ’14 at 18:51

    2017 Stack Exchange, Inc

    How to Backup Your Emails #email #backup #outlook


    How to Backup Your Emails


    It’s always recommended to have a backup of your data, let it be your website files or email messages. In this tutorial you will learn how to backup/export your email messages using three popular desktop email clients.

    Before starting, it’s worth to get the basic understanding of incoming mail protocols and their differences. In short, there are two incoming mail protocols: IMAP and POP3. The main difference between these two is that IMAP allows synchronizing email among multiple devices. Unfortunately, synchronization is not possible with the POP3 protocol.

    Another big downside of POP3 is its inability to export sent/outgoing email messages to the desktop email client. Thus, if you have IMAP enabled for your account, always use this protocol. For more detailed explanation about differences between IMAP and POP3 see this tutorial .

    Table of Contents

    What you’ll need

    Before you begin this guide, you’ll need the following:

    • Access to your hosting control panel.
    • Desktop Email client.

    Step 1 Acquiring Email Server Details

    First of all, you need to get details and connect to the email server. At Hostinger, email server details can be acquired by following these steps:

    Step 2 Backing Up Email

    Once you have the email server details, you can proceed with the configuration of your email client and the backup creation of your email(s) messages. Below you can find steps showing how to backup emails on three different email clients.

    Option 1 Backing up Email on Outlook

    Begin with adding your email account to Outlook. In the example below, you can see how it is done in Outlook 2016. For instructions on how to do the same on Outlook 2013 see this tutorial .

    Once you have added the email account to Outlook proceed with creating a backup file of your emails:

    As you can see, creating an email backup on Outlook is easy and takes just a few minutes.

    Option 2 Backing up Email on Thunderbird

    Launch Thunderbird and start a new email account configuration wizard. If it’s the first time you open Thunderbird, configuration wizard will open instantly. Atlernatively, you can click on the Email button to initiate the wizard:

    1. On the first screen choose Skip this and use my existing email since you already have an email account.
    2. Now enter your name, email address, its password and click Continue .
    3. On the next step Mozilla will try to automatically retrieve the email server details. In most cases it will fail. Thus, you will have to input them manually. Simply enter the details from the first step and press the Re-test button. If you do not get any errors, hit Done button.

    You should notice that Thunderbird does not show any of your emails. To download email messages from the server press Get Messages button.

    You have successfully configured Thunderbird client. Now let’s proceed and back up your email messages. It can be tricky on Thunderbird since this email client does not have an inbuilt email export feature. However, there is a workaround:

    1. Create a new folder on your computer and name it Email Backup .
    2. In Thunderbird access the email folder you want to backup.
    3. Use CTRL + A (CMD + A for MacOS) and select all messages within the folder.
    4. Right click on the email messages and choose Save As option.
    5. Choose Email Backup as a destination folder.
    6. That’s it, Thunderbird will export all selected email messages in eml format.

    You have successfully downloaded all incoming email messages and saved them on your computer.

    Option 3 Backing Up Emails on Mac Mail

    MacOS users can backup emails using Mac Mail client. Follow steps below to add your email account to Mac Mail:

    Backing up email on Mac Mail is incredibly easy:

    That’s it, you have successfully backed up your email by using Mac Mail client. mbox format is broadly supported by all major email clients. Thus you should not face any trouble if you decide to migrate to a different email client.


    By finishing this tutorial you have learned how to backup your emails using 3 different desktop email clients. You have also learned the main difference between POP3 and IMAP protocols.

    Backup Plus Portable Drives for Mac: Portable & External Hard Drives, Seagate,


    Backup Plus Portable Drives for Mac

    Sign up to stay informed on the latest products, services and offers from Seagate.

    How to backup files on mac

    Meet the Backup Plus for Mac Family

    It’s never been so easy to choose the perfect storage companion for your Mac ® computer. From the popular Slim drives to the ridiculous capacity and mobility of the Portable drives, you can always rely on the Backup Plus family. All Backup Plus drives are compatible with Time Machine ® and come with cool features, including Seagate Dashboard and Windows/Mac compatibility. So stay on the move and safely take along your documents, photos and videos.

    How to backup files on mac


    A spacious 4 TB of capacity in a single, compact portable drive for your growing digital library Mac-ready, on-the-go storage enhanced by a durable design and exceptional reliability. It is your life. Keep it all together.

    How to backup files on mac

    How to backup files on mac

    How to backup files on mac

    How to backup files on mac

    How to backup files on mac

    How to backup files on mac

    How to backup files on mac How to backup files on mac How to backup files on mac How to backup files on macHow to backup files on mac