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

Content with tag Backup Rss

   Items 1 to 20 of 113    Older >>
 

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 | 2,996 reads

Azure DWH part 19: Backup and Restore SSAS

In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.  Read more...
By Daniel Calbimonte 2017/10/23 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 241 reads

Saving Master Keys

By Steve Jones 2017/09/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 847 reads

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,859 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 | 768 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 | 300 reads

Protecting Encrypted Backups

By Steve Jones 2017/06/23 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 762 reads

Backup Encryption Options

By Steve Jones 2017/06/05 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 889 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 | 453 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 | 895 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

Backup databases in an Availability Group

Use this script to backup databases based on their role in an availability group  Read more...
By Kevin Burgess 2017/01/12 | Source: SQLServerCentral.com | Category: availability
Rating: (not yet rated) |  Discuss |   Briefcase | 285 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,216 reads

AG Backup Priority

By Steve Jones 2016/12/19 | Category: high availability (ha)
Rating: (not yet rated) |  Discuss |   Briefcase | 857 reads

AG Backup Preference

By Steve Jones 2016/12/08 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 919 reads

Taking backup of the databases to the Active server alone

If you have Always On and need to stop running database backups to the stand by server, use the script.  Read more...
By S M 2016/11/21 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 193 reads
   Items 1 to 20 of 113    Older >>
 
Tags
restore (18)    
administration (12)    
powershell (11)    
backup and restore (8)    
azure (4)    
transaction log (4)    
t-sql (4)    
always on (3)    
availability groups (ag) (3)    
agent jobs (2)    
backup verification (2)    
data (2)    
dba skills (2)    
editorial (2)    
encryption (2)    
friday poll (2)    
high availability (ha) (2)    
instance (2)    
linked server (2)    
sql powershell (2)    
sql server 2008 (2)    
sql server 2014 (2)    
striped backups (2)    
transactions (2)    
warehouse (2)    
alert (1)    
amazon (1)    
analysis services (ssas) (1)    
automatic (1)    
automation (1)    
availability (1)    
availability groups (1)    
aws (1)    
azure sql data warehouse (asdw) (1)    
azure sql database (1)    
azure storage (1)    
backup history (1)    
backup-restore (1)    
backups (1)    
backupset (1)    
books (1)    
change password (1)    
change sa (1)    
checkdb (1)    
compress (1)    
copy backup (1)    
dac (1)    
daily dba task (1)    
data protection (1)    
data tier application (1)    
database (1)    
database copy (1)    
database master key (dmk) (1)    
dbcc (1)    
delete old backup files (1)    
differential (1)    
disaster recovery (dr) (1)    
dynamic (1)    
dynamic script to copy backup (1)    
email (1)    
file operations (1)    
filegroup (1)    
files (1)    
filter backup (1)    
full (1)    
full backup status (1)    
full drive (1)    
groups (1)    
high availability (1)    
index dm_exec_requests (1)    
indexing (1)    
integers (1)    
integrity (1)    
integrity check (1)    
join elimination optimization (1)    
latest backup (1)    
log (1)    
migration (1)    
minionware (1)    
monitor server (1)    
move (1)    
move files (1)    
multiple backups (1)    
netapp (1)    
netbackup (1)    
overwrite (1)    
parallel processing (1)    
password (1)    
performance (1)    
privileges (1)    
rationalisation (1)    
recover (1)    
recovery model (1)    
redgate software (1)    
remote copy. (1)    
remove old backup from path (1)    
replication (1)    
report (1)    
restore headeronly (1)    
retention. (1)    
s3 (1)    
sa (1)    
salesforce (1)    
san (1)    
script (1)    
scripts (1)    
simple-talk series (1)    
smo (1)    
snapmanager for sql (1)    
sql (1)    
sql agent (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 2016 (1)    
sql server 2017 (1)    
sql server 7 (1)    
sqlcmd (1)    
ssas (1)    
statistics (1)    
survey (1)    
time (1)    
verify (1)    
veritas netbackup (1)    
video (1)    
windows azure (1)    
write sql data using powershell (1)