SQLServerCentral: Scripts tagged Backup / Restore

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 | 790 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 | 374 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 | 944 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,130 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 | 618 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,326 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 05 Sep 2009. Read more...

By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 22,098 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,157 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,163 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,444 reads

Restore 2000 DB to 2005

By David A. Long | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 3,494 reads

Automatically Restores All database ".BAK" Files

Restore Many Backup FIles Read more...

By Lester Policarpio 2007/11/08 | Source: SQLServerCentral.com | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 6,804 reads

Get Record Count for each table in a database.

By Hari Sharma | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 894 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,166 reads

check full recovery dbs have tran log backups

By paul_richardson 2007/10/31 | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 1,256 reads

usp_KillConnections

By Antonio Pedrosa 0001/01/01 | Category: Lock and Connection Management

Rating:

|

Discuss |

Briefcase | 8,727 reads

Shrink databases

By Terry Benedict | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 504 reads

Creating BCH Files for Veritas Direct to Tape

By john monroe 2007/10/02 | Category: Backup / Restore

Rating: (not yet rated) |

Discuss |

Briefcase | 319 reads

Backup SQL Server Database with Move/Copy File

By MD-170070 2007/09/14 | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 17,183 reads

Find The Database Recovery Model

By Oliver Wootton 2007/05/17 | Category: Backup / Restore

Rating:

|

Discuss |

Briefcase | 1,776 reads

Scripts with tag Backup / Restore

Add a script

Backup Both Full and TLog Database Backup within a single Job

Differential Backup Store Procedure for SQL Server 2000

SQL Server Database Backup Status

Automate Test Database Restoration

Check Syntax on a Database

SQL 2005 Restore Script Generator

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

Create_sp_help_revlogin_DB

Shrink all databases

Restore Server/Database users/roles

Restore 2000 DB to 2005

Automatically Restores All database ".BAK" Files

Get Record Count for each table in a database.

How to insert and update from remote linked server

check full recovery dbs have tran log backups

usp_KillConnections

Shrink databases

Creating BCH Files for Veritas Direct to Tape

Backup SQL Server Database with Move/Copy File

Find The Database Recovery Model

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

Backup SQL Server Database with Move/Copy File

Send SMS from a trigger

Scripts with tag Backup / Restore

Refine your search with one of the following additional tags (with number of items):