How to Configure GroupWise Message-Level Backups #groupwise #backup

#

How to Configure GroupWise Message-Level Backups

  • Last updated on 2017-06-01 13:44:57

The articles in this section refer to Barracuda Backup Legacy Release firmware or newer. and Novell NetWare Server and GroupWise 8 and 2012.

Barracuda Networks recommends ensuring the latest hotfixes, patches, and updates are installed on your data sources.

Set up your Novell NetWare Server to complete GroupWise message-level backups with a Barracuda Backup Server.

Requirements

  • NetWare Server 6.5 or greater
  • GroupWise Server version 8 or greater

Configure the GroupWise Server

Use the following steps to configure the GroupWise Server:

  1. On a Microsoft Windows workstation where the Novell Client is installed, log in with an account that has access to the GroupWise primary domain database file wpdomain.db :
  2. Create an account to be used by the Barracuda Backup Server to access the email in each mailbox; the service account must be a member of either the Enterprise Administrators or Domain Administrators group.

Generate a GroupWise Trusted Key

A trusted application key allows a third-party program to authenticate to the post office agent (POA) or the Internet Agent and obtain GroupWise information that would otherwise be available only by logging in to GroupWise mailboxes. Starting with GroupWise 8 Support Pack 1, you can create a trusted application and its associated key in ConsoleOne for use with both Linux and Windows trusted applications.

Use the following steps to generate a trusted key:

  1. Open ConsoleOne. From the Tools menu, point to GroupWise System Operations. and click Trusted Applications :
  2. The Configure Trusted Applications dialog box displays. Click Create :
  3. The Edit Trusted Application dialog box displays:
  4. In the Name field, type Barracuda Backup. and enter a description for the trusted application in the Description field.
  5. Leave the TCP/IP Address field blank to allow the trusted application from any server, or, t o restrict the location from which the trusted application can run, click the Edit icon to the right of the field, and in the Edit Network Address dialog box, specify the IP address or DNS hostname of the trusted application server. Click OK to save your settings and close the dialog box.
  6. To require a secure (SSL) connection between the trusted application, POAs, and Internet Agents, select the Requires SSL check box.
  7. Click the Browse icon to the right of the Location for key file field, and browse to and select the directory where you want to create the trusted application key file.
  8. In the Name of Key File field, enter the trusted application key file name.
  9. Click OK to save the trusted application configuration information.

Add the GroupWise Server as a Data Source

  1. Log in to Barracuda Backup web interface, and select the associated Barracuda Backup Server in the left pane.
  2. Go to the Backup Sources page, and click Add a Computer .
  3. In the Computer Information section, enter the Netware Server description and hostname or IP address.
  4. From the Computer Type drop-down menu, select Novell Open Enterprise Server .
  5. In the Open Enterprise Server Computer Information section, enter the login credentials for the server.
  6. Click Save .
  7. On the Add Data Source page, enter a description for the data source, and from the Data Type drop-down menu, select Message-Level Backup (GroupWise) .
  8. In the Add to Schedule section, select an existing schedule from the drop-down menu, or click Add New to create a new schedule.
  9. In the Message-Level Backup (GroupWise) Information section, enter the GroupWise mailbox location in the Base Context field.
  10. In the Trusted Application Key field, paste the Trusted Application Key created in the previous section.
  11. You can optionally enter the e-Directory Server hostname or IP address.
  12. Click the Test GroupWise Connectivity to verify the connection.
  13. Click Save .
  14. Go to the selected schedule on the Backup Schedules page. In the Items to Back Up section, select the mailboxes you want to back up.
  15. Click Save .

Retain Emails

This step is optional. You can optionally set up GroupWise to have all emails backed up by Barracuda Networks. This feature instructs GroupWise to not purge emails until Barracuda Backup has a backup copy of the email. For information on how to set up this feature, please view the GroupWise Administration Guide – Environment Options: Retention section [1] available on the Novell website.





Recovering a database with a missing transaction log #microsoft #sql #server, #sql

#

Recovering a database with a missing transaction log

Question: We had a SAN problem over the weekend and the upshot is that one of our main databases was shut down with open transactions, but we ve lost the log file. The last working backup is two weeks old.

Is there any way to recover the database without having to resort to the old backup?

Answer: Yes, but not without consequences.

Usually when a database has open transactions and the server crashes, crash recovery will run on the affected database and roll back the open transactions. This prevents the partial effects of transactions being present in the database. If the transaction log is not available when SQL Server starts, the database will be in the SUSPECT state.

In this case, the only way to bring the database online (note that I m not saying way to make the database usable ) is to use the emergency mode repair functionality that was added in SQL Server 2005. This basically builds a new transaction log and then runs a DBCC CHECKDB using REPAIR_ALLOW_DATA_LOSS. Read more .

The problem you will have if you decide to go this route is that emergency mode repair cannot roll back any of the active transactions as it has no knowledge of what they were, because the transaction log was destroyed. This means that at best, the resulting database will be transactionally inconsistent i.e. the state of the data in the database is unknown.

For instance, there may have been a transaction that was updating some sales records in a table, and only half of them were updated before the crash and subsequent transaction log loss occurred. You ll find it very difficult to figure out what state the data is in, and how to make the database properly usable again by the application.

Emergency mode repair is supposed to be a real last resort when all other methods of recovering data have failed.

In your case, you ll have to figure out what is the lesser of two evils recovering the database into an inconsistent state, or restoring the two-week old backup. You may end up deciding to do both, and trying to piece together the data, but that will be very time consuming and problematic again, because you don t know what was happening in the database at the time that the crash occurred.

To prevent this situation in future, beef up your backup strategy to use much more frequent backups, and add a high-availability technology that maintains a real-time copy of your database such as database mirroring or SQL Server 2012 Availability Groups.

[Unrelated: this is the last post on this blog, as we re going to focus on our own blogs moving forward. It s been great having this additional outlet to the community and we ve enjoyed writing the weekly posts for the last two years. We hope you ve enjoyed reading and learning from them too!]





PC Hell: How to Set Yahoo As Your Default Email Program #yahoo

#

If you use web-based email like Yahoo or Gmail, you know the biggest drawback occurs when you click on a link on a web page to email someone and you realize the default email program on your computer is not the web based email one. Instead of opening Yahoo Mail, Outlook Express or some other client-side email program opens. Of course, if you have Yahoo Mail Plus, you could setup Outlook Express or any other default email application to use it. But is there a simple way to set your default email application to Yahoo Mail or Gmail.

There are actually two ways to accomplish this, unfortunately only one way works in both Windows XP and Windows Vista. If you follow the steps below you should be able to use the mailto links on a web page to email someone easily.

Using Yahoo Messenger

The first way to set Yahoo as your default email program is to install Yahoo Messenger. Yahoo Messenger can be download at http://messenger.yahoo.com. If its installed correctly it will set Yahoo as your default email application. You will need to install the Browser Services option to make this work properly. Without the browser services installed, you still cannot set Yahoo Mail as your default.

Once Yahoo Messenger is installed, follow these steps to set the default email program.

1) Open Control Panel
2) Double-click on Internet Options
3) Click on the Program tab
4) Select Yahoo Mail from the drop down list (as shown below)

5) Click Ok
6) Close Control Panel

Unfortunately, this procedure DOES NOT work with Windows Vista computers.

YAttach! is a free simple to install program developed by a fellow named Chris Wood. It was created to allow someone to attach files to Yahoo Mail but works great at opening Yahoo Mail with a new message window all filled out when you click a mailto link on a web page. YAttach works in Windows XP and Windows Vista.

Yattach! sets itself as the default email program in Windows and will work in Internet Explorer, Firefox, and other browsers. When you click on a mailto link you’ll see a window pop up similar to the one below, then it will open Yahoo Mail and create a new message with the To: field already filled in.

Sometimes, the program will appear to hang at the screen above instead of opening Yahoo Mail. This issue can be easily resolved by logging into Yahoo Mail and choosing the option to “keep me signed in”.

YAttach! is the easiest to use program to allow web based email programs the ability to send documents directly from your computer or intercept mailto links clicked on web pages.

There is also a program called GAttach! that accomplishes the same thing for Gmail. My only complaint about that version is that it creates a message in the drafts folder instead of opening a new message window. Because of that issue, I prefer the Gmail Notifier. During the installation of the Gmail Notifier be sure to check the box for “use for outgoing email”.

Printer Friendly Version of This Page





How to backup Yahoo! emails #how-to,backup,backup #yahoo,configure #backup,yahoo #mails #backup

#

How to backup Yahoo! emails

In order to back-up the emails stored in your online Yahoo account, you need to download them on your computer to a local folder. In order to do that, you need to define your Yahoo mail account in Zimbra desktop application. As Yahoo does not offer this option for free (if you have an Yahoo Plus account you can use POP3), you need Zimbra that allows you to download all your yahoo emails locally. When the emails are on your computer in a local folder, you can back them up using the Zimbra plugin from Backup4all.

How to configure Yahoo in Zimbra desktop application

Zimbra Desktop is an email client which allows you to synchronize the Yahoo! account including: mails, contacts, and calendar items.

  1. Open Zimbra desktop
  2. Press Add new account.
  3. From the Account type list, select Yahoo!
  4. Type your account details as asked.
  5. Press Validate and Save.

How to configure Backup4all

Once you have your Yahoo emails on your local computer, you can configure Backup4all to automatically back them up. To do so:

  1. Download the Zimbra desktop plugin for Backup4all from this download link
  2. Install the plugin in Backup4all: go to File- Tools- Plugins- Addnew plugin. (in Backup4all 4, go to Tools- Plugins- Add)
  3. Go to File- New Backup
  4. Type a name for your backup in the Backup name field.
  5. Choose a location where you want to save the backup. Press Next.
  6. From the Selection of files and folders list, choose Zimbra desktop. Press Next.
  7. Choose how do you want to backup.
  8. Press Save and choose Save and run.

