SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Backup Responsibility

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.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 2.2MB) podcast or subscribe to the feed at iTunes and LibSyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Everyday Jones

Follow Steve Jones on Twitter to find links and database related items and announcements.

ADVERTISEMENT
SQL Toolbelt

16 essential SQL Server tools

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.

Fundamentals of Replication eBook

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.

SQL Backup Pro

SQL Backup Pro "It just works”

The SQL Backup step-by-step wizards and a centralized GUI take the legwork out of creating, restoring, and verifying your backups. Check it out for yourself with a free trial.

Featured Contents

 

How to receive alerts when you centralize your SQL Server Event Logs.

Geoff Albin from SQLServerCentral.com

Learn how you can get alerts when you centralize the Event log. This is part 2 of the previous article "How to centralize your SQL Server Event Logs." More »


 

PowerShell One-Liners: Variables, Parameters, Properties, and Objects

Michael Sorens provides the second in a series of collections of general-purpose PowerShell one-liners to cover most of what you'll need to get useful scripting done. More »


 

From the SQLServerCentral Blogs - Power Query to HDFS – Remote Name Could Not Be Resolved

Devin Knight from SQLServerCentral Blogs

I wanted to share a quick resolution I had to a problem with connecting Power Query to data stored in... More »


 

From the SQLServerCentral Blogs - DAX #2 – Installing AdventureWorks DW Tabular Model SQL Server 2012

Sherry Li's BI Corner from SQLServerCentral Blogs

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(*)
                FROM A
             ) + 1 ) WITH TIES *
    FROM B
    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 Contribution Center.

ADVERTISEMENT

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

Yesterday's Question (by Tom Thomson):

Which of the following editions of SQL 2014 suppotys the Buffer Pool Extension feature?

Answer: Enterprise and Standard edition

Explanation:

The Buffer Pool Extension feature is supported in Enterprise, standard, Evaluation , and Developer editions only.

Ref: Features Supported by the Editions of SQL Server 2014 - http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.120%29.aspx


» Discuss this question and answer on the forums

Featured Script

Get database size, used space, free space

Trevor Makoni from SQLServerCentral.com


EXEC master.[dbo].[proc_ShowDbSpaceUsage] @User = NULL;
GO

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2014 : Administration - SQL Server 2014

How to recover .mdf file database? - [b]I am having one of my database in SUSPECT mode. [/b] [i]1) I tried to Detach the database and than attach...

SQL 2014 AG with 2012 Replica - Hi all, Is it possible to have a 2014 Availability Group with a read-only secondary Replica in SQL 2012. The replica...


SQL Server 2014 : Development - SQL Server 2014

“LOGIN FAILED FOR USER ‘NT AUTHORITY\ANONYMOUS LOGON’” WHEN YOU RUN AN SSIS 2012 PACKAGE FROM A STORED PROCEDURE - i researched my issue and found the below link. I don't want to use a sql job. I'd rather now...

Is a SQL View the fastest way to manage multiple count fields, or does SQL 2014 have something better ? - I need to do lots of filtered counts, similar to the counting done on Ebay or Amazon. eg. Cars(34500), Car...


SQL Server 2012 : SQL 2012 - General

Upgrade OS to 2012 R2 from 2008 R2 - Hi, Thanks in advance. We have a SQL Server 2012 two node cluster on Windows 2008 R2. Now we were asked to...

Failover Solution SQL Server 2012 & VMware - Anyone have any document or step-by-step guide for Fail-over Cluster Setup/Solution : For SQL Server 2012 and VMware (Vsphere ) Thanks

SQL 2012 SP1 - configure log shipping and full backups - We have a SQL 2012 server instance that has log shipping set up to another SQL 2012 server to provide...

restore master from an earlier version - I have a process that restores all my backups on a centralized server for testing. I have recently upgraded this...

Question on included columns in non-clustered index - So... I am trying to tune a process that is running slowly. I analyzed the process using the Database Engine...

SSMS: where is Fixedsys font? - Just installed 2012 and wanted to set query text font to fixedsys but could not find it in drop-down. Is...

Maintenance Plan Clean Up Task Multiple subfolders - Hi Team, I was wondering if there was any way of extending the cleanup tasks ability to delve further down than...

Data Type conversion - Hello All, I have column in my table [Time] which has data type varchar(19). And the format is 02-16-2014-03:52:03. I...

