News

Joey on SQL Server The Right Approach to Database Backups Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things ...
According to Idera, its SQL Server database backup and recovery solution, SQL safe, helps database administrators increase backup compression up to 95% and is at least 50% faster than native SQL ...
I have a SQL server that is freezing IO on all DBs 6 times per day at about 2am, 6am, 10am, 2pm, 6pm, and 10pm. These only freeze IO for approximately 2 ...
Data management: Since DBA’s already have native SQL backup as a way to restore data, Sean McCown poses, “why is everyone like Quest and Red-Gate fighting over the SQL Server backup arena?” ...
RDS for SQL Server provides full database backups, not incremental, and these backups can be encrypted through integration with the AWS Key Management Service. Native backups use the standard SQL ...
This excerpt from the upcoming book, SQL Server 2008 Administration in Action, introduces the role of service-level agreements (SLAs) as part of a DBA's overall strategy to maintaining reliable ...
AlwaysOn encompasses high-availability and disaster recovery technologies that are also available in SQL Server 2012, including failover clustering and the use of active secondaries for backup.
SQL Server 2014: Backup to the cloud A new feature, which first appeared in an update to SQL Server 2012, is the ability to back up a database to an Azure URL (blob storage) using T-SQL or PowerShell.
With the Backup Analyst for Microsoft SQL Server tool, which is a separately priced option for DBArtisan, SQL Server files can be compressed to 80 percent to 90 percent of the actual file size ...