How to backup Yahoo! emails using Thunderbird

Another solution is to use YPOPS. but it works only on computers running Windows XP. After YPOPS! is installed you will need to configure Thunderbird so that it will include your Yahoo Mail account as a POP3 email account. This way all your emails will be downloaded from Yahoo Mail to your local computer. If you want to keep a copy of your email messages on Yahoo Mail too, make sure the option “Leave a copy of messages on server” is enabled (detailed in the steps below). Steps needed to configure Thunderbird with YPOPS!:

Perform a Send and Receive to get all your emails from your Yahoo account. The first time you try to access the account, Thunderbird will ask for the password.
After that, you need to create a backup job using the Thunderbird plugin from here .

The backup will run and your Thunderbird emails and settings will be backed up to the designated destination.

Backup4all 5.x, 4.x
Zimbra desktop 7.x
YPOPs! 0.9.5.8 or higher
Mozilla Thunderbird 2

Related articles

Comments

About Us

Softland, the company that develops Backup4all, achieved the Microsoft Certified Partner status with an ISV/Software Solutions Competency.

Stay Updated

To join, enter your email address below and click on Subscribe.

Legal Notices Terms of Use Support Policy Sitemap Forum

Copyright Softland 2003-2017. All rights reserved.

NEW: Backup4All 6.6.388





What Is Cloud Backup? A Beginners Guide To Cloud Backup #amazon #s3

#

This beginner’s guide on Cloud Backup briefly explains the benefits as well as pitfalls of Cloud Backup solutions, notable cost effective Cloud Backup service providers etc in a simple way.

What Is Cloud Storage?

Cloud Storage is nothing but storage solution for the Internet. Cloud Storage Service Provider will have a cluster of highly scalable servers with simple web services interface that can be used to store and retrieve any amount of data, at any time, from anywhere on the web. In simple terms, Cloud Storage, from an end user perspective is nothing but an unlimited amount of online disk space that is secure, inexpensive, highly available (mostly) to store/backup/restore data from PCs, Laptops and Servers.

Image Source: Zmanda Backup Solution

Who Should Use Cloud Storage?

As mentioned earlier, Cloud Storage is nothing but Online Storage, so to access Cloud Storage, one needs to have high bandwidth internet connection. This requirement may be a problem for those who want to store time critical storage on the cloud. However, data recovery solutions that use cloud storage is viable as you would request for data restore not so frequently. For example, you are photographer and want to backup all of your photo collection. Then it makes perfect sense to have the photos backed up on the cloud. You would have secondary backup of your photos and incase your laptop crashes, you can always get your data restored almost immediately. Depending on the amount of photographic data that is there on the cloud it would take probably a few minutes or few hours. This is not really time critical. So, a Data Backup/Restore solution on Cloud Storage is Cloud Backup solution. Anyone who needs secured, backup on a remote server without much worries on maintaining the infrastructure will have to go for Cloud Storage Backup Solutions.

Data Encryption and Disaster Recovery On Cloud Backup

In Cloud Backup solution, your data resides on an external server outside your home or office, so the data needs to be protected. All of the Cloud backup solutions offer state of the art Data Encryption facility so that your data is compressed and encrypted so that others are unable to use them. Since the data that is backed up is on a remote location, there is a fair amount of disaster recovery is involved. More over, Cloud Storage servers will have data redundancy implemented internally.

Advantages of Cloud Backup Service

  • Safe and secured way of backing up data on a remote data storage
  • Accessible from anywhere
  • Usually cheap with pay as you go model
  • Inbuilt disaster recovery facility
  • Highly scalable – no cap on storage limit
  • Data backup can be automated
  • No need to worry about hardware infrastructure to maintain

Disadvantages of Cloud Backup Service

  • High Internet bandwidth is needed
  • Your data resides on 3rd party Servers, if they close the shop, then you need to worry about your data (If it ever happens, It can be handled easily though)
  • Most of the Cloud Backup service providers charge based on data backed up. So, if you have more data, then you will be charged more. However, there are more and more service providers who are giving flat rate plans such as Mozy that charges $5/month for unlimited usage.

It is seen by industry experts that for large enterprise with Large amount of data that frequently changes with limited network connectivity, the traditional on premise data backup solution works out better and cheaper.

Cloud Backup Vendors

There are many such vendors. But the most noted ones that are cost effective are;

Most of the Cloud Backup service providers use Amazon’s S3 Cloud Infrastructure. Amazon S3 is mostly used but has couple of alternatives such as Nirvanix. Eucalyptus. Enomaly Cloud etc.

Well, not really
Cloud Backup should support
Blocklevel or Delta backup, some of the above don t so if I m uploading 1 GB file, next time changed 1 Byte, will take it again.
I prefer Cloud Disaster Recovery
And Cloud Disaster Recovery means true global dedupelication technology with all the above, don t have!!
I prefer pure cloud backup, not proprietary storage, like Amazon,we all do remember carbonite lost their data in 2009.
Completely mobility access, I m paying for the cloud, i need for access anytime any where, why should i use a software without mobility access
If for business,it should have a true complete cloud management console
it should be easy to use and no real performance impact

Hope this will help

Forgot to say, I tested many software s and the best 2 I found were Mozy and Timeline Cloud, just for your info, but i went with Timeline Cloud, because they are using Amazon and they have cloud Disaster recovery

[ ] with any computer that Read More RECOMMENDED BOOKS REVIEWS AND OPINIONS What Is Cloud Backup? A Beginners Guide To Cloud Backup This beginner’s guide on Cloud Backup briefly explains the benefits as well as pitfalls of [ ]

Social comments and analytics for this post

This post was mentioned on Twitter by opentube: What Is #Cloud #Backup? A Beginners Guide To Cloud Backup http://bit.ly/bg54Vw

Great article explaining cloud backup services and Online Data Backup Services

This is very helpful. Thank you. I have an additional question. Is there a service that not only back-ups your info, but also allows you to access files and work on them remotely. In others words a service that would allow me to have a home computer and an office computer and access files from both sites.
Thank you.

Not much of a review without the market leaders in it.
Where is SOS Online Backup, for one? Where is SpiderOak?
This review is just an info-mercial for kick backs.





Using Amazon Glacier or S3 as an Online Backup Server #cloud #storage,

#

Using Amazon Glacier or S3 as an Online Backup Server

Cloud storage solutions have become a simple, cost-effective solution for backing up your important data. Check out these feature-rich tools for helping efficiently manage your cloud storage data.

Amazon Glacier is an extremely low-priced cloud storage solution as low as one cent per gigabyte (GB), in fact that is designed for long-term file and data backups with infrequent retrievals or removals. It’s great for manually archiving data or maybe even serving as online backup for your PCs, especially if you also back up to a local drive.

Just keep in mind, there are additional fees If you re looking for a storage solution for frequent utilization, in which case you’ll likely want to consider another Amazon Web Service: the Simple Storage Service (S3). pricing for which starts at three cents per GB.

Amazon, however, may not always be the best storage option. For instance, if you want a quick and easy online PC backup solution, consider another company that s designed for PC backup. When backing up large amounts of data, such as half a terabyte (TB) or more, unlimited backup offerings from other companies like CrashPlan or Backblaze may be cheaper to utilize than even Amazon Glacier.

If you do choose one of the Amazon storage offerings, you can use a client program similar to an FTP client to upload, download, synchronize and back up your data. Here are several different clients to consider that support Amazon and other cloud services:

Fast Glacier. A multipurpose Windows client for Amazon Glacier that is free for personal use, and commercial licensing for it starts at $39.95. Fast Glacier supports manual uploads/downloads, syncing, and automated backup functionality. It features pause/resume for uploads, pre-upload compression and encryption, and download limiting to control data retrieval costs.

CrossFTP. An FTP-style client that supports FTP, Amazon S3, Amazon Glacier and Google storage client for Windows, Mac OS X and Linux. In addition to their free basic edition, they offer a Pro edition for $24.99 and an Enterprise edition for $39.99 that adds support for SFTP, WebDav, pre-upload encryption, syncing, scheduling and other features.

Duplicati. A free and open source backup client for Windows, Mac OS X and Linux that supports many different cloud and remote file services, including Amazon Glacier and S3, Windows Live SkyDrive, Google Drive (Google Docs), Rackspace Cloud Files, WebDAV, SSH and FTP. Duplicati supports incremental updates, encryption and signing using GNU Privacy Guard, and scheduling capabilities.

Simple Amazon Glacier Uploader. A simple Java-based cross-platform client that offers a GUI for the Glacier command-line tools. This likely isn t a client you ll want to use all the time, but it is good to keep on a flash drive for quick and simple access from any computer or OS.

Syncovery. A commercial file synchronization and backup software tool that is priced at $59.90 for the fully functioning edition, which runs on Windows, Mac OS X and Linux. Syncovery supports traditional FTP-like protocols and many cloud-based services, including those from Amazon S3, Microsoft, Rackspace, Google, DropBox and Box.com. It s a feature-rich solution supporting syncing, automated scheduled backups, compression and encryption, and many other functionalities.

CloudBerry. CloudBerry offers a large line of commercial backup product solutions designed for different types of machines or applications, such as desktop PCs ($29.99), servers ($79.99) and bare metal backups ($119.99). CloudBerry sells products for specific servers and applications as well, such as MS SQL servers ($149.99) and MS Exchange servers ($229.99). They even offer solutions for IT or managed service providers (MSPs). Their products support backing up to Amazon, Microsoft, Google, and Openstack cloud storage services and are feature-rich solutions.

Recommended for You





Cloud Computing – Dedikert server – VPS – Managed Hosting – Hosted

#

Public Cloud

Med Public Cloud trenger dere ikke bygge deres egne maskinvareplattformer. Her kan dere i stedet få fullt utbytte av den store skalerbarheten og fleksibiliteten som er støttespilleren i disse tjenestene. Dere leier den ressursen og kapasiteten som tilsvarer behovene deres, og når disse endres, kan dere enkelt og raskt fjerne eller legge til nye ressurser. Les mer om Public Cloud

  • Virtuell Privat Server Med en VPS får dere følelsen av en egen server til en lav kostnad. I løpet av minutter har dere deres egen server med valgfritt operativsystem.
  • Elastic Cloud Server En lettadministrert nettskyserver som enkelt kan oppgraderes/nedgraderes ved behov, og der dere betaler for brukt tid. Automatisk skalerbarhet, enorm kraft.
  • Hosted Exchange En sikker e-postløsning, inkludert delte mapper, kontakter og kalendre, der alle data og filtre lagres i Sverige – Microsoft Exchange 2010.
  • Webhotell Rimelig lagringsplass for hjemmesider på Windows- eller Linux-server med e-postkontoer, installering av gratis applikasjoner, gratis domene og support.
  • Hosted Hyper-V Kraftig virtuell server i nettskyen med dedikerte ressurser i et redundant miljø med failover – Windows Server 2008 R2.
  • Hosted VMware Et virtuelt datasenter der dere raskt bygger, replikerer eller flytter deres skalerbare nettsky som dere vil.
  • Hosted Azure Pack Et letthåndterlig, flyttbart og fleksibelt virtuelt datasenter i Skandinavia som IaaS / PaaS-tjeneste innenfor Microsofts Cloud OS-økosystemet.

Private Cloud

Med Private Cloud leier dere deres egen plattform i vårt svenske datasenter som er helt og fullt dedikert til dere. Dere deler ikke engang kraft med noen. Denne kan dere selv utforme seg eller så kan Ipeers spesialister skreddersy en plattform som er optimalisert etter deres krav, mål og midler. Våre erfarne teknikere kan også stå for driften, slik at dere kan fokusere på kjernevirksomheten deres. Les mer om Private Cloud

  • Dedikert server Komplette og kostnadseffektive dedikerte serverløsninger – Windows eller Linux – med høy kapasitet og tilgjengelighet.
  • Skreddersydd hosting Her tilpasser dere maskinvare, offsite backup og lastbalansering eller gruppering helt etter behov. Våre erfarne spesialister kan stå for driften.
  • Colocation Plasser serverløsningen deres i datasenteret vårt og opplev den høyest mulige tilgjengeligheten og sikkerheten med overvåking av spesialister døgnet rundt.
  • Hosted VMware Hybrid Få multisite-redundans og rask skalerbarhet uten å gå på kompromiss med sikkerheten ved å forlenge deres private nettsky inn i vår nettsky med Disaster Recovery.
  • Hybrid Hosted Azure Pack Stor skalerbarhet og samtidig opprettholdt sikkerhet – utvid deres Hyper-V-sky til skandinaviske datasenter med testet Microsoft Cloud OS teknologi.

Vi finns tilgjengelige 24/7/365





Replication backup #replication #backup

#

Solutions

Universal Backup Device

Instantly replace your tape backup with faster more reliable disk for iSeries or Linux servers.
Learn More »

“Being able to have virtual backups instead of using tape was an integral part of our DR plan. We can now easily and automatically take frequent snapshots of our data. We use UBD with both our production and development AS/400s. We just upgraded from a Power5 to a Power 8 and the transparency of using UBD is seamless. The transition from the operational and CL side was very easy.”
36th District Court, Detroit More »

“UBD saves a lot of time for us. Previously our daily backups took 30-45 minutes to start, now they start in 10. And the best part about using UBD is the ease of doing a restore.”
City of Manhattan, Kansas More »

A backup solution needs to be rock solid dependable and just work. UBD has exceeded that expectation already.
City of Dothan More »

LaserVault Replacador

Move copies of your backup offsite without tape. Deduplication with replication makes it possible. Replacador makes replication affordable. Learn More »


LaserVault Backup

Network based backup for IBM i and iSeries systems. Learn More »

“Getting data to our DR site without having to transport tapes is critical. LaserVault works with our AS/400 and lets us eliminate the DR tapes, so it was a great solution for us to find.”
Roosevelt Paper Company More »

“LaserVault Backup is a very good solution. It gives us an easy way to restore object by object, instead of having to restore full backups in order to get data for one file only.”
Ransome Cat, Pennsylvania More »

LaserVault DMS10 with Workflow

Store, index and retrieve documents and faxes across your network or the Internet using phones, tablets, Windows or Linux. Learn More »

Stopping printing has saved 1,000s of pages of paper, toner and time! We use LaserVault to manage our PDFs, TIFFs, shipping docs, several daily parts reports and several month-end reports.
Carter Machinery Company More »

“We use DMS for a multitude of documents: resolutions, ordinances, AP, payroll, HR, GIS, police records, fire EMS, risk management, business license applications, etc.”
City of Hoover, Alabama More »

The IBM logo and the IBM Member Business Partner mark are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. All other trademarks used herein are the property of their respective owners. ©Copyright 2013 Electronic Storage Corporation. All rights reserved.





Steps to Rebuild Master Database In SQL Server #backup #database #sql #server

#

Rebuild Master Database in SQL Server Without Backup

It has been observed that many SQL Server administrators, in fact majority of them, backup their user databases regularly, but turn a blind eye to the system databases. While most of them do not understand the value of these databases, some remain in their comfort zone owing to the years of no failure. Whatever be the reason, we will help you to be acquainted with the methods to restore the system databases, should the admins find themselves in a crucial situation.

Reasons Behind Master Database Rebuilding

There are a number of reasons due to which, the master database needs to be rebuild. Some of them are:

  • At times, user delete some crucial information like linked servers, logins, SQL Server configuration, and other user objects.
  • The master database is not coming online and the admin does not have a backup of the master database.
  • It can also happen that the master database has been corrupted due to various hardware and software failure and can no longer be used.
  • The administrator might want to make a clone of the server or might want to restore the master database to a new instance.

How to Rebuild Master Database in SQL Server?

The following procedure will help you to rebuild the master system database. The entire process, which we will discuss in this write up, will be divided into three sections for the convenience of the users.

1. Pre-Rebuild Process

Since, only the master database is corrupt, therefore, in order to ensure the authenticity of other system database files, it gets necessary to take their backup. The files that need to be backed up are MSDB Data, MSDB Log, model model Log In order to do so, follow the below mentioned steps:

  • Open SQL Server Configuration Manager.
  • From the left pane, select SQL Server Services option. This will list all the services that are currently running.
  • Right click on the service and select Stop option for stopping all the services one by one.
  • Exit SQL Server Configuration Manager.
  • Browse to the location where all the system files of a particular SQL Server instance are stored.

C:\Program Files\Microsoft SQL Server\[INSTANCE NAME]\MSSQL\DATA

Note: Keep in mind this location, as this is where the master database files will be rebuild automatically.

  • Cut all the healthy system files, save them in a new folder, and delete corrupted master mastlog, tempdb, templog files.

2. Rebuilding Process

The steps that are followed for rebuilding are:

  • In the command prompt, change the directory location of the server instance to the location where the SQL Server 2016 installation media.
  • Open Command Prompt as Administrator.
  • Since my installation media is stored in the F: Drive, change the directory location by entering f: and press Enter.
  • The next step is to run the following command:

    Note: In case your account name contains a blank space, keep in mind to enclose the account name within quotes. Moreover, if you are specifying multiple accounts, separate them with a space.
  • When all the system databases are rebuilt, it returns no message in the command prompt. In order to verify whether the process has been completed successfully, examine the summary.txt file. the location of this file is:
    C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Logs

3. Post-Rebuild Process

  • The first step after rebuilding is to restart all the services, which were stopped earlier.
  • If you have backups of model and MSDB databases, restore them.
  • In case the backup is not present, simply replace the rebuilt MSDB and model files with the files that were backed up in the I. section. (This should be done after stopping the services).

In this blog, we have described the full procedure for rebuilding the master database in the scenario when the backup is not available.We believe that with its help you will be able to rebuild the master database successfully.





Backup live mail #online #backup, #data #backup, #msp #backup, #white #label #backup,

#

RBackup Remote Backup Software works like regular data backup software, but with one important difference. Instead of sending backups to a tape drive or other media attached to the computer it is backing up, RBackup online backup software sends the backup over the Internet or other network connections to your online backup server safely offsite. It does this (usually) at night while computers are not being used. Backups can also be done on-demand, any time.

It is completely automatic. In fact, you may even forget it’s working. Most businesses put their lives on the line every night and don’t realize it. With businesses depending more and more on the data stored in their computers, proper backups are becoming much more critical.

RBackup Online Backup Software constantly re-evaluates the computer system, adding files to the backup as needed. Several full copies of files are stored using a sophisticated version control system unavailable in most other backup software of any kind. The general definition of “proper” backups requires redundancy. One must keep multiple copies of the same files at different points in their development, called versions. As an example, you should have a different copy of each backed-up file for each backup session. Further, you should be able to easily restore any of your files up to any given point in time. Banks do it, big corporations do it, and so should small businesses. Only RBackup has such an easy to use version control system.

Backups are encrypted for complete security. Tape backups are not generally encrypted, so anyone can read them and gain access to client database, billing records, payroll, tax info, and everything else on computers. RBackup encrypts its backups using your choice of eight of the strongest cryptographic methods in the world for complete security so nobody, not even the RBS Service Provider, can read the files.

