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

Content with tags Blogs, Backup / Restore Rss

   Items 1 to 12 of 12   
 

Restore SQL Server databases remotely using my SQL CLR

Has anyone ever though of pushing a SQL Server database backup out remotely? (SQL Native andor RedGate Backups) My idea...  Read more...
By andrew.fenna 2013/08/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,303 reads

Restoring Azure SQL Database to a Local Server

In last week’s post, I talked about the steps required to backup a Azure SQL Database.  That post leaves us...  Read more...
By StrateSQL 2013/04/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,231 reads

Quick Tip – Speed a Slow Restore from the Transaction Log

Here’s a quick tip for you: During some restore operations on Microsoft SQL Server, the transaction log redo step might be...  Read more...
By 2012/11/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,322 reads

RYO Maintenance Plan – Database Backups, Part 3

4 out of 5 DBAs agree I’ve covered creating my backup directories and the actual backup of the database(s). The last...  Read more...
By 2012/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,247 reads

Estimated Completion Time for Backups and Restores

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...  Read more...
By 2012/01/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,222 reads

Change SQL Startup Parameters with PowerShell

Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...  Read more...
By eric.humphrey 2011/04/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,284 reads

A Full Backup can Impact a Log Backup–MCM Prep

In the early days of SQL Server you could not run a log backup while a full backup was running....  Read more...
By Steve Jones 2011/02/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,695 reads

Performing SSAS Database Backup

In this post, we will look the steps to backup a SQL Server Analysis Server Database. After logging to the Analysis Services, in...  Read more...
By Bru Medishetty 2010/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,313 reads

Perform a Striped Backup

The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...  Read more...
By Bru Medishetty 2009/12/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,831 reads

Decompressing on Compression in SQL Server 2008....

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...  Read more...
By Robert Pearl 2009/09/02 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,041 reads

I Need a Backup and I Need It Now

Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...  Read more...
By Robert Davis 2009/04/29 | Source: SQLServerCentral.com | Category: backup / restore
Rating:  Rate this |   Briefcase | 3,687 reads

Why Tape is Good

I write an editorial about why I thought tape still had a place in backups . There were some interesting responses that said disk works well for them and they wouldn’t go back to tape. I used to think the density was a big deal, along with cost, but maybe...  Read more...
By Steve Jones 2009/04/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,228 reads
   Items 1 to 12 of 12   
 
Tags
administration (1)    
analysis services (ssas) (1)    
azure (1)    
compression (1)    
data (1)    
powershell (1)    
sql server 2008 (1)    
sqlclr (1)    
striped backups (1)