Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Backup / Restore Rss

   Items 1 to 20 of 58    Older >>
 

SQL Server Database Backup and Restore with Windows Azure Blob Storage Cloud Services using T-SQL Commands

SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation?   Read more...
By Additional Articles 2013/12/09 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,624 reads

Delete old backup

Delete old backup files on a prespecified folder.   Read more...
By Matimba Maluleke 2012/07/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,207 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 2011/12/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,735 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,199 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,154 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2011/05/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,715 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,154 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2011/05/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,715 reads

Restores

By Steve Jones 2008/12/16 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 3,751 reads

Auto generate SQL Server restore script from backup files in a directory

One of the ongoing challenges of a DBA is to backup and restore databases. Backups are done on an automated schedule, but restores can take on many different versions, you may need to restore a production database, restore a development or test database or just create another copy of the database somewhere else. There are several ways of automating the restore process and creating a script, but this approach shows a way this can be done by just reading the contents of a directory for the backup files that exist.  Read more...
By Additional Articles 2008/09/29 | Source: MSSQLTips.com | Category: backup / restore
Rating:  Rate this |   Briefcase | 4,395 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 2011/12/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,735 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,199 reads

Fix Users

By pamarant 2007/04/27 | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,271 reads
   Items 1 to 20 of 58    Older >>
 
Tags
maintenance and management (29)    
miscellaneous (28)    
sqlinsider scripts (9)    
lock and connection management (7)    
sql server 7 (6)    
administration (5)    
indexing (5)    
replication (5)    
configuring (3)    
dts (3)    
data warehousing (2)    
installation (2)    
mail (2)    
restore (2)    
security (2)    
stored procedures (2)    
triggers (2)    
user defined function (udf) (2)    
advanced querying (1)    
azure (1)    
distributed queries (1)    
english query (1)    
filegroups (1)    
monitoring (1)    
openxml (1)    
performance tuning (1)    
programming (1)    
sql-dmo (1)    
strategies (1)    
updategrams (1)    
utility (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)