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

Content with tags Backup, PowerShell Rss

   Items 1 to 11 of 11   
 

Backup SQL Server Databases in Parallel with PowerShell

I have a need to decrease the time my SQL Server database backups are taking to run. I thought about trying to run multiple backups at the same time to see if that would work. I could have created multiple SQL Server Agent Jobs to run at the same time, but I wanted a more dynamic way to handle this, so I created a PowerShell script that allows processes to run in parallel.  Read more...
By Additional Articles 2017/10/30 | Source: MSSQLTips.com | Category: parallel processing
Rating: (not yet rated)  Rate this |   Briefcase | 3,548 reads

A full and a diff

By Steve Jones 2017/03/16 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 899 reads

The default differential

By Steve Jones 2017/02/22 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 906 reads

The differential PoSh backup

By Steve Jones 2017/02/07 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 775 reads

The default PoSh backup

By Steve Jones 2017/01/24 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 871 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,457 reads

Powershell Script for regular DBA activities

This script will perfrom following tasks : 1. BackUp DB 2. Restore DB from BackUp File 3. Restore DB from DB 4. Create a new DB from Existing Db It takes care of all the possible failures during these operations, while done manually.   Read more...
By Mayank Shukla 2017/01/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,322 reads

PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.  Read more...
By Mashrur Shuvo 2014/09/02 | Source: SQLServerCentral.com | Category: daily dba task
Rating: |  Discuss |   Briefcase | 1,495 reads

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.   Read more...
By Daniel Calbimonte 2012/08/14 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 6,190 reads

Using PowerShell for SQL Server Transaction Log Backups

How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.  Read more...
By Additional Articles 2011/10/25 | Source: MSSQLCity.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,742 reads

Using PowerShell for SQL Server Database Backups

If you're starting to learn PowerShell and want to see how you can use it for common DBA tasks, this tip will show you how to create a basic PowerShell script to backup all your user databases.  Read more...
By Additional Articles 2011/09/30 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,467 reads
   Items 1 to 11 of 11   
 
Tags
administration (1)    
daily dba task (1)    
parallel processing (1)    
restore (1)    
smo (1)    
sqlcmd (1)    
transaction log (1)