June 6, 2016 at 11:53 am
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That sounds like there's a story behind it.
June 6, 2016 at 11:58 am
Ed Wagner (6/6/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That sounds like there's a story behind it.
Of course there is. But I can't say very much more about it than this.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 6, 2016 at 12:12 pm
WayneS (6/6/2016)
Ed Wagner (6/6/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That sounds like there's a story behind it.
Of course there is. But I can't say very much more about it than this.
haha we had a system like that once except it also sent an email when it DID succeed. However, the person who was responsible for the job set up a rule in outlook to move the emails to another folder so they never got seen good or bad. Kind of defeated the purpose of the communication. :hehe:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 6, 2016 at 12:36 pm
Phil Parkin (6/6/2016)
Any Oracle users out there who are keen to move to SQL Server? This may be of interest.
The move requires SA, so it's not free, but it's certainly cheaper than Oracle licenses.
June 6, 2016 at 12:37 pm
Pensacola was great as well. Smaller than the past, but still a good 150 and a fun event.
June 7, 2016 at 7:29 am
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.
June 7, 2016 at 8:13 am
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.
Nah. I was sorely tempted to put together a Powershell script to actually do what they wanted, then wait for the "I tried running this in SSMS and it failed" response...
Then I thought about commenting that the people here are very helpful, as long as you show signs you're trying to help yourself, just asking for the answer to an interview question is not "trying to help yourself" and will tend to get ignored or dog-piled...
But I've got better things to do with my time.
June 7, 2016 at 8:32 am
jasona.work (6/7/2016)
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.Nah. I was sorely tempted to put together a Powershell script to actually do what they wanted, then wait for the "I tried running this in SSMS and it failed" response...
Then I thought about commenting that the people here are very helpful, as long as you show signs you're trying to help yourself, just asking for the answer to an interview question is not "trying to help yourself" and will tend to get ignored or dog-piled...
But I've got better things to do with my time.
Like posting on the thread? :-D:hehe:
June 7, 2016 at 8:36 am
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
Which is why we have a ridiculously redundant method for verifying all that stuff, including restoring "prod copy" versions to our QA environments on a daily basis.
June 7, 2016 at 8:43 am
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
June 7, 2016 at 8:47 am
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
Even a success notification of the backup doesn't mean the backup succeeded. Brandie is right, to truly know a backup succeeded you need to restore from the backup.
Backups are worthless, Restores are priceless!
June 7, 2016 at 8:49 am
Lynn Pettis (6/7/2016)
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
Even a success notification of the backup doesn't mean the backup succeeded. Brandie is right, to truly know a backup succeeded you need to restore from the backup.
Backups are worthless, Restores are priceless!
I remember once hearing someone say, "you shouldn't have a backup plan; what you need is a recovery plan."
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
June 7, 2016 at 8:51 am
Ray K (6/7/2016)
Lynn Pettis (6/7/2016)
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
Even a success notification of the backup doesn't mean the backup succeeded. Brandie is right, to truly know a backup succeeded you need to restore from the backup.
Backups are worthless, Restores are priceless!
I remember once hearing someone say, "you shouldn't have a backup plan; what you need is a recovery plan."
You can't truly have a backup plan until you do have a recovery plan anyway.
June 7, 2016 at 8:59 am
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.
It was almost as sarcastic as using LMGTFY but I'm absolutely with you on this. It wasn't a difficult question and I saw nothing of intellectual curiosity on the part of the OP. Certainly, they're not qualified for whatever SQL Server related job they were going after even if you just measure the intellectual curiosity part. And I find it difficult to believe that anyone thinks that's the wrong question to ask on a technical interview.
You seen my posts on the subject before... I'm totally disgusted with both the extremely low level of knowledge that 90% of the applicants have and the total lack of investing some time to get that knowledge.
To wit, the sarcasm was actually well placed. I just wouldn't get in the habit because it will affect you in your dealings with people that you have to work with.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 7, 2016 at 9:02 am
Lynn Pettis (6/7/2016)
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
Even a success notification of the backup doesn't mean the backup succeeded. Brandie is right, to truly know a backup succeeded you need to restore from the backup.
Backups are worthless, Restores are priceless!
Of course, I was implying that the email notifications should be for success of the process. So, if you don't get the email, you'll know that something is wrong. With some luck, it'll be the notification.
Of course, full validation of backups will be life-saving.
Viewing 15 posts - 54,466 through 54,480 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply