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

Content with tag Backup Rss

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

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, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/11/08 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 45,462 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 | 87 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,435 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,663 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 | 544 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 | 666 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, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/11/08 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 45,462 reads

What does Copy-only Backup do?

By Ben Kubicek 2016/06/28 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 1,310 reads

Verify SQL Backups With SQL Powershell

With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.   Read more...
By Geoff Ruble 2016/04/25 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 2,129 reads

Delete Backups Older than N Days

SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED, IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION.   Read more...
By S M 2016/03/31 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 2,702 reads

Part 2 -- Restore a database to another instance...

This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.  Read more...
By Haden Kingsland (theflyingdba) 2016/03/15 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 525 reads

Part 1 -- Restore a database to another instance...

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.  Read more...
By Haden Kingsland (theflyingdba) 2016/03/14 | Source: SQLServerCentral.com | Category: scripts
Rating: |  Discuss |   Briefcase | 698 reads

Avoid Transaction Logs volume from filling

Script for preventing the volumes of the transaction logs from filling.  Read more...
By Daniel Marques 2016/01/27 | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |   Briefcase | 3,438 reads

Daily Database Backup Scripts

Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.  Read more...
By Greg Bernstein 2015/12/17 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 4,755 reads

Restore

By Sergey Gigoyan 2015/09/30 | Category: backup-restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,867 reads

Check SQL DB backups details remotely by PowerShell

Check SQL DB backups details remotely by PowerShell  Read more...
By Raushan 2015/08/11 | Source: SQLServerCentral.com | Category: sql powershell
Rating: |  Discuss |   Briefcase | 1,291 reads

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.  Read more...
By Nicholas Williams 2015/07/23 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,233 reads

Recent Restore History

This script simply returns the most recent restore information about databases for a server. Returns the destination database name, the device used to perform the restore and the restore date.  Read more...
By Nicholas Williams 2015/07/15 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 667 reads

Delete Backup Files From Default Backup Location

IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.  Read more...
By S M 2015/07/02 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 555 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,663 reads
<< Newer    Items 21 to 40 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)