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

Content with tag Backup Rss

   Items 1 to 20 of 135    Older >>

Script to Run DBCC CheckDB on Alternate SQL Server to Reduce Load on Primary Server

In this tip we look at some scripts you can use to automate running your DBCC CheckDBs on an alternate SQL Server instance.  Read more...
By 2019/02/15 | Source: MSSQLTips.com | Category: dbcc checkdb
Rating:  Rate this |   Briefcase | 2,132 reads

Native SQL Backups for Amazon RDS Databases

Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.  Read more...
By Bill Brightman 2018/12/13 | Source: SQLServerCentral.com | Category: amazon
Rating: |  Discuss |   Briefcase | 336 reads

Backup to Recovery

By Steve Jones 2018/11/08 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 781 reads

Back Yourself Up

Ever thought about yourself as a resource that should be backed up to minimize your loss?  Read more...
By Hakim Ali 2018/09/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 57 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,929 reads

Corrupted Backups

By Steve Jones 2018/05/21 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 846 reads

Do you check your backups?

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.  Read more...
By Michael Higgins 2018/04/19 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 896 reads

Script - All Jobs (powershell/SMO)

Script powershell/SMO que gera os scripts de DROP/CREATE para cada JOB existente na instância  Read more...
Rating: |  Discuss |   Briefcase | 308 reads

How to Back Up SQL Server to Azure Blob Storage

When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,368 reads

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,371 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,302 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,830 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 | 398 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,673 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,889 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 | 289 reads

Saving Master Keys

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

Why PolyBase Matters

An alternative approach to disaster recovery and backup strategies using PolyBase.   Read more...
By Alain Dormehl 2017/08/25 (first published: 2015/08/10) | Source: SQLServerCentral.com | Category: aps
Rating: |  Discuss |   Briefcase | 6,974 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 | 4,304 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 | 916 reads
   Items 1 to 20 of 135    Older >>
restore (21)    
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)    
amazon (2)    
aps (2)    
aws (2)    
data (2)    
dba skills (2)    
dbcc checkdb (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)    
analysis services (ssas) (1)    
automatic (1)    
automation (1)    
availability (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)    
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)    
rds (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)