Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
Backup / Restore
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...
By
Venkatesh Krishnamurthy
2009/12/31
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
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
Restore 2000 DB to 2005
Read more...
By
David A. Long
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
3,673 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
|
7,185 reads
Get Record Count for each table in a database.
Read more...
By
Hari Sharma
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,015 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
check full recovery dbs have tran log backups
Read more...
By
paul_richardson
2007/10/31
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
1,282 reads
usp_KillConnections
Read more...
By
Antonio Pedrosa
0001/01/01
|
Category:
lock and connection management
Rating:
|
Discuss
|
Briefcase
|
8,786 reads
Shrink databases
Read more...
By
Vinay Kumar
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
557 reads
Creating BCH Files for Veritas Direct to Tape
Read more...
By
john monroe
2007/10/02
|
Category:
backup / restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
336 reads
Backup SQL Server Database with Move/Copy File
Read more...
By
Marvin D
2007/09/14
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
17,672 reads
Items 1 to 20 of 169
Next 20 >>
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use