Finally and most importantly – Backups are immediately sent offsite and stored safely away from the clients’ computers and their businesses. This is where almost every business makes its biggest mistake. Even if they do everything else perfectly, backups are of little use if their building burns, or they are unable to physically recover their tapes from the premises. Most small companies who do backups leave the tapes in the building with the computer, where they can be destroyed right along with the computer.

RBackup Online Backup Software – Back up at the file level, database level, VMware Workstations, and full disk images. RBackup can maintain immediately mountable VHD files for lightning fast onsite disaster recovery.

There are built-in agents to back up all versions of Exchange at the brick level, SQL Server, Active Directory, Sharepoint, Windows VSS and other “special” databases and file sets, including file that are open and in use. Using our Redundant Hybrid Backup, your clients’ data can be sent — encrypted, compressed, and compliant — to up to three different locations for maximum security. Restores can be performed over the internet or, directly from your RBackup Server directly to a local drive, and by shipping a fully encrypted, fully compliant backup via USB drive.

First full backups can be “seeded” via portal hard drive.

Between our vast feature set and iron-clad security protocols, you’ll be equipped to handle virtually anything a client can throw at you. Advanced compression and Bit Backup ensure that you’re ready to handle graphic artists or firms, and secure encryption helps you maintain compliance with HIPAA, GLB, and SOX so you can cover medical offices or CPAs.

RBackup is licensed by the types of end user accounts that are added. Adding end user accounts uses Licenses on the server, depending on the edition of the Client software installed.

Permanent Licenses are used by our Standard Licensing Model software – Starter Packs, Premium Packs, and All Inclusive Packs. This is our one-price, lifetime license model. Permanent Licenses never expire, they recycle automatically, and they never need to be renewed. Adding new client accounts uses Licenses from the Server. Deleting accounts returns Licenses to the Server.

Monthly Licenses are used if you choose a Subscription Licensing Model when you purchase your software. Under the Subscription Model, Monthly Licenses are used up monthly and must be replenished when they run out.

Interested? Need more info? Contact us to schedule a one hour demonstration, ask questions, or get technical support.

Remote Backup Systems also offers a fully-functional 15-day trial. Take some time to experience the world’s most popular, feature-rich offsite data backup software for yourself in a live environment. If you like it, we can activate your trial to live in just a few minutes, with no need for you to start over from scratch. Your RBackup evaluation includes Priority technical support and access to all of the core software’s features.





Select Solar Panels, PV, 12V Solar Panel Kits UK #select #solar, #12v

#

My wife and I chose Select Solar, to install a photovoltaic (PV) system after lengthy research and talking to other solar installers. What impressed us first was how easy it was to talk with Colin Howe and how knowledgeable he was with the current state of the solar industry. We had two requirements in reducing our electrical cost; find a way to reduce our daily demand and then create supplemental power that we would use in our house and feed back to the local electric grid.

the order arrived the next day.

Easy to order and no problems whatsoever.100% happy.

Ace Solar Power

Like your website

Most cost effective quote. Install is of high quality and they were good to work with. I recommend them if you are considering putting solar at your home.

good. web site easy and fun

Thank you Colin. I had a technical enquiry that was dealt with by Colin over the telephone. Very professional service and answered in terms that I could understand. My specific technical enquiry was dealt with a professional manner but without the salesman jargon that I had been getting all day.

Take a look at our featured products.

Select Solar – the solar power specialists

Select Solar – the solar power specialists, with one of the biggest and best selection of solar pv energy products for business and leisure. We sell top quality branded solar products backed by full warranties, complete technical specifications, and excellent uk customer service.

Whether you need 12V or 24V solar panels or just components (such as a charger for your motorhome or boat) or full solar panel kits with accessories for professional business or leisure projects, Battery Back-up for your existing Solar Installation, we may well have exactly what it is you are looking for.

If you just want green energy products to use around the house, we have those too. If you require any technical information or other help, we ll be delighted to advise you.

Click here to read more about Select Solar and our group of companies.

Latest Blog Post

Select Solar Supply the most comprehensive and tested range of eco products including 12v Solar Panels ranging from 10w up to any amount. Read more

Our Guarantee

If you are not happy, send it back within 14 days for a full refund. Read more here .

We send to anywhere in the world, dispatching most items within 3 working days of order. We will let you know if it will be longer. Full delivery details here.





Disk Image software #disk #image #software, #disk #image, #data #backup, #freeware, #disk

#

Disk Image Software

January 8 2014, Richard Pardoe,
technology blogger

Imagine the situation: you’ve just created an image of a really valuable disk. Maybe it’s an image of favourite DVD that you’re taking on holiday, or perhaps it’s a backup of a solid state hard drive containing critical business data.

October 9 2013, Richard Pardoe,
technology blogger

Data is a precious commodity, and a significant data loss can cause havoc in your personal life, career or business.

In today’s digital age, we’re all well aware of the importance of backups. But how many of us are really doing them regularly? If the computer you were reading this on suddenly died, would all your crucial data be safely stowed away somewhere else and easily recoverable?

Keep Your Data Safe Using Disk Image Software

August 27 2013, James Ford
a computer specialist for a medium-sized company

Disk image software provides the ultimate solution to data backup since it allows you to make a complete, byte-by-byte copy of an entire disk without the risk of missing anything important.

An error appears indicating the CreateSnapshotSet() failed. What should I do?

August 8 2012, RobinZon
a data backup software reviewer

If you, like me, find yourself in a constant struggle, trying to keep your computer under control in terms of starting up and keeping your data safe; you should try Disk Image, a program I recently started using. In short, the name describes what it does.

This software helps create a disk image of your computer, which is basically like a backup of your entire machine (you can choose to save less if you want). What’s awesome about this software though is that it comes with more than just the tools to do that. It also comes with a powerful feature called “Boot Disk”. But I’ll talk about that later on in this… review, I guess?

“A great way to restore computers from unstable states”

August 2 2012, Michael Findley
a small business owner in the GTA

Read more: Disk Image Users Guide . Sales Questions





Enabling the Windows Server Backup feature in Windows Server 2008 #remote #server

#

Enabling the Windows Server Backup feature in Windows Server 2008

NTBackup is not a fancy backup mechanism, but it generally worked and could easily be scripted. Windows Server 2008 replaces NTBackup with Windows Server Backup.

I bet at one time or another you had an NTBackup script for a specific part of a server that you used between versions of Windows. Unfortunately, these scripts will no longer work, so the migration to Windows Server Backup will need to be considered for the local backup mechanism.

Windows Server 2008 offers many components that are not part of the base installation but need to be added as a feature. Figure A shows the Windows Server Backup being added through the Add Features Wizard. Figure A

When adding Windows Server Backup, be sure to add the command-line tools option because it is not a default. Once you select the features, the server will not need to be rebooted in most configurations. At this point, you can enter the Windows Server Backup program to perform tasks.

If you selected to install the command-line tools, you can also work on creating backup tasks with the wbadmin command. The wbadmin command offers a more extensive command-line environment compared to NTBackup; all functionality can be performed via the command line. Windows Server Backup also has PowerShell support so that backups can integrate more closely to products like Exchange or SQL.

Both Windows Server Backup and wbadmin can be used to interact with remote computers for jobs to back up the remote system, which is entirely new functionality.

For more information on the new backup functionality, read the TechNet article Windows Server Backup Step-by-Step Guide for Windows Server 2008 .

Stay on top of the latest Windows Server 2003 and Windows Server 2008 tips and tricks with our free Windows Server newsletter, delivered each Wednesday. Automatically sign up today!

About Rick Vanover

Rick Vanover is a software strategy specialist for Veeam Software, based in Columbus, Ohio. Rick has years of IT experience and focuses on virtualization, Windows-based server administration, and system hardware.

Full Bio

Rick Vanover is a software strategy specialist for Veeam Software, based in Columbus, Ohio. Rick has years of IT experience and focuses on virtualization, Windows-based server administration, and system hardware.





2017 Carbonite Review #server #cloud #backup #reviews

#

Carbonite Review

Store large quanities of files on any plan

All of Carbonite s personal plans include an unlimited amount of storage space, making them a perfect choice for individuals hoping to back up their entire hard drive. Only one computer may be backed up per license, but there s no limit to the amount of data that can be backed up from that computer. There are also no restrictions on the sizes of individual files. Whether it s a small document or a large video file, it can all be uploaded to the cloud, synced across devices, then restored later if you need it. These unlimited personal plans are also ideal for users who are looking for a cloud storage plan they can stick with for a number of years without having to worry about increasing storage limits or paying higher monthly fees.

Plans that fit easily into your budget

Considering the fact that all of Carbonite s personal plans come with an unlimited amount of storage space, their rates are surprisingly affordable. Their Basic plan only costs about $5 per month per computer and you re able to upload as many files as you want to the cloud. One thing to be aware of with Carbonite s pricing structure is that you must pay for at least one year of service upfront. There are also two- and three-year terms available if one of these suits you better. The longer you subscribe for, the more money you save. If you plan on sticking with the same cloud storage service for a considerable amount of time, you re better off paying for a longer term when you sign up if you can manage it.

Quickly restore files to your computer

In the event of a computer crash, restoring your files from Carbonite is as simple as logging in to your online account and downloading everything back onto your device. However, when time is of the essence, this may not be ideal. That s why Plus and Prime members have additional restoration options designed to speed up the process. These users are able to create a local backup of their hard drive in addition to storing their files online. Restoring this way is going to take much less time because you aren t limited by the download speeds of your Internet provider. In addition, Prime members are also eligible for courier recovery service, where your files are quickly shipped to you following a computer crash. These additional options are quite rare among cloud storage providers, but they could really help to eliminate some of the headache of restoring your files, so it s worth considering when choosing a cloud service.

