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

Content with tags Backup / Restore, SQL Server 2005 Rss

   Items 1 to 20 of 20   
 

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin  Read more...
By David A. Long 2012/08/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,259 reads

Comprehensive Backup Script

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.  Read more...
By Simon Facer 2011/12/22 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,321 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 8,861 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 database

By VM-723206 2010/09/22 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 3,226 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

Get Data, Log, Backup, and Binn Directory (SQL Server 2005)

Use this to find Data, Log, Backup, and Binn Directory for SQL Server 2005  Read more...
By Cowboy DBA 2008/12/15 | Source: SQLServerCentral.com | Category: data path
Rating: |  Discuss |   Briefcase | 1,592 reads

SQL – Backup Methods, Some Cool Scripts

This article will tell you about some ways of taking all databases backup using one single command.  Read more...
By Prashant Pandey 2008/11/07 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 13,241 reads

Exporting and Versioning Lookup Data: A Real-World Use of the CLR

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...
By Solomon Rutzky 2008/06/24 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,098 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

Named Pipes

By Site Owners 2008/04/23 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 3,944 reads

Backups

By Site Owners 2008/04/21 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 5,146 reads

Tail Log Backups

By Site Owners 2008/04/17 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 3,738 reads

Comprehensive Backup Script

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.  Read more...
By Simon Facer 2011/12/22 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,321 reads

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin  Read more...
By David A. Long 2012/08/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,259 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 8,861 reads

Introduction to SQL Server 2005 Database Backups

Backing up a database is one of the most important things you need to do when having a database driven application. It 's only all of your data in there, right? But often developers and management don't realize the importance of backups and overall proper backup strategy for the most important side of the business – data and it's consistency.  Read more...
By Additional Articles 2008/01/03 | Source: SQLTeam.com | Category: sql server 2005
Rating:  Rate this |   Briefcase | 3,946 reads

Mirrored backup and restore commands in SQL Server 2005

Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family.  Read more...
By Additional Articles 2007/11/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 1,927 reads

Featured Blog: BACKUP LOG WITH NO_LOG

From one of the SQL Server 2005 storage engine lead developers comes this look at the impact of using the NO_LOG and TRUNCATE_ONLY options.  Read more...
By Additional Articles 2007/10/24 | Source: SQLskills | Category: backup / restore
Rating:  Rate this |   Briefcase | 2,990 reads
   Items 1 to 20 of 20   
 
Tags
sql server 2008 (3)    
sql server 7 (2)    
administration (1)    
bcp (1)    
common language runtime (clr) (1)    
compression (1)    
copy_only (1)    
data directory (1)    
data path (1)    
disaster recovery (dr) (1)    
export (1)    
log directory (1)    
log path (1)    
performance tuning (1)    
security (1)    
sqlclr (1)