Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Backup Rss

   Items 1 to 20 of 78    Older >>
 

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 | 441 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 | 596 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,400 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,715 reads

Restore

By Sergey Gigoyan 2015/09/30 | Category: backup-restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,800 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,206 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,184 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 | 648 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 | 532 reads

Copy Backup Files to Remote Shared Location & 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 2015/06/18 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,284 reads

Backup All User Databases

Backup all user databases on a SQL Server instance.  Read more...
By Greg Roberts 2015/06/15 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 889 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2015/06/05 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,042 reads

The MidnightDBAs release Minion Backup

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup. We created Minion Backup (or MB, for short) to be the most flexible, feature-rich backup solution possible.  Read more...
By Press Release 2015/06/01 | Source: SQLServerCentral.com | Category: minionware
Rating: |  Discuss |   Briefcase | 1,426 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2015/05/13 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 2,519 reads

DBA Skills: Striped Backup Video

Watch this short video on creating a striped backup for your database.  Read more...
By Steve Jones 2015/02/18 | Source: SQLServerCentral.com | Category: dba skills
Rating: |  Discuss |   Briefcase | 531 reads

DBA Skills - Creating a Striped Backup

Learn how to create a striped backup in this short piece.  Read more...
By Steve Jones 2015/02/18 | Source: SQLServerCentral.com | Category: dba skills
Rating: |  Discuss |   Briefcase | 567 reads

Script to remove Backup Files except Recent One for Same Day

This script is useful to remove SQL backup files except latest one for same day from Backup Path.  Read more...
By Ajay Dwivedi 2015/01/26 | Source: SQLServerCentral.com | Category: filter backup
Rating: (not yet rated) |  Discuss |   Briefcase | 980 reads

Copy Latest Backups from Backup Path

This script is useful to copying latest backup files from job Backup path during Instance/Database Migration  Read more...
By Ajay Dwivedi 2015/01/21 | Source: SQLServerCentral.com | Category: latest backup
Rating: (not yet rated) |  Discuss |   Briefcase | 784 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 272 reads

Upload Backup Files to Amazon S3

This script will upload the latest backup files to an AWS S3 bucket  Read more...
By Alex Marsh 2014/11/14 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 586 reads
   Items 1 to 20 of 78    Older >>
 
Tags
backup (65)    
restore (14)    
administration (8)    
backup and restore (7)    
powershell (4)    
transaction log (3)    
t-sql (3)    
dba skills (2)    
instance (2)    
linked server (2)    
sql server 2008 (2)    
sql server 2014 (2)    
striped backups (2)    
transactions (2)    
agent job (1)    
amazon (1)    
analysis services (ssas) (1)    
automatic (1)    
automation (1)    
aws (1)    
azure (1)    
backup history (1)    
backup verification (1)    
backup-restore (1)    
backups (1)    
backupset (1)    
books (1)    
change password (1)    
change sa (1)    
checkdb (1)    
compress (1)    
copy backup (1)    
daily dba task (1)    
database (1)    
dbcc (1)    
delete old backup files (1)    
differential (1)    
disaster recovery (dr) (1)    
dynamic (1)    
dynamic script to copy backup (1)    
editorial (1)    
email (1)    
file operations (1)    
files (1)    
filter backup (1)    
friday poll (1)    
full (1)    
full backup status (1)    
full drive (1)    
index dm_exec_requests (1)    
indexing (1)    
integers (1)    
integrity (1)    
integrity check (1)    
job (1)    
latest backup (1)    
log (1)    
migration (1)    
minionware (1)    
move (1)    
move files (1)    
netapp (1)    
overwrite (1)    
password (1)    
rationalisation (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)    
scripts (1)    
simple-talk series (1)    
smo (1)    
snapmanager for sql (1)    
sql agent (1)    
sql powershell (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 7 (1)    
sqlcmd (1)    
statistics (1)    
survey (1)    
time (1)    
verify (1)    
video (1)    
windows azure (1)