Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag backup / recovery Rss

   Items 1 to 20 of 59    Older >>
 

The Girl with the Backup Tattoo

The DBA Team are back, ready to save another DBA. In this episode, a rogue DBA sabotages the backups, can Robyn Page, Steve Jones, Grant Fritchey, and Phil Factor find the solution? Save the backups...save the business.   Read more...
By Additional Articles 2014/04/02 | Source: Red-Gate | Category: backup / recovery
Rating:  Rate this |   Briefcase | 3,766 reads

Script to Get the Backup History

Script to get the database backup history on SQL Server 2000/2005/2008  Read more...
By sathish siva 2014/03/14 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 872 reads

Disaster Recovery and the Big Data Application

Ask database administrators how they implement disaster recovery in their big data environments and you'll get two typical responses: DR plans are not necessary and backups take up a lot of space. Despite this reasoning, a disaster recovery plan for your big data implementation may be essential for your company's future.  Read more...
By Additional Articles 2014/02/04 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 3,489 reads

Accidently Kicking a Database into the Restoring State

I learn new things all the time. This was one that actually stunned me. Huge props to Gail Shaw for...  Read more...
By Steve Jones 2013/12/11 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,400 reads

Database Backup and Recovery in the Age of Big Data

Big data is the latest craze. Hardware and software vendors have overwhelmed IT departments with high-speed analytical software, proprietary high-performance hardware, and columnar-based data stores promising quick access and lightning-fast answers to ad hoc analytical queries. Forgotten in this blast of technology are the database administrators' most important responsibilities: backup and recovery.   Read more...
By Additional Articles 2013/10/01 | Source: Database Journal | Category: big data
Rating:  Rate this |   Briefcase | 3,300 reads

10 Myths about Backups in SQL Server

Let's dispel a few myths about backups in SQL Server.  Read more...
By Shashank Srivastava 2013/08/08 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 5,380 reads

SQLServerCentral Webinar #24: Prepare for When Disaster Strikes

Steve Jones presents some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.   Read more...
By Steve Jones 2013/07/29 | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

Roll Logs – Backup Recovery

Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....  Read more...
By SteveHood79 2013/05/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,003 reads

Attach Database with Missing NDF File

I wonder if you’ve had the situation that I had before where you have to attach a database with one...  Read more...
By john_wong_ca 2013/05/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,092 reads

Get Database Backup Details on SQL Server

DB Backup status Details   Read more...
By sathish siva 2013/04/18 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 1,353 reads

The Backup Process

Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.  Read more...
By Steve Jones 2013/03/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 158 reads

A Month of PowerShell – Day 21 (Backups)

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...
By Wayne Sheffield 2013/02/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,444 reads

Backing Up SQL Server Databases Participating In Availability Groups

So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations? Check out this tip to learn more.  Read more...
By Additional Articles 2013/02/25 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,246 reads

Is your LOG backed up?

You have been doing a fantastic job of late.  You have all of your databases being backed up on a...  Read more...
By Jason Brimhall 2013/02/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 528 reads

Beating Backup Corruption

The most critical task for all DBAs is to have a Backup and Recovery strategy that ensures, every day, that in the event of a disaster they can restore and recover any database, within acceptable limits for data loss and downtime. Even with all the required backups in place, it's easy to miss subtle failings in the overall plan that can, and eventually will, defeat your recovery plans.   Read more...
By Additional Articles 2013/01/28 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: (not yet rated)  Rate this |   Briefcase | 2,167 reads

Developing a SQL Server Backup Strategy

Developing a backup procedure that makes sure you can do restores should be one of your top priorities as a DBA. In this article Greg Larsen discusses some of the concepts to consider when developing, building and testing a backup strategy.  Read more...
By Additional Articles 2013/01/14 | Source: Database Journal | Category: backup / recovery
Rating:  Rate this |   Briefcase | 3,016 reads

Where is my backup?

We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...  Read more...
By Kenneth Fisher 2012/12/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,057 reads

Test Your Restores

Part of an effective response to a disaster situation is practice and testing of your skills and procedures. Steve Jones reminds us this is important today.  Read more...
By Steve Jones 2012/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 113 reads

What’s in YOUR Recovery Plan?

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.  Read more...
By Craig Outcalt 2012/12/10 (first published: 2011/09/26) | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 5,097 reads

Backup All Databases

this script helps you to backup from all database except of sysDatabases  Read more...
Rating: |  Discuss |   Briefcase | 1,335 reads
   Items 1 to 20 of 59    Older >>
 
Tags
blogs (17)    
administration (8)    
disaster recovery (dr) (5)    
backup / restore (3)    
editorial (3)    
big data (2)    
sql server 2012 (2)    
webinar (2)    
7zip (1)    
alwayson (1)    
availability groups (1)    
backup (1)    
backup verification (1)    
backups (1)    
certificates (1)    
compression (1)    
corruption (1)    
database recovery advisor (1)    
dts (1)    
encryption (1)    
gzip (1)    
instant file initialization (1)    
log (1)    
log shipping (1)    
maintenance and management (1)    
powershell (1)    
red gate (1)    
red gate software (1)    
security (1)    
sql server 7 (1)    
sql server essentials (1)    
stored procedures (1)    
transactions (1)    
t-sql (1)    
zip (1)