in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Backup and Recovery (RSS)

Browse by Tags

  • Do you do backups? Do you test them?

    I recently read a story about a hosting company that was trying to restore a server and was having problems. http://www.theregister.co.uk/2010/02/10/hostv_outage/ To me this highlights one of the most common problems in disaster recovery, not that people aren't doing backups (that is the other common...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Feb 11 2010

  • Data Data everywhere even when you think its gone

    The biggest problem I have faced in IT over the last decade has been loss of data. I have had the problem at work where servers have crashed and lost data, more often than not due to failure of disks. I have also personally felt the pain in a hard disk losing its partition information, and frequently...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Aug 12 2007

  • SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes

    It used to be fact that the leaf page of a non-clustered index pointed to the row for the page, because it pointed to the file, page and row if the file or page of the row changed the nonclustered index had to be updated. Now however the non-clustered index has the Unique Clustering Key value for the...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jul 20 2007

  • SQL Server The Truth - Instant file initialisation

    This is the first in a series of posts that are aimed at dispelling myths and beliefs as to how SQL Server operates. I have interviewed too many people and have been in too many sessions where statements are made as though they are fact when in reality they are not. Often the reason is due to a change...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jul 20 2007

  • Service Broker - Asynchronous/Multi threaded File Upload

    The code and slides from my presentation from today ( Service Broker - Asynchronous processing in SQL )are now online. The code is on codplex http://www.codeplex.com/MultiThreadedSQL , The slides are on http://sqlblogcasts.com/files/folders/servicebrokerpresentations/entry1885.aspx and a video of the...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jun 7 2007

  • Service Broker - Reliable processing

    I have just finished my presentation on asynchronous process/parallel processing using Service Broker at the Microsoft Technology Conference in Ireland . I was a bit tentative after deciding last night, after a few guinesses and whisky (thanks Barry ), to add a new feature to my presentation, failure...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jun 7 2007

  • Restoring and Attaching is a one way street

    Many people often ask how they can us a database in SQL 2000 that they have attached or restored to SQL2005. Unfortunately this is a one way street, once upgraded the only way of using a database in a previous version is to copy the schema and data manually. You can't restore or attach a database...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, May 26 2007

  • Earthquake in Seattle

    I was in the lift today and was amused when I saw one of the lights along side the normal lift lights. Surely you would know if there's and eartquake going on. You don't need a little flashing light to tell you. - var height=90;var width=720;
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Nov 15 2006

  • Native Command Substitution is not supported

    In response to a recent support incident we raised we got a response about use of detours in SQL Server. A detour is a means by which you can change what SQL Server does. This is used by Litespeed to change native backup commands into Litespeed backup commands. Whilst I always thought this a neat idea...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 5 2006

  • Restoring your SQL Server - Chicken and the Egg

    Have you tested your DR plan? Do you have one? Well if you do have one then unless you test it its worthless. There are many nuances that occur in a recovery process. The Storage Engine Team have posted about one suhc nuance. The customer was testing their DR process which included the complete restore...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Sep 27 2006
Page 1 of 1 (10 items)
Powered by Community Server (Commercial Edition), by Telligent Systems