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

Content with tag Backup Rss

   Items 1 to 20 of 118    Older >>

Has Your Database Been Backed up in the Last 24 Hours?

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up. This tip provides a couple of TSQL scripts that will identify the last backup of each database.  Read more...
By 2018/02/01 | Source: Database Journal | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 3,064 reads

Create Size Based Backups for SQL Server 2017

Microsoft has never documented how the database log works, such as its format, its logging mechanism/algorithm, etc. But SQL Server 2017 has introduced a few improvements in some DMVs that expose more details about the status of data and log changes, and we can use the new information to design a better backup strategy.  Read more...
By 2018/01/25 | Source: MSSQLTips.com | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 3,001 reads

How to Change the Default Backup Directory

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups. Overtime you might decide you want to change the default location for database backups. This tip shows you two different ways to change the default location for your database backups.  Read more...
By 2018/01/24 | Source: Database Journal | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 2,574 reads

Database maintenance progress

Often we need to know on which stage is a maintenance operation such as: backup, restore, check database. You can get this information using my script.  Read more...
By Evgeny Garaev 2018/01/17 | Source: SQLServerCentral.com | Category: database maintenance
Rating: |  Discuss |   Briefcase | 316 reads

How Much Data Has Changed Since Your Last Full Backup

Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.  Read more...
By Additional Articles 2017/12/08 | Source: Database Journal | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 3,375 reads

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,307 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 | 270 reads

Saving Master Keys

By Steve Jones 2017/09/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 887 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,992 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 | 828 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 | 308 reads

Protecting Encrypted Backups

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

Backup Encryption Options

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

A full and a diff

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

The default differential

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

The differential PoSh backup

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

The default PoSh backup

By Steve Jones 2017/01/24 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 870 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 | 303 reads
   Items 1 to 20 of 118    Older >>
restore (19)    
administration (12)    
powershell (11)    
backup and restore (8)    
availability group (ag) (4)    
azure (4)    
transaction log (4)    
t-sql (4)    
always on (3)    
sql server 2017 (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)    
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 maintenance (1)    
database master key (dmk) (1)    
dbcc (1)    
dbcc checkdb (1)    
delete old backup files (1)    
differential (1)    
disaster recovery (dr) (1)    
dmv (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 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)