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

Content with tag Restore Rss

   Items 1 to 20 of 75    Older >>
 

Restore script for Ola Hallengren backup

Create a restore script based on backup files in a directory  Read more...
By Joe O'Connor 2016/05/03 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 154 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 2016/04/07 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 2,310 reads

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 | 444 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 | 598 reads

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 | 238 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,094 reads

Check, Please

By Andy Warren 2015/12/03 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,379 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 | 649 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,183 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,650 reads

Who Truncated That Table and What Do I Do Now?

This article describes a way to identify the user who truncated the table & how you can recover the data.  Read more...
By Sujeet Singh 2015/02/20 (first published: 2014/06/05) | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 25,343 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,895 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

Scrubbing Personally Identifiable Information

Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.  Read more...
By Daniel Brown 2015/01/06 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 7,498 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 2016/04/07 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 2,310 reads

SQL Azure Point-in-Time Restore

Point-in-Time Restore is a new feature of the SQL Azure Service Tiers  Read more...
By Paul Hebhardt 2014/10/14 | Source: SQLServerCentral.com | Category: sql azure
Rating: |  Discuss |   Briefcase | 1,372 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,799 reads

Restore All Backups

This is a script to restore all databases from backups places in a folder.  Read more...
Rating: |  Discuss |   Briefcase | 1,463 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,231 reads

Restore Gene : Automating SQL Server Database Restores

Restore Gene is a simple 2-script framework, one PowerShell script and one SQL stored procedure, which will speed up the production of restore scripts for manual disaster recovery, as well help automate log shipping.   Read more...
By Paul Brewer 2014/08/14 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 5,064 reads
   Items 1 to 20 of 75    Older >>
 
Tags
backup (14)    
backup and restore (14)    
administration (9)    
powershell (3)    
disaster recovery (dr) (2)    
dynamic script (2)    
instance (2)    
linked server (2)    
log (2)    
migration (2)    
restore log (2)    
sql server 2005 (2)    
transactions (2)    
t-sql (2)    
agent job (1)    
automation (1)    
backup device (1)    
backupset (1)    
blogs (1)    
books (1)    
checkdb (1)    
checksum (1)    
connection properties (1)    
copy_only (1)    
database configuration (1)    
dbcc (1)    
dbcc checkdb (1)    
default database (1)    
defaults (1)    
editorial (1)    
extended events (1)    
friday poll (1)    
log file (1)    
log files (1)    
master database (1)    
move files (1)    
multiple backups (1)    
ola hallengren (1)    
optimization (1)    
orphaned users (1)    
piecemeal (1)    
pii (1)    
point-in-time (1)    
pointintimerecovery (1)    
rationalisation (1)    
read only (1)    
recent backups (1)    
redgate (1)    
report (1)    
restore headeronly (1)    
roles (1)    
script generator (1)    
scripts (1)    
security (1)    
service tiers (1)    
simple-talk series (1)    
sql agent (1)    
sql azure (1)    
sql backup pro (1)    
sql server 2008 (1)    
sql server 2012 (1)    
sql server 7 (1)    
striped backups (1)    
time (1)    
t-log (1)    
truncate (1)    
verify (1)    
with checksom (1)    
with move (1)