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

Content with tag Backup / Restore Rss

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

Maintenance and Management (87)     SQL Server 2005 (3)     Disaster Recovery (1)     powershell (1)    
Miscellaneous (51)     Transaction Log (3)     Editorial (1)     Product Reviews (1)    
T-SQL Aids (36)     Video (3)     Editorial - iPod (1)     Reviews (1)    
Lock and Connection Management (14)     Security (2)     Editorial - MP3 (1)     Scripts (1)    
SQLInsider Scripts (14)     SQL Server 2008 (2)     Editorial - WMV (1)     SMO (1)    
Replication (10)     T-SQL (2)     FILESTREAM (1)     sp_send_dbmail (1)    
Index Management (8)     Upgrade (2)     Integration Services (SSIS) (1)     SQL Server 7, 2000 (1)    
Data Warehousing (6)     Analysis Services (SSAS) (1)     Management (1)     SQL Server Management Studio (SSMS) (1)    
Mail (5)     Automation (1)     orphaned users (1)     Syntax Check (1)    
Administration (4)     Differential Backup (1)     point-in-time (1)     System Administration (1)    
   Items 1 to 20 of 238    Next 20 >>
 

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

Why Is It Complicated?

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...
By Steve Jones 2009/11/02 | Source: SQLServerCentral.com | Category: Editorial - MP3
Rating: (not yet rated)  Rate this |  Briefcase | 3 reads

Why Is It So Complicated?

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...
By Steve Jones 2009/11/02 | Source: SQLServerCentral.com | Category: Editorial - WMV
Rating: (not yet rated)  Rate this |  Briefcase | 7 reads

Why Is It Complicated?

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...
By Steve Jones 2009/11/02 | Source: SQLServerCentral.com | Category: Editorial
Rating: (not yet rated) |  Discuss |  Briefcase | 64 reads

Why Is It Complicated?

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...
By Steve Jones 2009/11/02 | Source: SQLServerCentral.com | Category: Editorial - iPod
Rating: (not yet rated)  Rate this |  Briefcase | 3 reads

How to identify when a database was restored, the source of the backup and the date of the backup

After restoring a database your users will typically run some queries to verify the data is as expected. However, there are times when your users may question whether the restore was done using the correct backup file. In this tip I will show you how you can identify the file(s) that was used for the restore, when the backup actually occured and when the database was restored.  Read more...
By Additional Articles 2009/10/27 | Source: MSSQLTips.com | Category: Backup / Restore
Rating:  Rate this |  Briefcase | 3,369 reads

How to Backup and Restore a SQL Server FILESTREAM Enabled Database

Most SQL Server DBAs have questions about backing up and restoring FILESTREAM enabled databases. In this tip, we will take a look at the steps Database Administrators need to follow in order to perform a backup and restore of a FILESTREAM database.   Read more...
By Additional Articles 2009/10/15 | Source: MSSQLTips.com | Category: Backup / Restore
Rating:  Rate this |  Briefcase | 1,473 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

A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network

Database sizes increase constantly, as do requirements for access and availability. At the same time, it is more important than ever to have a fast and reliable backup and recovery plan in place. This document discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs). Using a real-world example, it demonstrates how to make the best use of the backup and restore features of SQL Server 2008 to help create a fast and reliable backup and restore plan for VLDBs over the network.  Read more...
By Additional Articles 2009/09/25 | Source: SQLCAT | Category: Backup / Restore
Rating:  Rate this |  Briefcase | 2,549 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

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

BACKUP / RESTORE

By Jamie Longstreet-481950 2009/08/12 | Category: Backup / Restore
Rating: (not yet rated) |  Discuss |  Briefcase | 2,868 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 | 790 reads

Backup and Restore Tables

By bitbucket 2009/08/06 | Category: Backup / Restore
Rating: (not yet rated) |  Discuss |  Briefcase | 3,275 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

Use Backup/Restore to Minimize Upgrade Downtimes

Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.  Read more...
By Jonathan Kehayias 2009/06/18 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 5,018 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

Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO

Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.  Read more...
By Additional Articles 2009/02/24 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |  Briefcase | 803 reads
   Items 1 to 20 of 238    Next 20 >>
 
Most popular

How to identify when a database was restored, the source of the backup and the date of the backup

After restoring a database your users will typically run some queries to verify the data is as expected. However, there are times when your users may question whether the restore was done using the correct backup file. In this tip I will show you how you can identify the file(s) that was used for the restore, when the backup actually occured and when the database was restored.  Read more...
By Additional Articles 2009/10/27 | Source: MSSQLTips.com | Category: Backup / Restore
Rating:  Rate this |  Briefcase | 3,369 reads

Use Backup/Restore to Minimize Upgrade Downtimes

Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.  Read more...
By Jonathan Kehayias 2009/06/18 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 5,018 reads

A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network

Database sizes increase constantly, as do requirements for access and availability. At the same time, it is more important than ever to have a fast and reliable backup and recovery plan in place. This document discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs). Using a real-world example, it demonstrates how to make the best use of the backup and restore features of SQL Server 2008 to help create a fast and reliable backup and restore plan for VLDBs over the network.  Read more...
By Additional Articles 2009/09/25 | Source: SQLCAT | Category: Backup / Restore
Rating:  Rate this |  Briefcase | 2,549 reads