Discuss files within the cloud

Using Carbonite s Sync Share center, you re able to invite others to view certain files and add comments for the rest of your group to see and respond to. This resource is particularly valuable to teams that need a simple way to collaborate on projects. It allows you to easily access all the necessary documents and stay up to date on what your other team members are saying without having to bounce back and forth between your cloud storage account and your email inbox.

Back up your servers

Business owners with a lot of data to back up should take a closer look at Carbonite s server plans. They provide high levels of security and the ability to customize your settings to suit your organization s needs. Like Carbonite s other backup plans, you re able to try out their server backup service for 30 days before committing to a purchase, which is a good place to start if you re not sure if the service is right for you. Businesses who go with the Server Pro Bundle plan aren t limited to just backing up servers either. This plan includes as many laptops, desktops, and servers as you want as long as your files don t exceed your total storage space.

The Bad

Must download a separate app for sharing

The Carbonite desktop app provides you with the tools you need to back up and restore your files, but sharing them with others requires you to download their Sync Share app as well. Most other online storage services incorporate all of these tools into a single app, but Carbonite requires you to move back and forth between the two different apps. This isn t going to be a big deal if you re only looking for an online backup service, however.

Mac users have fewer options

Though Carbonite works with both Windows and Macs, their Plus and Prime plans are only open to Windows users. This means Apple customers need to look elsewhere if they re not content with the Basic plan. However, as all of Carbonite s plans include unlimited cloud storage space and 24/7 customer support, the Basic plan works just fine for most people. The only reason you d want to upgrade is if you were interested in backing up external hard drives or making a local backup of your files.

Annual pricing only

Carbonite requires you to pay for a year s worth of service at a time, which could be a problem if you re on a budget. Personal users or small businesses may not have the money to pay for an entire year of cloud storage upfront, so it d be nice to see Carbonite give these individuals the option of paying monthly for their services.

Missing a free storage plan

Because Carbonite only offers unlimited plans to their personal users, you must pay if you want access to their services. For most individuals looking to do a full backup of their computer hard drive, this won t be a problem. But, if you only intend to back up a few important files, a company that offers free storage space is a smarter choice. The majority of the industry does have some sort of free cloud storage plan, usually with about 2GB of space, though some give you much more.

Back up one computer only

Carbonite s plans only allow individuals to back up a single computer per license. If you have two or more computers that need backing up, you must buy additional licenses. This is true for the personal plans, though businesses can pay extra to upload files from as many devices as they want. Carbonite is not the only company to place restrictions on the number of computers that may be backed up, but there are also several companies without them and these may be better options for some. Dropbox is a good one to look into because they offer similar services to Carbonite while allowing you to back up files from an unlimited number of devices.

The Details





Overview of Exchange Server Backup Methods #outlook #exchange #backup

#

Overview of Exchange Server Backup Methods

Online backups are backups done while Exchange services are running. None of the Exchange services have to be stopped for this backup to complete.

Online backup does not mean that you try to back up Exchange database files and Exchange folder structure while Exchange services are running. Online backup means backing up a separate Microsoft Exchange or Microsoft Exchange Server object that is available in backup software. You can do an online backup using Backup if you install Exchange administrator or Exchange System Manager in Exchange 2000 Server on a server that will do a backup. If you use third-party backup software, you have to install the Exchange Agent or Exchange-aware backup software. Agents are popular because they extend the functionality of third-party backup software. You will be backing up Exchange Directory (Exchange Server version 5.5) or Microsoft Exchange Information Store service objects. You will not be able to select individual files to back up or select individual mailboxes that need to be backed up.

If you try to back up actual Exchange Server files and folders while services are running, backup will complete but with files that are skipped. Database files are skipped because the Exchange database engine has opened them, and only one program can have exclusive access to a single file on the disk. If disaster strikes and this is the only type of backup available, it is possible that Exchange information will not be recoverable.

When backing up Exchange Server databases, there are four backup types available:

Normal (or Full) The normal backup process backs up the directory or Exchange store in its entirety, as well as the log files. To restore from a normal backup, only one normal backup is needed. A normal backup marks the objects it has backed up so that incremental and differential backups have context. This is accomplished by backing up the entire database and all the log files, and then purging the log files.

Copy The copy backup is the same as a normal backup except no marking takes place to give incremental and differential context. This means that performing an incremental backup after a copy backup is equivalent to performing it before a copy backup. Use a copy backup to get a full backup of the directory or Exchange store without disturbing the state of ongoing incremental or differential backups.

Incremental An incremental backup backs up the subset of the component that has changed since the last normal or incremental backup. Then it marks these objects as backed up. To restore from incremental backups, each incremental backup since the last normal backup and the normal backup are needed. An incremental backup backs up only the log files, and then purges them.

Differential A differential backup backs up changes in the directory or Exchange store that have occurred since the last normal backup. To restore from differential backups, one differential backup and one normal backup is required. A differential backup backs up only the log files but does not purge them.

In few cases, performing a differential or incremental backup is disabled, for example, immediately after an offline defragmentation or while circular logging is enabled.

To restore an online backup in Exchange 2000 Server, you need the Microsoft Exchange Information Store service running, and the stores that are being restored need to be dismounted. To restore an online backup in Exchange Server 5.5, you need to have the Microsoft Exchange System Attendant service running.

Offline backups are backups of Exchange files and folders when Exchange services are not running. If services are not running, backup software can have exclusive access to database files and can back them up.

Planned offline backups will result in consistent database files. When Exchange services are being gracefully shut down, all transactions are being committed to the database. Resulting databases will be consistent, marked consistent or clean shutdown. depending on what version of Exchange you are running.

Unplanned offline backups are backups that are taken when the server fails. Database files are copied to some location because that is the only type of backup available. If Exchange Server fails before this backup, databases do not have to be consistent, so they might need repair after the restore procedure. Make sure to check if the backup was before or after the failure or Exchange Server problem.

For backup methods that are not supported, there is no guarantee that the methods will work. You should contact your third-party backup software or hardware vendor in case of problems with backup. The backup vendor should be the primary source of support in the case that any of the following backups are used. Microsoft will work with any customer that has any backup type. However, if the backup was created by one of the following methods, the only help that Microsoft might be able to provide is disaster recovery, which might involve data loss.

There are third-party backup programs that use special ways to do a file-level backup of files that are already opened by some other application, such as Exchange Server. This might or might not work. In most cases, it will not work for Exchange. There is no guarantee that this type of backup will back up all mailbox and public folder data, and that you will be able to recover from disasters such as this. Open file agent backups, in most cases, back up inconsistent databases.

There are several third-party backup programs that can back up and restore individual mailboxes, rather than whole databases. Because those backup solutions do not follow Microsoft backup guidelines and technology, they are not directly supported.

There are known problems with some versions of mailbox-level backup programs including loss of free/busy data and incomplete restores. Every effort is made to help, and to look at the errors and issues that you are having with this type of backup and restore, to determine if there are Exchange problems documented that could cause this error.

This type backup provides benefits somewhat in between offline and open file agent backups. These backups are typically done on a hard disk instead of tape devices, which allows much faster transfer rates.

Traditionally, the snapshot backup is done when databases are stopped. Because they are consistent, the restore procedure is similar to offline restore procedures. Those types of snapshot backups require downtime when backing up.

There are some backups that perform what is called a Hot Split backup. This can be thought of as a snapshot backup with an open file agent running. The result is a fast backup that does not require downtime, but the backed up databases are inconsistent. Because of that, the backup vendor might need to be contacted to make sure that data is restored without any loss.

A server running Microsoft Windows Server™ 2003 will support snapshot backups, and they are supported in Exchange Server 2003. They will utilize the Volume Snapshot service of Windows Server 2003, and they will require both the Exchange snapshot DLL and the special storage hardware.





Windows 8 Tip: Use Windows 7 System Image Backup #windows # #backup

#

Windows 8 Tip: Use Windows 7 System Image Backup

As the foundation for your mobile computing future, Windows 8 provides next generation recovery tools, Push Button Reset for OS reinstalls, and File History for document versioning. But these utilities make many PC users and enthusiasts nervous. If only there was a way to use the system image backup capabilities from Windows 7 in Windows 8.

Good news: There is.

Unsurprisingly, however, Microsoft has made this functionality hard to find. In Windows 7, you could simply search for and launch Windows Backup, and you d be up and running with a complete, system image-based backup that you could use later to restore the entire PC.

If you re not familiar with Windows Backup, please read: Windows 7 Feature Focus: Backup and Restore. And if you re unsure about whether to use this old-school backup type or the new features in Windows 8, please read Windows 8 Tip: Picking a Backup Strategy .

In Windows 8, Windows Backup is hard to find. Search for backup and you ll find only File History, for example. But it s there: Search for recovery instead.

And in the search results, under Settings, choose the renamed Windows 7 File Recovery. The control panel that launches, which, yes, is now called Windows 7 File Recovery, used to be called Backup and Restore in Windows 7. And as with its predecessor, this control panel is the front-end for Windows Backup, which provides that system image backup capability.

Windows 7 File Recovery is in Windows 8 primarily so that upgraders can access the files contained in backups previously made in Windows 7. But there s no reason you can t use this to make new system image backups in Windows 8. It works exactly as before: Just click Set up backup and get started.

Note that you ll probably also want to create a system repair disk, which can be used to boot your PC and restore it using the system image backup you re now creating, in the event of a hard drive issue or other hardware failure. I wrote about that process in Windows 8 Tip: Create Recovery Media. The recovery process has indeed changed in Windows 8, but it s straightforward and, if anything, nicer than it was in Windows 7 even if you use system image backups.

