How To Configure Backup Compression
Backup Compression
In spite of \having been through a data compression process, the compressed backup actually has a few advantages over regular backups.
How to backup a table in SQL Server
Standard SQL Server backup does not support backup of a separate table, but this does not mean that this task cannot be solved in principle. Several tools and tricks allow you to backup a single table with data.
However, please pay attention that the fact that you need to backup an individual table, in some cases, may be a sign that the database is poorly designed. Perhaps the table you want to backup needs to be moved to a separate database. SQL Server supports cross-database queries, and at the SQL query level there is access to tables in other databases.
The main problem with backing up a separate table is that the backup data in the table is not consistent with the rest of the database, which can lead to logical errors in the data or banal foreign key errors.
Windows Azure SQL Database Backup – TIPS
Having the possibility to backup your SQL Server databases to Windows’s cloud platform is very convenient, easy, and takes a great weight off your organization’s shoulders but there are a few things that improve this process.
Just by adopting a few good practices in your work with Azure you can improve the entire flow of backing up and restoring your databases.
Backup SQL Server databases to Windows Azure
There is good news for SQL Server DBAs and also for other users who are interested in backing up their data to safe and reliable cloud storage.
Microsoft has announced a couple of days ago several new ways of backing up and recovering SQL Server databases to their online cloud-based storage platform and infrastructure system, Windows Azure.
Database stuck in RESTORING state
Have you ever tried to restore your database, but while doing so the operation is stuck in RESTORING state?
If the following steps are similar to what you did, then you can find the answer at the end of this article:SQL Server backup and restore
In order to understand the importance of SQL Server backup and restore, imagine a situation in which one of your colleagues creates a SQL statement without a WHERE clause and executes it, resulting in all of the data being destroyed.
SQL Server log file is too big – resolved!
If your SQL Server transaction log (LDF) file is too big – you are doing something wrong. As technet puts it:
Typically, truncation occurs automatically under the simple recovery model when database is backed up and under the full recovery model when the transaction log is backed up. However, truncation can be delayed by a number of factors. For more information, see Factors That Can Delay Log Truncation.