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

Content with tags Backup and restore, Restore Rss

   Items 1 to 17 of 17   
 

Restoring the SQL Server Master Database Even Without a Backup

Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save yourself (mostly) should you ever find yourself with no viable master database and no good backup.  Read more...
By Additional Articles 2014/07/24 | Source: MSSQLTips.com | Category: restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,500 reads

Simplified Restores with SQL Server 2012 Recovery Advisor

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.  Read more...
By Jonathan Kehayias 2012/06/27 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,787 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,570 reads

SQL DBAdmin toolbox - Part 1: Restore single database

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...
By Infostar 2011/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,487 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2011/05/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,471 reads

T-Log Backup/Restore with Date & Time

Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.  Read more...
By S. Kusen 2010/12/29 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 1,346 reads

Restore All Backups

SCRIPT TO RESTORE BACKUP FOR ALL DATABASES, PLACED IN FOLDER CALLED ORIGIN_FOLDER, WITH THE INITIALS 'DBVF' AND EXTENSION '.BAK'   Read more...
By Disney Hammerschmidt 2010/06/30 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 2,758 reads

Restore Database from network location

When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.  Read more...
By Jano Petras 2010/05/11 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 2,781 reads

Backups

By Lynn Pettis 2010/04/30 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 3,400 reads

COPY_ONLY Backups

What are COPY_ONLY backups and why do we care? New author Charles Kincaid walks us through the basics of how you can create one of these backups.  Read more...
By Charles Kincaid 2009/09/30 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 9,485 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2011/05/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,471 reads

Restore Database from network location

When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.  Read more...
By Jano Petras 2010/05/11 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 2,781 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,280 reads

When is a Backup Considered Successful?

What makes a successful backup? New author Steven Bouffard talks about some things you might want to consider when evaluating if your backup process is considered a success.  Read more...
By Steven Bouffard 2009/06/08 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 7,215 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

Backup And Restore Remain Time

Script to found out how much time before Restore or Backup Process remain  Read more...
Rating: |  Discuss |   Briefcase | 1,044 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,570 reads
   Items 1 to 17 of 17   
 
Tags
administration (2)    
backup (2)    
t-sql (2)    
copy_only (1)    
log (1)    
master database (1)    
recent backups (1)    
sql server 2008 (1)    
sql server 2012 (1)    
sql server 7 (1)    
transactions (1)