One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.
2008-04-17
7,743 reads
2007-10-17
2,307 reads
One of the more interesting new technologies in SQL Server 2005 is database mirroring, allowing you to implement high availability on a database with commodity hardware. Jay Dave brings us a nice description of this technology.
2008-06-18 (first published: 2007-07-17)
15,399 reads
One very interesting new feature in SQL Server 2005 is the ability to run backups to multiple locations, ensuring you have a second copy of the backup file if your first one were to be corrupted. SQL Server expert Andy Warren takes a look at how this feature works and the implications of using it.
2008-05-12 (first published: 2007-06-12)
7,954 reads
In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.
2006-09-27
2,767 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
By Steve Jones
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...
By Steve Jones
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...
Comments posted to this topic are about the item Do You Have a Mentor?
Comments posted to this topic are about the item Counting Rows in DAX
Hello, I feel stupid asking this...I should be able to work itout, but here...
Ask SSC