| A community of more than 1,600,000 database professionals and growing |
| | | Your Recovery Time Disaster Recovery is both an exciting challenge for many DBAs and also a dreaded event that many hope they never experience. When a true disaster befalls your system, there is a tremendous amount of stress as we work to get things running again so clients can access data. Even the best laid plans will often have a glitch, and while it's a great technical challenge, most of us would rather keep practicing and gaming possibilities than actually experience a disaster. The majority of our system disasters are localized to the actual machine handling our workloads. We often don't have outside disasters, like hurricanes, with disruption and damage to other parts of our infrastructure and ever our lives. When that happens on top of a down system, it's a level of stress that can affect our health. I've been lucky in that I've experienced both kinds of disasters, but never at the same time. I hope you can say the same thing. Let's assume some local disaster defalls your system. Hardware, software, it doesn't matter, but you end up with a corrupted database of some sort. This week I'm wondering if you have an idea of what the recovery time would be? How long before clients are up and running? Maybe more important, how long before you have system rebuilt? If you have some sort of High Availability (HA) plan, then you might be back up for clients quickly, in minutes or even seconds. The disaster really isn't over, however, since you are now running on less hardware than you planned. Until you can rebuild the downed node, you're still in disaster mode. If you're like most of the organizations that have employed me, you'll also be stressed as your formerly well-designed HA setup is now a single point of failure and you're scrambling to get the main node rebuilt. We often think of a disaster as the time we're down because of some event. Once clients are being served again, we tend to relax and think the disaster is over. It's not, because until you replace the affected systems and bring them back online, you're even more vulnerable than you were previously to another Murphy's Law incident. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.0MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.
Try it free |
| |
|
|
| | | | | Tomaž Kaštrun from SQLServerCentral.com General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure. More » |
| | How can you best keep production data secure when it is outside the production environment? Microsoft MVP Grant Fritchey discusses the use of dynamic data masking in production and pre-production servers, and then the strategies that can help us protect the data when it moves into less secure, and less well-controlled environments such as development and test. More » |
| | Brian Kelley from SQLServerCentral Blogs At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to... More » |
| | Bert Wagner from SQLServerCentral Blogs Watch this week’s video on YouTube. While most of us strive to make as few mistakes as possible when it comes... More » |
|
|
| | | Today's Question (by Steve Jones): What are the purchase models for Azure SQL Database? In other words, how can you scale your performance against cost? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Azure SQL database. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this table created in my system. CREATE TABLE dbo.SalesOrderHeader ( OrderKey INT IDENTITY(1, 7) , CustomerName VARCHAR(30) ) GO I realized that I made a mistake and decide to RESEED the identity value. DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0) GO I know insert some data. INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve') GO What is the value for the row with "Steve" in it?
Answer: 14 Explanation: Since there are no rows in the table, the RESEED sets the value to 0, which is the value used for the first insert (Andy). The second insert has 7 added, which is 7. The third, for Steve, gets the value 14. Ref: Identity Property - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. TempDB - Can SQL server have multiple Tempdb, and assign users to use different tempdb like Oracle does? Thanks Get total count for similar string - Hi All, Need help. I have a table which has computers and their related OU. I need to get the total... Is sp_send_dbmail Asynchronous? - Hopefully this is an easy question. In my scenario, I want some events to trigger an e-mail to someone. I have... SQL Assignment - Join 2 Tables - The data set that I have has 2 tables. One (trips) contains the start and end date in DATETIME format... RPC:Completed in SQL Profile, but the data is not updated - Hi, I am facing a strange issue. I have the simple query executed from the application: UPDATE T1 SET ALERTSPROCESSED=1,RECVERSION=1430426648 FROM BATCHJOBHISTORY... DEV - Execution plan IF there were more CPUs - Sorry, For the life of me I cannot remember how to tell the optimizer to create an execution plan as if... Filtered index missing when scripting - I have a developer who has view definition permissions on the database and is able to see the DDL on... Year By Months -Columns - Hi guys In what way can I have a result of a table that the columns are the years and months.... Combining Two Queries into Single Query - The view gives the below output. CREATE VIEW V1 AS SELECT SELECT DISTINCT PT.PRODUCT AS PRODUCT, PT.TEXT_CODE AS TEXT_CODE, PHT.PHRASE... Inside out on my Where clause logic - WHERE (B.ELIGIBILITY_FLG <>'Y' or B.ELIGIBILITY_FLG is NULL) and DM.ELIGIBILITY_FLG <>'Y' B is Sol Tracker and DM is Duty Manager I want to see all... very slow select - Team, I have this query that runs quite a long time, actually the result is not been displayed at all. Want to Create a User and Assign Permissions in Multiple Databases at once - I have about 60 SQL Servers and I have an AD group that has Developers in it. I'm trying to... How do I change a SELECT statement in a stored procedure based on the value of a variable? - I've got a web page (.Net web forms) where a user can display sales invoices by date only or date... Query tuning with conditional aggregation - Hi all, I have a stored procedure that returns a table 1Million + rows that I then need to pivot (I can't... Where do you put your design notes/comments? - I want to keep track of changes I make to reports but I'm not sure what's the best way to... Restored SSRS not working - hi folks we had a pretty bad attack on one of our sql servers which also runs ssrs 2005 the server was... Build dimension as a VIEW - Hello, I have build a dimension as a VIEW. Definition of the view is below: CREATE VIEW dbo.PowerBI_DimClient(ClientId,Client) WITH SCHEMABINDING AS WITH CTE AS ( SELECT DISTINCT... Cube switching - Hi all We've been looking at schema switching to minimise downtime for users (and it's going reasonably well in testing). We have... Entity Framework & RowVersion - Hi all, One of our developers has put a rowversion field with the datatype timestamp into all of the tables of... CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE.. - hi all... I have a query the returns country....state...and cities the cities are creating ore rows than required, I need to... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
