On a typical day, you probably spend a fair amount of time chasing down complaints, most of which end up being network or server issues. Occasionally, you might perform maintenance on your network devices. Of all your daily tasks, probably the most tedious is manually backing up your network device configurations. This is not to […]
Read More
Organizations implement disaster recovery (DR) for a number of reasons, some of which include business continuity, data preservation, and regulatory compliance. DR is the process for restoring your systems to a previous fully functional state. However, many people don’t realize that a File Transfer Protocol (FTP) server can help with your organization’s DR efforts. A […]
Read More
Every release of SQL Server brings many new capabilities–and opportunities for something new to learn. SQL Server 2016 is nothing new in this regards. Along with many other new features in SQL Server 2016, Microsoft has invested enhancements to backup. After exploring these enhancements further, I believe these features are very much of a cloud […]
Read More
One essential task of any database administrator is to make sure the data is protected from loss. This is accomplished by regular backup and test restorations of your database. When disaster strikes (and it will, make no mistake about that), you will be better equipped to deal with it if you perform these backup and restore […]
Read More
Let’s have a look at a few scripts that will take advantage of Oracle RMAN. Backup Script The following script groups together RMAN commands in a RUN block to take a full backup of a database and its archivelogs. It assumes that you have configured the control file autobackup on in the RMAN configuration settings, and […]
Read More
Backups are very important, but they have a shelf life, too. You cannot just keep taking backups and retain all of them forever. You need to decide how long you would like to retain your backups before you can safely remove them in order to make space for more backups. Storage on a disk or […]
Read More
The data in the databases always grows, and as the backup is a copy of the data, it grows too. As the size of the backup grows, it takes more space on the disk and it takes more time to back up. When the database becomes large, you still want to back it up faster […]
Read More
Once you get started with RMAN and become familiar with its three main concepts and the tasks it can perform, you are ready to move onto more advanced concepts. The three concepts are: Backup Making another copy of data in an organized format on disk or tape Restore Getting that copy of data back into a location […]
Read More
Recovery Manager (RMAN) is the tool for backup and recovery of Oracle databases. RMAN is client software that connects to a target database and performs backups or recovery on it. RMAN always stores data about itself and its operations in the database control files as well as a special schema in another database. The best […]
Read More
While backups are the backbone for any database administrator, there hasn’t been much improvement in this space for a long time. Now, a new feature in SQL Server 2014 called Encrypted Backups, lets you choose to encrypt the backup file during a backup operation. You must use either a certificate or an asymmetric key to perform encryption during […]
Read More
Learn what SQL Server experts know about database maintenance, including how and when to use plans or scripts, and the importance of a robust recovery strategy.
Read More
Learn how to recover the master database in SQL Server 2012.
Read More