Dynamic sql giving en error - Below dynamic sql giving me an error Incorrect syntax near '.'. Please help me for this issue. I am passing database name...

Always on HA On Windows Azure - Best Practice - I'm currently setting up a 2012 AoHA cluster in Windows Azure and looking for advice/recommendations around Lock Pages in Memory. Is...

Strange problem with RS 2008R2/2012 subscriptions - Hi, I am running two servers with reporting services, one 2008R2 and another 2012. After I create a subscription, the subscription...

Controller Action - Hi, I need to do some analysis. We have a database that track how much time it take to execute wcf service...

Need to upgrade SQL Server 2012 Standard edition to Enterprise edition. - Hi, we need to upgrade from a SQL Server 2012 Standard installation to SQL Server 2012 Enterprise installation. Is it Possibility to...

slow sql server machine - Hello, We have a sql server machine with many databases. These databases are big and a few of the tables have millions...

Unable to drop database user - Hi, We are unable to drop a database user with the following error "Msg 15284, Level 16, State 1, Line 1 The...

SSMS (manually) generated jobs run long, then fail. - Hello, I have a strange problem SQL, and I am spoiled by SQLs (usually) great logging and error reporting, but...

AlwaysOn: Client (Re)Connecting to wrong server after fail-over? - Hi, I hope someone can point me into the right direction. We have a AlwaysOn HADR setup with 2 servers, one...

How to View OR Retrieve all the tabs in SQL. - SQL query windows saves all the tabs in numerical sequence after you close each window. SO for example if you...

Reporting server error : An error has occurred during report processing - we are migrating our database and report server from SQL 2005 to SQL 2012 and we have move DB to...


SQL Server 2012 : SQL Server 2012 - T-SQL

T-SQL Calculation - Hi, I have a table where I need to calculate Trend based on Week Type and Unit . CREATE TABLE #REport ( TYPE VARCHAR(20), Unit...

On demand linked server creation in SP - I have a stored procedure that creates a linked server as one of the first lines of the procedure and...

Data Grouping on 2 levels but only returning conditional data - I think I am definitely thrashing and am not getting anywhere on something I think should be pretty simple to...

