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

Content with tags Blogs, backup / recovery Rss

   Items 1 to 17 of 17   
 

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

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

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

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

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

Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few...  Read more...
By Jason Brimhall 2012/12/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,276 reads

Demystifying SQL Server Differential Database Backups

Odd Man Out SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood. Let’s...  Read more...
By Wesley Brown 2012/09/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,598 reads

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn’t Apply to Dropped Databases or Does It? 5 Second Rule Doesn't Apply to Dropped Databases or Does...  Read more...
By Robert Davis 2012/06/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,235 reads

Always restore with NORECOVERY

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option. It’s trivial to switch the database online. Not...  Read more...
By 2012/05/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,859 reads

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...  Read more...
By 2012/05/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,615 reads

Use Powershell script to verify backup files

Before restoring backup, we always verify the backup file first, and run the 3 command below: 1. RESTORE HEADERONLY     Returns a result...  Read more...
By 2012/05/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,909 reads

Backing up a Certificate

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....  Read more...
By 2012/03/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,416 reads

RYO Maintenance Plan – Enhancement Request

In response to my last post, I got a very interesting comment from Philip: “I would love to see a way...  Read more...
By 2012/02/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 841 reads

About those backups...

So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information...  Read more...
By 2012/01/30 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,177 reads

RYO Maintenance Plan – Database Backups

Remember kids... Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...  Read more...
By 2012/01/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,861 reads

Database Backups: Things You Need To Do Now

I want to say a few things about database backups that you need to know. Wait a minute, haven’t you written...  Read more...
By 2012/01/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,086 reads
   Items 1 to 17 of 17   
 
Tags
certificates (1)    
encryption (1)    
maintenance and management (1)    
powershell (1)