I’m not keen on the deprecation of Windows 7 Backup. Backups are an area where either the software should be kept up to date and compatible, or be eliminated entirely. (Read-only access would be an exception.)

That Windows 7 Backup is no longer getting updates in Windows 8 is fine in and of itself, given that it currently works. However the OS around it will continue to be updated, and incompatabilities that creep in could, in principle, create a situation where the user suffers data loss without any advance warning. For example even if it continues to save data correctly, if it loses the ability to restore said data the user will not become aware of the problem until they attempt to use the backup, at which point every other copy has usually been eaten by the dog.

So, I won’t be using it. Image Backup is cute if you have to swap out a drive but it turns out (after a PC migration) that I only have about two dozen apps installed, so I can do things the hard way. The File and Folder backup has always been painfully slow, especially on older hardware. It takes an age and a lot of CPU grunt to make all those 200MB ZIP files.

I used the “File and Folder” backup on Win 7 for a while. One day I decided I was tired of not being able to see what was in those zip files, so I “restored” to an ntfs partition on the backup hard drive and discovered what a disaster it was. (Yes, I had to create an ntfs partition just to do this.) The disaster part is that all my careful curating of files was lost. Everything I deleted was back! Unbelievable! I wouldn’t even had noticed, except that Security Essentials again caught a file it had caught previously and which I had deleted. So I went back to using the fast, accurate, and checkable Synctoy.





Windows r backup #windows # #r #backup

#

What is UrBackup?

UrBackup is an easy to setup Open Source client/server backup system, that through a combination of image and file backups accomplishes both data safety and a fast restoration time.

File and image backups are made while the system is running without interrupting current processes.

UrBackup also continuously watches folders you want backed up in order to quickly find differences to previous backups. Because of that, incremental file backups are really fast.

Your files can be restored through the web interface, via the client or the Windows Explorer while the backups of drive volumes can be restored with a bootable CD or USB-Stick (bare metal restore).

A web interface makes setting up your own backup server really easy. For a quick impression please look at the screenshots here .

Currently there are over 10,000 running UrBackup server instances (with auto-update enabled) with some instances having hundreds of active clients.

Download UrBackup Client
2.1.16 (Windows)

Download UrBackup Server
2.1.19 (Windows)

Other download options
MacOS, Linux, etc.

Fast. The custom client makes fast file and image backups possible. The client, for example, continuously watches file changes, so that only few files have to be looked at during incremental file backups.

Web interface. The backup server has an integrated web interface that shows the status of the clients, current activities and statistics. Existing file backups can be browsed and files from these backups can be extracted or restored.

Easy to setup. The backup server can be configured via web interface. The client via a user interface. The client can be configured from the server, making the client user interface optional.

Consistent backups while in use. UrBackup backups your computer while you use it. Open files, like Outlook .pst files, get backed up without problems. The image backups are done while the system is running and in use as well.

Space efficient. If multiple clients have the same files the UrBackup server saves them only once, leading to reduced storage requirements.

Backups via Internet. UrBackup can easily be configured to also backup clients via Internet. This enables backups of mobile devices wherever they currently are. You can also use UrBackup to only backup via Internet.

Free Software. UrBackup is Free Open Source software licensed under the OSI certified AGPLv3+. As long as you adhere to the terms and conditions of the license you are allowed to use and redistribute UrBackup in a personal and commercial setting.

Multi-platform. UrBackup server currently runs on Windows, GNU/Linux, FreeBSD and several Linux based NAS operating systems. The UrBackup client runs on Windows, macOS and GNU/Linux. See system support for details.





Mainline Backwater Valves and backflow prevention valves #backwater #valves,sewer,sewage,check #valves,floor #drain #backwater

#

Backwater Valves; presenting the new, innovative valve product designed to more economically solve flooded basement and sewer backup problems.

Raw sewage in your basement. Can you imagine it spewing out of your toilets, shower stalls and sinks? With record high precipitation in many parts of the nation, some families have experienced such unfortunate events. These backups not only cause damage that is difficult to repair, but also create dangerous health hazards. A floor drain backwater valve or mainline backwater valve can save the day. These check valves are also sometimes referred to as backflow prevention valves or backflow preventer valves .

While cities and municipalities work relentlessly to clean and inspect sewer main lines, it is still possible for a sewer main to plug up and allow water and sewage to flow into the dwellings it serves. But help is here! By installing the award winning Mainline Fullport Backwater Valve (sometimes referred as a Backflow Preventer ) in the main line to the sewer, property owners reduce their exposure to such an incident to almost nothing.

Who’s at risk? Your home or building may be susceptible to sewage backups if the lowest drain is less than 24 above the nearest upstream manhole. Most building codes require owners to install a backflow prevention valve to minimize the chance of flooding at properties with drains that meet the specification mentioned above.

How does it work? A backwater valve can be installed in the basement at the exit point from the home or building, or in the sewer lateral outside of the building.

The “lateral” is the underground pipe that carries sewage from private property to the city�s sewer main. The backflow valve is installed downstream and prevents sewage from backing up into the lateral beyond ( above ) this valve.

( SPECIAL OFFER. Access Box at reduced charge with the purchase of a 4963 ABS or PVC Backwater valve – an $89.00 value)

When installing in a lateral, the backwater valve is placed in an access box to make maintenance easy.

Backflow prevention valves (and all safety check valves for that matter) should be inspected on a quarterly basis and anytime you think they have closed. With our award-winning design, patented backflow valve, you can simply look through the clear plastic lid for easy visual inspection and remove the screw-off cap to clean out any debris!

Note: This type of check valve should not be confused with and does not replace the sewer trap that prevents sewer gas from entering a building where it is installed.

Measurements, Specifications and IAPMO Certifications

Mainline Fullport Backwater Valves offer the right solution for your sewer backup problems. SPECIAL OFFER: Mainline Backwater Valve Combo with Access Box ($89.00 value if purchased separately) Valves without Access Box are also available with a slight shipping discount in the price.

Protect Your Home with a Backwater Valve
from Backwater-Valve.com

copyright 2004-2017 Backwater-Valves.com.
Akron, OH, USA
All rights reserved.

backwater-valves.com is independently owned and resells products produced and manufactured by Mainline of Canada and assumes no liability for the installation of backwater valves and related products.

Be sure to check with the plumbing authority in the municipality in which your valve is to be installed to insure that your installation is in compliance with local code, and be sure have your valve inspected by your local plumbing inspector after installation. Inspect your valve frequently; the Backwater Valve through its clear plastic housing top, and the Adapt-A-Valve, by removing the gate cassette.

Pipe end-to-end, the Adapt-A-Valve takes up 6 of run in your line and the outlet is 1-1/2 LOWER than the inlet, so in just 6 the level of the pipe at the outlet side needs to be 1-1/2 lower.

Pipe end-to-end, the Backwater Valve takes up 12 of run in your line and the outlet is 3/4 LOWER than the inlet, so in just 12 the level of the pipe at the outlet side needs to be 3/4 lower.

Depending upon the amount of slope in your line (2% minimum is required for proper operation), you may need to replace several feet of pipe downstream from the valve to average out this loss of fall.

NOTE: New Straight-Fit and ML-FR4 require less slope. (refer to detail pages for these products)

High-volume inquires are directed to Tom at Mainline

Backwater-valves.com accepts these
major credit cards plus eCheck
using PayPal’s secure checkout.
(No PayPal account needed)
We are unable to process phone orders,
all orders must be placed via the website.
more.





Remote data backup #online #backup, #data #backup, #msp #backup, #white #label #backup,

#

RBackup Remote Backup Software works like regular data backup software, but with one important difference. Instead of sending backups to a tape drive or other media attached to the computer it is backing up, RBackup online backup software sends the backup over the Internet or other network connections to your online backup server safely offsite. It does this (usually) at night while computers are not being used. Backups can also be done on-demand, any time.

It is completely automatic. In fact, you may even forget it’s working. Most businesses put their lives on the line every night and don’t realize it. With businesses depending more and more on the data stored in their computers, proper backups are becoming much more critical.

RBackup Online Backup Software constantly re-evaluates the computer system, adding files to the backup as needed. Several full copies of files are stored using a sophisticated version control system unavailable in most other backup software of any kind. The general definition of “proper” backups requires redundancy. One must keep multiple copies of the same files at different points in their development, called versions. As an example, you should have a different copy of each backed-up file for each backup session. Further, you should be able to easily restore any of your files up to any given point in time. Banks do it, big corporations do it, and so should small businesses. Only RBackup has such an easy to use version control system.

Backups are encrypted for complete security. Tape backups are not generally encrypted, so anyone can read them and gain access to client database, billing records, payroll, tax info, and everything else on computers. RBackup encrypts its backups using your choice of eight of the strongest cryptographic methods in the world for complete security so nobody, not even the RBS Service Provider, can read the files.

Finally and most importantly – Backups are immediately sent offsite and stored safely away from the clients’ computers and their businesses. This is where almost every business makes its biggest mistake. Even if they do everything else perfectly, backups are of little use if their building burns, or they are unable to physically recover their tapes from the premises. Most small companies who do backups leave the tapes in the building with the computer, where they can be destroyed right along with the computer.

RBackup Online Backup Software – Back up at the file level, database level, VMware Workstations, and full disk images. RBackup can maintain immediately mountable VHD files for lightning fast onsite disaster recovery.

There are built-in agents to back up all versions of Exchange at the brick level, SQL Server, Active Directory, Sharepoint, Windows VSS and other “special” databases and file sets, including file that are open and in use. Using our Redundant Hybrid Backup, your clients’ data can be sent — encrypted, compressed, and compliant — to up to three different locations for maximum security. Restores can be performed over the internet or, directly from your RBackup Server directly to a local drive, and by shipping a fully encrypted, fully compliant backup via USB drive.

