SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag backup Rss

Search for any content tagged backup

   Items 1 to 20 of 37    Older >>
 

How to Read a Transaction Log Backup

The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.  Read more...
By Additional Articles 2017/08/17 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 3,765 reads

Filegroup Restoring and Join Elimination

This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.  Read more...
By Bogdan SAHLEAN 2017/08/10 | Source: SQLServerCentral.com | Category: filegroup
Rating: |  Discuss |   Briefcase | 717 reads

Configuring Backups Using Veritas Netbackup with AGs

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.   Read more...
By Kenneth Igiri 2017/07/18 | Source: SQLServerCentral.com | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 286 reads

Backups in Azure SQL Data Warehouse

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.  Read more...
By Daniel Calbimonte 2017/03/20 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 435 reads

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

Learn how easy the new SQLServer module makes backups of SQL Server databases.  Read more...
By Aaron Nelson 2017/01/12 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,288 reads

What's Your Backup Speed?

This week Steve Jones has a bit of a competition. Share with him how fast you can back up a 1TB database.  Read more...
By Steve Jones 2016/11/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 86 reads

Databases in Azure: Copy and Exports

Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.  Read more...
By Michael Morin 2016/07/19 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 664 reads

Verify SQL Backups With SQL Powershell

With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.   Read more...
By Geoff Ruble 2016/04/25 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 2,124 reads

Daily Database Backup Scripts

Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.  Read more...
By Greg Bernstein 2015/12/17 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 4,755 reads

The MidnightDBAs release Minion Backup

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup. We created Minion Backup (or MB, for short) to be the most flexible, feature-rich backup solution possible.  Read more...
By Press Release 2015/06/01 | Source: SQLServerCentral.com | Category: minionware
Rating: |  Discuss |   Briefcase | 1,451 reads

DBA Skills: Striped Backup Video

Watch this short video on creating a striped backup for your database.  Read more...
By Steve Jones 2015/02/18 | Source: SQLServerCentral.com | Category: dba skills
Rating: |  Discuss |   Briefcase | 668 reads

DBA Skills - Creating a Striped Backup

Learn how to create a striped backup in this short piece.  Read more...
By Steve Jones 2015/02/18 | Source: SQLServerCentral.com | Category: dba skills
Rating: |  Discuss |   Briefcase | 596 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 283 reads

Stop Relying on Cloud File Stores as a Backup Strategy

There is a growing assumption that Cloud file-storage services represent an ideal way of backing up files. It seems a compelling idea because it is so easy and seems secure. The truth is, as always, more complicated. There is more to any backup strategy than just cloud storage.  Read more...
By Additional Articles 2014/11/06 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 9,825 reads

Synchronize Salesforce with SQL Server using SSIS

Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.   Read more...
By Eric Madariaga 2014/09/30 | Source: SQLServerCentral.com | Category: integers
Rating: |  Discuss |   Briefcase | 4,770 reads

Verify SQL Backup Integrity

Perform automated database restores and check the integrity of your backup files  Read more...
By Willem Gossink 2014/08/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 4,317 reads

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.  Read more...
By Sujeet Singh 2014/04/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 5,715 reads

SQL Server Backup Crib Sheet

Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised for SQL Server 2014.  Read more...
By Additional Articles 2014/04/15 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 7,136 reads

Automating the Retrieval of SQL Backups from Windows Azure BLOB Storage

If your database server is in Azure, then it makes sense to do backups into Azure too. SQL Server 2014 supports backups to the cloud, and particularly well with Managed Backup. Once your backups are safely in an Azure BLOB, then what? Mike Wood takes up the story.  Read more...
By Additional Articles 2014/03/24 | Source: SimpleTalk | Category: windows azure
Rating:  Rate this |   Briefcase | 2,019 reads

Backup to the right location, by default

How do you configure where your database backups are created? Do you have problems updating all of your backup jobs if the backup location needs to change? See how you can make use of Windows settings and a few lines of simple TSQL to have total control over where you database backups are created.   Read more...
By Additional Articles 2014/01/30 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 3,234 reads
   Items 1 to 20 of 37    Older >>