SQL Server 2008 SP2 10.50.2418.0 latest cumulative update 5 available now. You may download and test it. Cumulative Update 5 for SQL Server 2008 Service Pack 2 http://support.microsoft.com/kb/2555408
-
-
T-SQL best practice SQL server
SQL server T-SQL best practice This month’s TSQL Tuesday party is being hosted by Amit Banerjee (Blog | Twitter). He is working with Microsoft and see here his online activities MSDN. The topic this month is T-SQL best practice. It’s the both DBA and developers Topic/Job. Transact SQL is the best tool to improve the SQL server overall performance. You write your code efficiently then you no need to spend lots of money to buy extra resources like hardware, RAM etc… So the coders/developers have to know the best practice. He or She does a good job (writing correct codes) then, There is no work for the DBAs. There is lots of T-SQL best practice available…
-
SQL server Database backup restores sequence Steps
SQL server Database restores sequence Steps I have seen many people are still unclear about the database restoration sequence. Recently I have answered a number of database restoration questions SSC, MSDN… I got a comment from Anonymous user. It’s a simple task to the experienced DBAs. However it’s very important to know the database restoration sequence. It’ll help number of situations. For example, Your database got damaged in any one of the reasons. (Or) You may get a request from the DEV team to restore a database from production to development. I have already written an article about Step by step backup/restore using T-SQL. But it’s not fully focus the restoration sequence. Here I…
-
SQL server Disaster Recovery and High availability HADR basic
SQL server Disaster Recovery Options This month’s TSQL Tuesday party is being hosted by Allen Kinsel (Blog | Twitter) and the topic this month is disaster recovery. It’s a DBA Topic/Job. What is disaster recovery DR and HA high availability HA? Both are best option for the business to minimize their data loss and downtime. The SQL server has a number of native options. It is depends upon your recovery time objective RTO and recovery point objective RPO. That is how much data can you afford to lose? How long can you wait? How much money do you ready to spend? If you have answers for these questions then, you can…
-
SQL server Recovery Models and Backup types
In this post I am going to explain the importance of recovery models and backup types. Why I am writing this post ? Because, when I was teaching about the topic to my PHP friend .He got doubts on bulk logged recovery model and differential backups. I have given some examples and cleared his doubts. I am going to share this with you guys too. I hope this will help for Freshers and DBA managers. Recovery models and backup types are important to plan the recovery point objective (RPO) and recovery time objective (RTO). We can’t differentiate the recovery models and backup types. Simply, it’s a mixture. Let’s see the discussion. Manager: We need minimum data…