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

Content with tags powershell, Backup 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,004 reads

A full and a diff

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

The default differential

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

The differential PoSh backup

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

The default PoSh backup

By Steve Jones 2017/01/24 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 864 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,327 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,217 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,481 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,188 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,673 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,392 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)