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

Content with tags Administration, Restore Rss

   Items 1 to 9 of 9   
 

Script to configure Log File Size for Large DBs

Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files  Read more...
By Ajay Dwivedi 2015/12/15 | Source: SQLServerCentral.com | Category: database configuration
Rating: |  Discuss |   Briefcase | 1,123 reads

Automatic restore database to different server from backup file

if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command   Read more...
By David Zhou 2015/01/15 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,917 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 | 275 reads

Display All Errors Fired in a Restore Procedure

Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events  Read more...
By Brian Awe 2014/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 3,149 reads

Restore

By free mascot 2014/06/06 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,583 reads

Backup/Restore

By free mascot 2014/02/21 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,177 reads

Script to find latest backups for all databases

If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.  Read more...
By Roshan Joe Joseph 2009/07/01 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 2,275 reads

Generate CREATE DATABASE FOR ATTACH for all databases on server

I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.  Read more...
By Wesley Brown 2008/12/18 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 1,244 reads
   Items 1 to 9 of 9   
 
Tags
backup and restore (2)    
backup (1)    
database configuration (1)    
disaster recovery (dr) (1)    
dynamic script (1)    
editorial (1)    
extended events (1)    
friday poll (1)    
log files (1)    
migration (1)    
optimization (1)    
piecemeal (1)    
read only (1)    
recent backups (1)    
striped backups (1)