One of the most important things that you can do as a DBA, or really as any sort of system administrator, is back up your system.Ensuring that you have have backups, and of course, that you can restore them, is the number one priority for sysadmins. Everything else that you need to do is second to backups. After all, backups ensure you still have a system after a disaster. If you can't do that, then security, performance, features, none of that matters.
I have worked in large and small environments, and in all cases, I've assumed that as the DBA, I need to be checking that backups are occurring, and that I can restore them in case of any issues. Often this has meant I need to work more closely with others that have the actual responsibility for performing backups. This week, I'm wondering how many of you work in similar situations.
Who is responsible for backups in your company?
Is it the sysadmin of each particular application? Does the DBA ensure database backups while the Exchange administrator handles mail backups? Do you have a centralized system for backups? If backups fail, who's going to get yelled at? Or perhaps more importantly, who will notice that backups have failed?
There are any number of ways to handle backups, and honestly, the best way I've seen had a centralized person responsible for running backups every day and checking on automated tasks, but the individual system owners (DBAs, Exchange admins, application managers) checking that backups had been made. These individuals also test restores periodically. In this way there was always someone to double check the person responsible.
Let us know this week how things work in your environment.
In one installer, the award-winning SQL Toolbelt contains everything you need to work with SQL Server. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download a free trial.
Get to grips with SQL Server replication
In this FREE eBook, Sebastian Meine guides you through the fundamentals of SQL Server Replication, to the point where you should feel comfortable using it in production. Download the free eBook.
OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we... More »
Question of the Day
Today's Question (by Nenad Zivkovic):
Let's say we have two tables (A and B) created with following script:
CREATE TABLE A (X INT);
INSERT INTO A VALUES (1),(2),(3),(4);
CREATE TABLE B (Y INT);
INSERT INTO B VALUES (1),(2),(3),(4),(5),(5),(5),(5);
How many rows are returned by the following statement?
SELECT TOP ( ( SELECT COUNT(*)
) + 1 ) WITH TIES *
ORDER BY Y;
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: Top.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
Pick up your copy of this great book from MVP Glenn Berry at Amazon today.
Yesterday's Question of the Day
(by Tom Thomson):
Which of the following editions of SQL 2014 suppotys the Buffer Pool Extension feature?
Answer: Enterprise and Standard edition
The Buffer Pool Extension feature is supported in Enterprise, standard, Evaluation , and Developer editions only.
Urgent help needed..PLZ HELP ME..
- Hi everyone..
I got patient_table columns [patnt_no],[patnt_refno] ,[admit_date],[discharge_date] ,[hospital_branch]
i just want retrieve patient information from 1st discharge date to 6 months...
Sum function where field =
I am trying to use sum function where a field falls into specific category, but so far no luck.
sp_who2 active report help
- I was having 'Slowness' on App server. when I ran 'SP_who2 active' ON DATABASE server found these:
XP_Cmdshell 'Access is denied'
- Hi All,
xp_cmdshell 'dir \\Server001\e$' - running in Server2
xp_cmdshell 'dir \\Server002\e$' - running in server1
OUTPUT : 'Access is denied.'
But I'm able to access through...
How to find SPs with parallel plans? Really this simple?
- Our high usage OLTP server has MAXDOP = 0 and Cost threshold = 5. (12 cores)
Top wait is [url=http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/]CXPacket[/url]
I am wanting start...
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.