First full backups can be “seeded” via portal hard drive.

Between our vast feature set and iron-clad security protocols, you’ll be equipped to handle virtually anything a client can throw at you. Advanced compression and Bit Backup ensure that you’re ready to handle graphic artists or firms, and secure encryption helps you maintain compliance with HIPAA, GLB, and SOX so you can cover medical offices or CPAs.

RBackup is licensed by the types of end user accounts that are added. Adding end user accounts uses Licenses on the server, depending on the edition of the Client software installed.

Permanent Licenses are used by our Standard Licensing Model software – Starter Packs, Premium Packs, and All Inclusive Packs. This is our one-price, lifetime license model. Permanent Licenses never expire, they recycle automatically, and they never need to be renewed. Adding new client accounts uses Licenses from the Server. Deleting accounts returns Licenses to the Server.

Monthly Licenses are used if you choose a Subscription Licensing Model when you purchase your software. Under the Subscription Model, Monthly Licenses are used up monthly and must be replenished when they run out.

Interested? Need more info? Contact us to schedule a one hour demonstration, ask questions, or get technical support.

Remote Backup Systems also offers a fully-functional 15-day trial. Take some time to experience the world’s most popular, feature-rich offsite data backup software for yourself in a live environment. If you like it, we can activate your trial to live in just a few minutes, with no need for you to start over from scratch. Your RBackup evaluation includes Priority technical support and access to all of the core software’s features.





BackupAssist – System State backup and restore #backupassist, #backup #assist, #backup, #back

#

System State backup and restore

What’s included in a System State backup?

The exact system components that make up your machine’s System State depend on the operating system installed and how it is has been configured. A System State backup generally includes a copy of any installed device drivers and related files, most of the Windows directory, the Windows Registry, the Active Directory configuration (where applicable) and system files under Windows File Protection.

System State backups for Vista and Server 2008 are usually between 7GB and 15 GB and for XP and Server 2003, they are generally much smaller, being between 200MB and 300 MB. Many files in the Windows directory have multiple hard links. If you are backing up the System State using the File Replication Engine or the Rsync Engine and have Single Instance Store enabled, only a single copy of each multiply linked file will be stored on your backup destination. This data does not need to be copied on subsequent backups, which reduces backup times and saves storage space on your destination.

Why is a System State backup useful?

From a System State backup you can restore your Windows system settings in the event of a system failure or corruption. A System State backup is therefore particularly important for disaster recovery purpose as it eliminates you having to reconfigure Windows back to its original state before the system failure occurred.

We recommended that you always have a recent backup of your System State and that you should perform System State backups on a regular basis, even daily, to increase your level of protection. We also recommended that you perform System State backups before and after any major change is made to your server.

How to back up the System State

With BackupAssist v6 you can schedule local* ‘System State only’ backups across all modern Windows operating systems, or even back up the System State as part of a larger backup including files and applications, using File Replication, Zip, or Windows Imaging. A System State backup includes important Windows systems settings, such as the Registry, and is crucial for system recovery.

*BackupAssist cannot be used to back up the System State of a remote machine; you must install BackupAssist on each server of which you require a System State backup.

Complete the following steps to configure a BackupAssist job to back up the local machine’s System State:

  1. Launch BackupAssist and either edit an existing File Replication, Zip or Imaging job by selecting Edit from the top menu and choosing the appropriate job, or create a new File Replication, Zip or Imaging job by going to File New backup job .
  2. If you are creating a new job check the Backup local system state option during the Files and Folders step of the Job Creation Wizard.
  3. If you are editing an existing job select Files and folders from the left menu, click the Local system selections tab, and then enable the Backup local system state option .

How to restore the System State

Complete the following steps to restore the System Stattefrom a BackupAssist backup using the BackupAssist Restore Console:

  • Note. you cannot restore the System State from an Image backup using the BackupAssist Restore Console. You must use the built-in Windows tool, wbadmin. Visit wbadmin.info for instructions.
  1. In BackupAssist, Click Restore in the top navigation bar and choose the BackupAssist Restore Console .
  2. Click Load all known backups to load all backup catalogues located in the BackupAssist settings folder, or use the Browse option to locate the backup set from which you want to restore.
  3. Choose the job that corresponds to the backup from which you want to restore the System State
  4. Use the calendar to select the date of the backup from which you wish to restore.
    • Note. dates for which backups are available are marked in bold on the calendar.
  5. Use the middle pane to expand the loaded backup set and select the System State to restore.
    • Note. files located on the Windows system drive (C: drive in the example above) may be available for restore, even though only the System State was selected for backup. These files are associated with the System State. If you choose to restore individual files from this list and not the System State, the System State will not be restored, and the files themselves may not restore correctly. If you choose to restore these files together with the System State, the System State option will override selections where there is an overlap. If you want to perform a full restore and are unsure which files are included in the System State we recommend selecting both the System State and all other files listed.
  6. Once you have made your selections click the Restore to button on the bottom right of the window.
  7. The restore confirmation screen will then load:
    You can choose to restore the System State either to its original location or to an alternate location of your choosing. If you select an alternate location click [. ] to set an alternate restore path.
  8. Once you have selected where to restore the System State to, click OK to perform the restore.
    • Note. if you are restoring the System State to a machine that hosts Directory Services, you will be prompted to reboot into the Directory Services Restore Mode.
    • Note. During a System State restore the necessary files are copied to a temporary directory and then moved to their correct location after a reboot of the machine. Before the restore starts, the Restore Console will take a VSS snapshot of the volumes to be restored. This allows the user to manually roll back to a pre-restore state, if necessary, using Windows’ previous versions feature.





Offsite backup solutions – easy with Veeam #best #offsite #backup #solution

#

Off-site backup
and disaster recovery (DR) in the cloud

Let s face it who wants to build and maintain a secondary site, when you can send your
backups and replicas off site to a trusted service provider? Let the experts build and manage this site for you.

Consider the cost advantages

IT pros everywhere are gravitating toward this compelling economic model. Don t make a big capital investment in hardware that you then have to maintain. Use someone else’s hardware and pay-as-you-go.

Improve security without
sacrificing control

No matter where your data is stored you control it with AES 256-bit encryption during backup, in-flight and at rest in the cloud.

Take the strain off your internal resources

Reduce the complexity of your on-premises infrastructure and become better protected if something happens to your facility, which also frees up your team to work on other projects.

Automate it work smarter,
not harder

Don t learn a new UI or have to recreate and manually configure your cloud backups. Veeam has created an easy way for you to extend Availability to the cloud with Veeam Cloud Connect.

Find a Veeam Cloud Connect
service provider

The Disaster Recovery as a Service (DRaaS) and Backup as a Service (BaaS) experts

Off-site backup and disaster recovery 24.7.365

WHY DO YOU TRUST VEEAM?

You trust Veeam because we live and breathe backup, recovery and replication.

WHY DO WE TRUST THESE SERVICE PROVIDERS?

We trust these service providers because they live and breathe DRaaS and BaaS, and they use our technology to make it happen.

Don t take our word for it

Learn from the industry

Get your DRaaS basics

DRaaS issues, trends and
best practices

The biggest challenges
with cloud backup and DR

Embracing BaaS and DRaaS

Get started today!

Here s what you need to know about getting backups and replicas off site:

If you own Veeam Availability Suite , Veeam Backup Replication or Veeam Backup Essentials , you already have Veeam Cloud Connect. You just need to turn it on and acquire the compute and/or storage resources from a service provider.

If you have either Enterprise or Enterprise Plus editions, you can accelerate your data transfer to the cloud by up to 50 times faster with built-in WAN acceleration to Veeam Cloud Connect targets, a special perk for Veeam Cloud Connect users.





How to Use iCloud Keychain #icloud #backup #from #computer

#

How to Use iCloud Keychain

Open Settings. It’s a gray app that contains gears (⚙️) and is typically located on your home screen.

Tap your Apple ID. It’s the section at the top of the screen that contains your name and image if you’ve added one.

  • If you are not signed in, tap Sign in to (your device). enter your Apple ID and password, then tap Sign In .
  • If you are running an older version of iOS, you may not need to do this step.

Tap on iCloud . It’s in the second section of the menu.

Tap Keychain . It’s near the bottom of the “APPS USING ICLOUD” section.

Slide iCloud Keychain to the “On” position. It will turn green.

  • If prompted, enter your Apple ID and password.

Choose your passcode settings. You can choose to use your device passcode as your iCloud Security code by tapping Use Passcode. or create a new code by tapping Create Different Code .

Enter your security code.

  • If you created a new code, enter it in again to confirm.

Enter a phone number that can receive SMS messages. This is for security verification purposes.

Tap Next . It’s in the top-right corner.

Enter your Apple ID password.

Tap OK . iCloud Keychain is now enabled. Your passwords and payment information will be encrypted and available on all iCloud-enabled devices that you’ve signed into with your Apple ID.

  • Any previously saved usernames and passwords, wireless network information, and internet accounts are automatically updated in iCloud Keychain when you enable it. [1]

Return to the Settings menu. Do so by tapping iCloud in the upper-left corner, then Apple ID and Settings in the same location.

Scroll down and tap Safari . It’s near the middle of the menu, next to a blue compass icon.





Email Archiving, Outlook Backup, Email Archiving Solution For Outlook 2003 #email #archive

#

Comprehensive Email Archiving Solution for Archiving Outlook Emails

Email Archiving have become very vital due to implmentation of FRCP since Dec 1, 2006. PCVITA Email Archive Magic provides industry most comprehensive solution for Microsoft Outlook Email Archiving. The Outlook Archiving solution provides archiving Outlook emails with ease of use and without any hassle to the users. Apart from using this as an email archiving or Outlook Archiving solution, users can also use this as a outlook backup solution to backup outlook emails. The advantage of using this compare to other outlook backup solution is that it will allow you to search within the outlook backup without the need to restore it explicitly.

PCVITA Email Archive Magic is highly intuitive email archiving solution for archiving single or multiple Outlook PST files. It periodically archive emails and remove them(*) from the Outlook PST file. This reduces the size of the Outlook PST file. PCVITA Email Archive Magic can also be used to compress the size of Outlook PST file apart from using it as an email archiving solution.

FREE Demo Version Try and Check the Product:

Easy Intuitive user interface for email archiving or Outlook Archiving solution.

Integrated within Outlook for accessing archive emails.

Email archiving of multiple Microsoft Outlook PST files.

Powerful search to search within archived emails.

Search within email attachments stored in the email archive.

Reduce the size of Outlook PST file and store in email archive.

PCVITA Email Archiving Powerful Search :

  • Search on Body of the Email Message within the email archiving data.
  • Unique feature of search within attachments for the email archiving data.
  • Search results based on folder, received time and other attributes of email archiving data.

The Demo Version of PCVITA Email Archive Magic will work for one month from the time of its installation. After the expiry date, you can only search through the previously archived data but archive feature will not initiate. For using the software for a longer period of time, you would need the Full Version.

  • As you install the product, you will get a screen where you will be asked for a storage path i.e. where you want the archived mails to be stored. You can select the frequency also for archiving and this is applicable only for default PST. When you install the product, the default PST will be archived with the selected frequency.
  • The software add-in will be added to your Outlook application. There will a button named as Email Archive Magic.

Get Full Version for Long Run Usage

The Full Version of PCVITA Email Archive Magic software works for a much longer period of time as compared to the Demo Version that works for only one month.





SQL server databases stuck in restoring state – Database Administrators Stack Exchange

#

This is likely caused by the restore script adding the WITH NO RECOVERY parameter to make the database ready for a transaction log apply after the restore. The database is now waiting for the latest transaction log file.

  1. Apply the latest transaction log (Using RESTORE LOG. WITH RECOVERY ). or
  2. Restore the database again, but this time using WITH RECOVERY. or
  3. Force the database out of restoring mode by executing: RESTORE DATABASE YourDb WITH RECOVERY

Before you do this, please make sure you understand the implications of these options. You may cause data loss if you are not careful.

See this for details:

When those don t work, see dba.stackexchange.com/questions/11175/ — again, LOTS OF WARNINGS OF DOOM if you don t know what you re doing and understand the full risk of data loss. But if you re in a bind on a non-production server, you ve got good backups to do a fresh restore from, and you can afford to restart SQL on said server, it works. NateJ Feb 26 ’16 at 1:18

I just had this situation, and the cure was quite surprising:

Apparently the NetBackup restore that broke left it in a weird state. No other solution worked (though I hadn’t yet tried restarting the SQL Server service)

I’d be careful with the database, though, as theoretically once a restore starts, then fails, you could have corrupted data. I’m just going to restore the database again anyway, so it doesn’t matter to me.





Understanding SQL Server Backup Types #backup #database #sql #server

#

Understanding SQL Server Backup Types

Applies to: SQL Server 2000, SQL Server 2005

Database backups are at the core of any SQL Server disaster recovery planning for any production system. Backups may be used to provide a means of recovery to a point-in-time when the database was last operational. Microsoft® SQL Server™ provides several types of backups that may be combined to formulate a customized disaster recovery plan depending on the nature of the data and the recovery requirements. It is highly recommended that all SQL Server databases be backed up periodically.

SQL Server backup media

A database may be backed up to disk or to tape. The examples in this article assume a disk backup directly into a disk file (as opposed to a disk backup device). Any database can be backed up to a random disk file at any time. The file may either be initialized (using WITH INIT) or appended with the new backup.

Types of backups in SQL Server

SQL Server provides several different kinds of backups including Complete. Differential. Transaction Log. andFile(s) and Filegroup(s) backup. A combination of these backups may be used to formulate a robust disaster recovery strategy. The following paragraphs explain each SQL Server backup type

Complete database backup

A complete database backup creates a stand-alone image of the entire database. A complete database backup is self-dependent and may be restored to either the same or a new database on the same or a different server. This provides plenty of flexibility at the time when this backup has to be restored. A complete backup may be restored without the need for any other kind of backup. It may also be performed for databases in any recovery model. Restoring a complete database backup typically would be considered a starting point for a disaster recovery situation where the entire database is lost or damaged. It is recommended that a complete database backup be performed at regular intervals for all production databases. It is also recommended that a complete backup should be performed for system databases if there are any changes performed to the SQL Server operating environment such as creating or removing databases, configuring security, creating and modifying DTS/SSIS packages or scheduled jobs, adding and removing linked servers, etc.

BACKUP DATABASE Northwind
TO DISK = c:backupsnorthwind.bak
WITH INIT

Restore syntax (Same database)

RESTORE DATABASE Northwind
FROM DISK = c:backupsnorthwind.bak

Restore syntax (New database and/or server)

RESTORE DATABASE Northwind_new
FROM DISK = c:backupsnorthwind.bak
WITH MOVE northwind TO c:new_locationNorthwind_new.mdf
MOVE northwind_log TO c:new_locationNorthwind_new_log.ldf

Differential database backup

A differential backup backs up only modified extents since the last complete backup. An extent is a group of 8 data pages each consisting of 8 KB (64 KB in total). By definition, differential backups are cumulative. The most recent differential backup contains all changes from all previous differential backups performed since the most recent complete database backup. Differential backups may be considered as an alternative for databases that are large and are modified infrequently. These would include data warehouse type of databases. Differential backups have several limitations including the following:

  • They do not provide point-in-time restore capabilities
  • They may only be restored after a complete database backup is restored
  • They may not be performed on the master database

BACKUP DATABASE Northwind
TO DISK = c:backupsnorthwind_diff.bak
WITH INIT, DIFFERENTIAL

Restore syntax (Same database Note that a complete database backup is restored first using WITH NORECOVERY)

RESTORE DATABASE Northwind
FROM DISK = c:backupsnorthwind.bkp
WITH NORECOVERY

RESTORE DATABASE Northwind
FROM DISK = c:northwind_diff.bkp
WITH RECOVERY

Transaction log backup

An SQL Server database consists of two components: data file(s) and transaction log file(s). A transaction log captures the modifications made to the database. A simple transaction may place several records in the transaction log. Each of these records is known as a log record and is assigned a unique identification number known as the log sequence number (LSN). Log records that belong to the same transaction are linked together through the LSN. If SQL Server service shuts down unexpectedly, upon restart the recovery process examines the entries in the transaction log and if there are transactions that have not been rolled forward completely, the recovery process rolls back the changes performed as part of these incomplete transactions. This operation is extremely important as it forms the basis of transactional recovery. Entries in the transaction log are also used if transactional replication is configured for the specific database.

A transaction log backup backs up all transactions since either the previous transaction log backup, or the complete database backup if there have been no transaction log backups performed for the database in the past. This backup may then be used to apply the backed-up changes, in case disaster recovery is required. Transaction log backups may only be applied to a database in an unrecovered state. A database may be in an unrecovered state if it is being restored from a set of backups as part of a disaster recovery procedure, or if it is configured as a standby database on a warm backup server. A transaction log backup also truncates the inactive portion of the transaction log, unless the database is configured as a Publisher in transactional replication and there are transactions pending propagation to Subscribers.

Each transaction log backup contains a First and Last log sequence number (LSN). Consecutive transaction log backups should have sequential LSNs for the boundary log records. These LSN values may be examined using the RESTORE HEADERONLY command. If LastLSN from the previously restored transaction log backup does not match the FirstLSN from the backup that is currently being restored, the restore operation fails with the following error: This backup set cannot be restored because the database has not been rolled forward far enough. You must first restore all earlier logs before restoring this log . If the above message is generated while restoring a particular transaction log backup, which is part of a set of transaction log backups that are to be restored, any attempts to restore further transaction log backups will fail with this message. There could be several reasons for consecutive transaction log backups being out of sequence. Some of the most common reasons noted from support experience have been:

  • The database recovery model has been changed to Simple and back to either Full or Bulk-Logged. Switching the recovery mode to Simple causes the transaction log to be truncated
  • Another transaction log backup was performed between the previous successfully restored backup and the one generating this message
  • The transaction log was manually truncated between the two backups
  • The database was in Bulk-Logged recovery model and non-logged operations were performed
  • Transaction log backups are not allowed for databases in Simple Recovery model. While in Simple Recovery model, a database’s transaction log is truncated every time a CHECKPOINT is invoked for the database

Transaction log backups provide the possibility of performing a point-in-time restore or point-of-failure restore. You can also perform a restore to a named transaction with transaction log backups.

BACKUP LOG Northwind
TO DISK = c:backupsnorthwind_log_1.bak
WITH INIT

Restore syntax (Same database Note that a complete database backup is restored first using WITH NORECOVERY, then a sequence of transaction log backups)

RESTORE DATABASE Northwind
FROM DISK = c:backupsnorthwind.bkp
WITH NORECOVERY

RESTORE LOG Northwind
FROM DISK = c:northwind_log_1.bkp
WITH RECOVERY

File(s) and Filegroup(s) backup

Use BACKUP to back up database files and filegroups instead of the full database when time constraints make a full database backup impractical. To back up a file instead of the full database, put procedures in place to ensure that all files in the database are backed up regularly. Also, separate transaction log backups must be performed. After restoring a file backup, apply the transaction log to roll the file contents forward to make it consistent with the rest of the database.