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

Content with tag Backup Rss

<< Newer    Items 21 to 40 of 132    Older >>
 

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 | 476 reads

A full and a diff

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

The default differential

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

The differential PoSh backup

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

The default PoSh backup

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

AG Backup Priority

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

AG Backup Preference

By Steve Jones 2016/12/08 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 934 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 | 198 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.  Read more...
By Ola Hallengren 2018/06/04 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 45,795 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 | 92 reads

Reading Backup History Information for a Database

There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.  Read more...
By Additional Articles 2016/10/31 | Source: Database Journal | Category: backup
Rating:  Rate this |   Briefcase | 4,313 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2016/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,441 reads

Copy Backup Files to Remote Shared Location and Delete them periodically

If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.  Read more...
By S M 2016/10/18 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,668 reads

Find databases without backup

Find databases without backup and alert you by email with databases affected  Read more...
By Angel Gómez 2016/09/30 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |   Briefcase | 580 reads

Backup History for all databases

Return the 600 last days of backup history for all databases  Read more...
Rating: |  Discuss |   Briefcase | 487 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 | 726 reads
<< Newer    Items 21 to 40 of 132    Older >>
 
Tags
restore (20)    
administration (13)    
powershell (11)    
backup and restore (8)    
availability group (ag) (4)    
azure (4)    
transaction log (4)    
t-sql (4)    
always on (3)    
disaster recovery (dr) (3)    
editorial (3)    
high availability (ha) (3)    
sql server 2016 (3)    
sql server 2017 (3)    
agent jobs (2)    
aps (2)    
data (2)    
dba skills (2)    
encryption (2)    
friday poll (2)    
headeronly (2)    
instance (2)    
linked server (2)    
polybase (2)    
sql powershell (2)    
sql server 2008 (2)    
sql server 2014 (2)    
sql server parallel data warehouse (2)    
striped backups (2)    
transactions (2)    
warehouse (2)    
alert (1)    
amazon (1)    
analysis services (ssas) (1)    
automatic (1)    
automation (1)    
availability (1)    
aws (1)    
azure blob storage (1)    
azure sql data warehouse (asdw) (1)    
azure sql database (1)    
azure storage (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 maintenance (1)    
database master key (dmk) (1)    
dbcc (1)    
dbcc checkdb (1)    
delete old backup files (1)    
differential (1)    
dmv (1)    
dynamic (1)    
dynamic script to copy backup (1)    
email (1)    
enterprise solution (1)    
file operations (1)    
filegroup (1)    
files (1)    
filter backup (1)    
full (1)    
full backup status (1)    
full drive (1)    
groups (1)    
index dm_exec_requests (1)    
indexing (1)    
integers (1)    
integrity (1)    
integrity check (1)    
job (1)    
join elimination optimization (1)    
latest backup (1)    
life (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)    
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 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)