Need help with query rewrite - Hi all, We have a very expensive query that I am tring to rewrite, but the rewritten query (even though...


SQL Server 2008 : SQL Server 2008 - General

Database mail issue - Hi, trying to send test mail and i get this error message as shown below : The mail could not be...

How to do Spatial data in SSIS - Anyone have clue, how to do spatial data in SSIS 2008 r2

Differentail Backup Did not Pick up Last Full Backup - Hi, Whilst preparing to move a DB between ISP's last night, I choose to preform a full backup in the morning...

Need Query Help, Multiple Table, Multiple Key Comparisons - I'm working with a Daily Input Table and I'm keeping track of Changes in a 'Change Table'. For example, on Day...

Hi all need help on figureout the issue. - i have strange sssis package runs in sql server 2005 calling via sql agent file system, package use connection string...

Deleting records from a large table - I wanted to find out the fastest way to delete records from a large table. I currently have an index...

Regarding Maintenance Plans... - Hi All, We are Using SQL 2008, Now we are Planning to Create some Maintenance Plans for PD Server. Can you please suggest...

ANSI_WARNINGS ??? - Hello Everyone I hope that you are having a fabulous day. Is there a way to control ANSI_WARNINGS either database wide or...

Table partition and data compression - Hi Team, I have large table(60 million rows). I have partitioned that table year wise. The problem here is, there are hourly(40000...

Filestream Multiple Columns? - So I managed to create a database and a table with one filestream column. And I even managed to fill...

How to find who deleted a view - Hi, I need help to find out who deleted a view from SQL Server. I went to Database/reports/ standard reports/schema changes...

Issue in Linked server (sql server 2008 r2 to sybase) - Hello All, I have a problem in linked server, prompting below mentioned error when trying to create linked server between SQL...

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 = - Hi, I am trying to use sum function where a field falls into specific category, but so far no luck. I have: Wait_Status...

sp_who2 active report help - I was having 'Slowness' on App server. when I ran 'SP_who2 active' ON DATABASE server found these: spid: 12 status: background, login:...

Unable to perform query message - The user can put in the following parameters and I'm trying to create an sql statement that would work for...

Case statement with <> condition - I have query something like this ..i haven't posted here original quary [code="sql"] IF (@p_flag = 1) BEGIN SELECT .. ... FROM Test1 T1 INNER JOIN Test2 T2...

background spid causing blocking - hi, i have a sql 2008 r2 OLTP instance. I have noticed a background spid running for two days, status:...

XML is 17GB on disk... 4MB when cast as varchar(max) - Hi folks, I have a table that always contains only 1 row which has a column defined as XML data type....

Delete Vs Truncate difference on rollback - I guess anyone who has read even basic SQL will be aware of this classy question. And most of the...

Accessing Linked Server using PowerPivot - I am completely at a loss. Does anyone know the steps in connecting to a Linked server using Excel? Thanks

Excel 64 bit driver - Hi all, I am running the following query in sql server 2008 r2(64-bit), MS office 2007 excel file. SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

SSMS Trama (yes, this is really bugging me) - In Tools -> Options -> General, I have "At Startup" set to Open Empty Environment. This works wonderfully with 2k5,...


SQL Server 2008 : T-SQL (SS2K8)

Query to predict future job schedules from MSDB tables - I want to query my msdb job and jobschedule related tables to generate a list of runtimes for each of...

Cursor from variable - Hi all, I am using a cursor (i know - but this is actually something that is a procedural loop). So effectively i...

trigger to call a program to write a text file onto a folder in the server - Hi to all I have created a trigger to call a program that is written by our program. The program is...

T-SQL vs SQL differences - This is a relatively pedantic but necessary question as I have seen differing explanations on the subject. If I say I...

comparison in the merge statement about null values - I use the merge statement in a sproc to insert, update and delete records from a staging table to a...

xp_cmdshell exec ssis package in 32bit mode - I have a package set to run in 32bit mode on a 64bit machine, and I need to put it...


SQL Server 2008 : Working with Oracle

Weird error when selecting from view. - I'll start this off by saying that this has worked for months, and just started failing with no changes on...


SQL Server 2008 : SQL Server Newbies

Slow self join - I have a stored procedure which updates a table with the code below. It is rather slow (table with 360,000 rows)....


SQL Server 2008 : Security (SS2K8)

Connecting to SQL from MS Access - Our company has a bunch of legacy Access databases. 99% of what they do is connect to SQL Server, but...


SQL Server 2008 : SQL Server 2008 High Availability

Collation error on Transactional Replication - I am getting an error on a replication subscriber that had previously been working fine. This is the error message: [code="other"]Command...

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...


SQL Server 2008 : SQL Server 2008 Administration

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...

Linked Server from SQL Server 2008R2 to SQL Server 2012 - Hello folks Is it possible to create linked servers from SQL Server 2008R2 to SQL Server 2012? I tried from SQL...


SQL Server 2008 : SQL Server 2008 Performance Tuning

How am I getting Network_IO wait - If I am doing a select * from <local table>, then how am I getting a wait type of "Async_Network_IO"?


Cloud Computing : SQL Azure - Administration

Second instance on SQL Server Virtual Machine. How??? - Does anybody know how to install a second instance of SQL Server on an Azure SQL Server virtual machine? By default...


SQL Server 2005 : Administering

trigger to audit - Hi, I need to create triggers to audit some of my tables. I want that all changes made to this tables that...

correpted mdf file - HI I have a old backup from my corrupted mdf file but the ldf is OK. Can I restore the...

msdb repair - have a SQL Server 2000 msdb marked as "(Suspect)". It is in a test server that is mirrored from a...


SQL Server 2005 : Business Intelligence

SSIS 2008 - Question Marks in Filemask don't seem to work in ForEach - I have a folder with 2 types of files: 1) ABC_[i]yyyymmddhhmmss[/i].csv 2) ABC_Daily_Report_[i]yyyymmdd[/i].csv So, I set my FileSpec in my ForEach...

error executing ssis from sql agent - i have strange sssis package runs in sql server 2005 calling via sql agent file system, package use connection string...

Fixing Error: 2601 - Hi, I am getting this error when I am trying to update a column from a table which has a unique...


SQL Server 2005 : CLR Integration and Programming.

SQL 2008 CLR Assembly with Permission Set Unsafe - Hi, I had to convert huge volumes with datetime fields (given timezone info) to UTC. Since Sql does not have a...


SQL Server 2005 : Data Corruption

Corrupt DB -repair or restore - I have a dept who would prefer I repair instead of restore else they'll lose 4 hours of work: DBCC CHECKDB...


SQL Server 2005 : SQL Server 2005 General Discussion

ObjectType Reference from Default Trace - Hi there! I'm querying the default trace to get some audit info on some DB objects. (The variable @Trace contains the...


SQL Server 2005 : SQL Server 2005 Security

Reassigning the ownership of db_owner - We're recently purchased some new software, which requires its own SQL Server database. Working with the vendor they also needed...


SQL Server 2005 : SS2K5 Replication

MSSQL Server, error number: 2601 - I setup transaction replication between sql 2000 (Publisher and local distributor) and sql 2005 (Subscriber). The db replication was running fine...


SQL Server 2005 : SQL Server 2005 Integration Services

(SSIS 2012) - XML Config Files - Dev vs Production Environment Question - I am developing a SSIS 2012 package that basically works with a bunch of incoming Excel spreadsheets and does ETL...

Connection String With Data Source = localhost - I was updating a package today and noticed that the ssis package has an SSIS variable holding the connection string...


SQL Server 2005 : T-SQL (SS2K5)

Nesting xml - Hello, I am working on xml from SS2k12 results. I can get it to work with for xml auto; elements but...


Reporting Services : Reporting Services

ssrs 2008 r2 execute with temp table - In an SSRS 2008 r2 report, the code currently obtains the results from the stored procedure and places the results...

ssrs pass multivalue parameter values to stored procedure - In an SSRS 2008 r2 report, I am currently calling a stored procedure called spRoom. I obtain the results of...

Email Report to list of people that are defined by the report ??? - Hi is there a way to email a report to the people who are on the report For example I run a...

Table two Column - Hello I have a table that gives me information, it is for example in column 3 appears OK the values...


Reporting Services : Reporting Services 2008/R2 Administration

SSMS Fails to connect to Reporting Services 2008 R2 Instance (local) - Hi SQL Server reporting is all working fine (Report Manager & SSRCM etc) with the exception of trying to connect to the...


Reporting Services : Reporting Services 2008 Development

Need how to write the Expression for below matter - Hello, I have a scenario in SSRS report where I have 2 datasets First dataset contains systemid,system name and second dataset...

Split column rows - I have a column that has two row values, "Big" and "Small." Is there a way to make two columns...


Data Warehousing : Integration Services

Create Table Excel Destination in SSIS - Hi Everyone. I have the following SQL Data types: 1. NVARCHAR(255) 2. INT 3. NUMERIC (38,2) Can someone please tell me what the above...

Object is not an ADODB.RecordSet or an ADODB.Record - Hi I need a help to resolve the below error [Script Component [1]] Error: System.ArgumentException: Object is not an ADODB.RecordSet or...

SSIS - REST SPI - Parameters - Hi Gurus, I'm trying to implement data passed from SQL database to REST API using SSIS. Background: ------------ The REST API takes 3 parameters...

You need to specifiy the full path to a SSIS deployment manifest file - Before you read any further, this is more of an answer not a question as such, I just wanted to...


Database Design : Design Ideas and Questions

Table Design - Hi, I'm a newbie in database design, hope you guys can help me with the following scenario. Let's say, I have 5...

Audit approach for performance tunning - we do have requirement of tracking insert,update and delete action of tables with tracking userid. two approach is there. 1) [b]creating single...


SQLServerCentral.com : Anything that is NOT about SQL!

Sharepoint Calendar - Hello, Does anyone here use Sharepoint calendar? I am interested in knowing if it is possible to integrate data from 3rd party...

Using Dual Monitors vs Single Large Monitor - What is your preference dual monitors, a single large monitor using snap or neither? I currently use two 24 inch...

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...


SQLServerCentral.com : Articles Requested

Poor Man (dev) Version Control - There is a way to create a version control within the database without the need of third party tools. It...

Permissions in a database - There are scripts for this, but I would like a short tutorial piece that shows how to query for all...


SQL Server 7,2000 : Administration

Corrupted MDF File - Does anybody know if there is a way to recover the data from a corrupted MDF file? One disk that cotains...


SQL Server 7,2000 : General

*** HUGE SQL Server Problem *** =( - My SQL Server 2000 keeps going into "single user" mode. I have to manually go on the server to fix...

This email has been sent to {user_email}. 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 ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com