THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Backup   (RSS)
Showing page 1 of 6 (55 total posts)
  • Mission Critical Performance Enhancements in SQL Server 2014 on DBTA.com

     Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.”  Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and ...
    Posted to Kevin Kline (Weblog) by KKline on November 28, 2014
  • Can you restore from your backups? Are you sure?

    A few days ago, we were doing restore practice drills with a client. I had tested the stuff before this, so the practice was more for the client's DBAs to test various restore scenarios, with me being able to point to the right direction (when needed), supplement the run-book and stuff like that. Always fun, I like these drills! Anyhow, This ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 3, 2014
  • Ola Hallengrens Maintenance Solution now supports mirrored backup

    You probably know that you can mirror a backup to several destinations, assuming you are on a supported edition (Enterprise or Developer). This is not the same as striping; you can compare striping to RAID 0, and mirroring to RAID 1. Ola now supports mirroring in his maintenance solution, found here. A couple of examples: EXECUTE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 3, 2014
  • Does your 3:rd party backup software ruin your SQL Server backup plan?

    Sounds scary, huh? And it surely can be! Here’s an example of one such case: A client of mine had implemented a 3:rd party backup solution in their VM Ware environment. This shouldn't affect the SQL Server backups. Or that was the plan. I won’t mention what backup software this is, since I’m sure that there are other software also doing ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 8, 2014
  • SQL Server Backup and Restore

    From Red-Gate web site you can download, for free, the eBook SQL Server Backup and Restore written by Shawn McGehee. One of the most important activities under DBA responsibility is to check backups and maintain an efficient recovery plan. In this book, Shawn McGehee explains how to build an efficient recovery plan; because after you have known ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on August 14, 2013
  • Windows Azure and SQL Database News

    This morning Microsoft released some great updates to Windows Azure.  These new capabilities include:SQL Server AlwaysOn Support: General Availability support with Windows Azure Virtual Machines for High Availability and Disaster RecoveryNotification Hubs: General Availability Release of Windows Azure Notification Hubs (broadcast ...
    Posted to Kevin Kline (Weblog) by KKline on August 14, 2013
  • The All-New 'Database Lifecycle Management" is available on MSDN

    The initial release of Database Lifecycle Management is now available on MSDN.The site is something called ''curated content''. This means it's a single consolidated location to look up lots of disparate articles and content, all in one easy to search location. This “curated content view” contains the best content, video, and ...
    Posted to Kevin Kline (Weblog) by KKline on April 5, 2013
  • SQL Server 2008R2 / 2012 Standard & Backup Compression

    This is something that is totally overlooked, in my experience, with SQL Server 2008 R2 and SQL Server 2012. On the contrary to what happens with SQL Server 2008, the Standard version of SQL Server 2008R2 & SQL Server 2012 supports backup compression: SQL Server 2008 R2 BOL ...
    Posted to Davide Mauri (Weblog) by manowar on March 25, 2013
  • SSMS 2012 Restore GUI Gotcha

    Today I want to bring to your attention an issue in the SQL Server Management Studio 2012 restore GUI. In many ways the new restore dialog is nicer than the old one, with new features and added convenience – but, as is always the Achilles heel of GUI tools like this, if you don’t know what’s really going on it can bite you. I’m not sure what to ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 15, 2013
  • March Update to Rules-Driven Maintenance

    This month I have a minor update to the Rules-Driven Maintenance code I originally posted back in August 2012. This update has just two enhancements, but they are nice ones, I think: Much improved handling for instances that use database snapshots. Ability to do intra-day differential backups purely by setting maintenance times and limits ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 11, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement