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

Content with tags SQL Server 2008, Backup / Restore Rss

   Items 1 to 12 of 12   
 

SQL DBAdmin toolbox - Part 1: Restore single database

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...
By Infostar 2011/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,418 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,107 reads

Backup Compression Ratio

Display's backup compression ration for SQL 2008 (Enterprise or Developer)  Read more...
By Gregory Ferdinandsen 2010/08/31 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,026 reads

SQL Server 2008 Compression

Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.  Read more...
By Jason Shadonix 2010/04/22 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 7,380 reads

SQL Server 2008 Backup

By Amol Naik 2010/01/01 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 2,902 reads

Decompressing on Compression in SQL Server 2008....

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...  Read more...
By Robert Pearl 2009/09/02 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,043 reads

BACKUP / RESTORE

By Jamie Longstreet-481950 2009/08/12 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 3,328 reads

Copy Only Backup for SQL 2005 and SQL 2008

Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?  Read more...
By Additional Articles 2009/06/30 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,113 reads

Restore a SQL Server 2008 Database into SQL Server 2005

You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.   Read more...
By Additional Articles 2009/01/26 | Source: DevX | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,471 reads

SQL Server 2008 Recovery Models and Backups

This article examines the Recovery Model options used by SQL Server 2008 and the various methods that can be used to backup a database such as Differential and Transaction Logging. In addition, Transaction Logs, the mechanism that makes Recovery Models possible will be introduced.  Read more...
By Additional Articles 2008/11/17 | Source: Database Journal | Category: backup / restore
Rating:  Rate this |   Briefcase | 2,754 reads

Tuning the Performance of Backup Compression in SQL Server 2008

ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not  Read more...
By Additional Articles 2008/05/12 | Source: MSDN Communities | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 1,792 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,107 reads
   Items 1 to 12 of 12   
 
Tags
compression (5)    
sql server 2005 (3)    
backup (1)    
backup compression (1)    
blogs (1)    
compression ratio (1)    
copy_only (1)    
data (1)    
performance tuning (1)    
restore (1)