Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Restore Rss

   Items 1 to 8 of 8   
 

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,461 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 | 247 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,087 reads

Restore

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

Backup/Restore

By free mascot 2014/02/21 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,111 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 / restore
Rating: |  Discuss |   Briefcase | 2,260 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 / restore
Rating: |  Discuss |   Briefcase | 1,243 reads
   Items 1 to 8 of 8   
 
Tags
backup / restore (2)    
backup (1)    
disaster recovery (dr) (1)    
editorial (1)    
extended events (1)    
friday poll (1)    
piecemeal (1)    
read only (1)    
recent backups (1)    
striped backups (1)