SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Backup / Restore Rss

Search for any content tagged backup / restore

Add a script

   Items 1 to 20 of 169    Next 20 >>
 

Automated SQL Job to Backup Database(s)

Automate All Database Backups with this script. handle full, diff, and log backups.  Read more...
Rating: |  Discuss |  Briefcase | 1,056 reads

Backup Both Full and TLog Database Backup within a single Job

This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.  Read more...
By Nitin Gupta 2009/08/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 985 reads

Differential Backup Store Procedure for SQL Server 2000

The Store Procedure can be use for generating Differential Backup datewise in SQL Server 2000.  Read more...
By Swapnil Tawde 2009/07/14 | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated) |  Discuss |  Briefcase | 484 reads

SQL Server Database Backup Status

Lists the Databases and their Backups status in a neatly formatted HTML Email  Read more...
By Pratap Prabhu 2009/05/19 | Source: SQLServerCentral.com | Category: sp_send_dbmail
Rating: |  Discuss |  Briefcase | 1,277 reads

Automate Test Database Restoration

Automate test database restorations from your production system.  Read more...
By Mike Kober 2009/04/23 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 1,361 reads

Check Syntax on a Database

This script finds the first error on all Sprocs, Functions, Triggers and Views in a database. Works in SQL Server 2005 and 2008  Read more...
By Stephen Schaff 2009/04/21 | Source: SQLServerCentral.com | Category: syntax check
Rating: |  Discuss |  Briefcase | 666 reads

SQL 2005 Restore Script Generator

This script will generate a restore statement with supporting MOVE operations to a new directory structure.  Read more...
By Gordon-265412 2008/07/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 2,538 reads

SQL Server 2005 & 2008 - Backup, Integrity Check & Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 06 Dec 2009.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 24,380 reads

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin  Read more...
By David A. Long 2008/04/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 1,267 reads

Shrink all databases

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...
By Rafal S. 2008/03/17 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 2,282 reads

Restore Server/Database users/roles

restore server/database users and roles from another server when we are restoring databases to another server  Read more...
By Lester Policarpio 2007/12/26 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 1,554 reads

How to insert and update from remote linked server

Please read the how to use. unfortunately the orignal document i submitted was truncated :( and i dont have time to remember what i said  Read more...
By Chris Morton 2007/10/30 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |  Briefcase | 2,294 reads
   Items 1 to 20 of 169    Next 20 >>