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

Scripts with tag Restore Rss

Search for any content tagged restore

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 35    Older >>
 

Restore Redgate Transaction logs files via SQL

The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 12 reads

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,023 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 | 632 reads

Move DB roles

This script will script the role members for all roles on the database.  Read more...
By Shanjan Sapra 2015/03/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,176 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,867 reads

Generate RESTORE DATABASE Script without Using CMDSHELL

Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.  Read more...
By Ajay Dwivedi 2015/01/05 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 1,897 reads

Restore All Backups

This is a script to restore all databases from backups places in a folder.  Read more...
Rating: |  Discuss |   Briefcase | 1,452 reads

Generate Restore script for multiple databases

Restore script for moving databases from prod to dev with different path / logical name etc.  Read more...
By Taranjit Singh 2014/08/14 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,221 reads

Restore script genrator for moving dbs

usefull script for moving databases from one server to another  Read more...
By Anoop 2014/04/23 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 875 reads

DBCC,Backup, Verify and create Agent Job to restore

Script to Automatically Backup, Drop and create Agent Job to restore from that backup.  Read more...
By Rob Sewell 2014/03/25 | Source: SQLServerCentral.com | Category: rationalisation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,012 reads

Script to Restore Entire database from a directory

Script to restore the entire databases from the backup directory just by passing the backup directory.  Read more...
By sathish NS 2014/08/22 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 2,764 reads

Script to Get the Database Restore history

Script to get the Database restore history details including with the files by which the database is restored.  Read more...
By sathish NS 2014/03/17 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,062 reads

Restore Database with any number of Ndf files

Execute the code after passing database name on which you want to restore and the path where your backup file being located. e.g exec sp_restoredb N'mydatabase',N'D:\mydatabase.bak'   Read more...
By Sanjeev Kumar, DBA 2015/03/05 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,642 reads

Restore multiple db's to new server with new file locations

Script queries backupset & backupmediafamily tables to get latest backup file, then generates script to restore db using backup file and moves files to new locations.  Read more...
By Steven Webster 2013/09/10 | Source: SQLServerCentral.com | Category: backupset
Rating: |  Discuss |   Briefcase | 1,263 reads

Find Default Data and Log File Paths

A function to wrap Alex Aza's "find default paths" solution.   Read more...
By Will Spurgeon 2013/07/19 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 605 reads

Restore Script Generator

Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.  Read more...
By Jim Youmans 2013/06/18 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,766 reads

How Long Backups Will Take

When you are running a backup or a restore, this script gives you an estimate of completion time.  Read more...
By Miguel Quintana 2013/06/14 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,492 reads

Restore Latest Backup with Powershell

Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.  Read more...
By Luke Losli 2013/04/16 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 986 reads

Script to construct a restore/recovery script

Constructs a restore script for all databases on the server from backup history.  Read more...
By Paul Brewer 2012/11/12 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,144 reads

Restore database from a device containing multiple backups

Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.  Read more...
By Smitha Reddy 2012/01/04 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,753 reads
   Items 1 to 20 of 35    Older >>