Backup and Recovery - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Backup and Recovery (RSS)
12 August 2007 19:09

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...
Posted by simonsabin | with no comments
Filed under: , ,
20 July 2007 10:32

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...
Posted by simonsabin | 3 comment(s)
Filed under: , , , , , ,
20 July 2007 09:26

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...
Posted by simonsabin | with no comments
Filed under: , ,
07 June 2007 16:52

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...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , , ,
07 June 2007 13:19

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 ...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
26 May 2007 22:39

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...
Posted by simonsabin | with no comments
Filed under: , ,
15 November 2006 00:44

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. - google_ad_client = "pub-9351707026400773...
Posted by simonsabin | with no comments
Filed under: ,
05 October 2006 15:29

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...
Posted by simonsabin | with no comments
Filed under: , , , , ,
27 September 2006 08:27

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...
Posted by simonsabin | with no comments
Filed under: , ,