SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Backup and 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,352 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 and restore
Rating: |  Discuss |   Briefcase | 3,361 reads

Backup Stored Proc

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

backup database

By VM-723206 2010/09/22 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 3,283 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 and restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,731 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,812 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,628 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 and restore
Rating: |  Discuss |   Briefcase | 13,251 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,202 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,153 reads

Named Pipes

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

Backups

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

Tail Log Backups

By Site Owners 2008/04/17 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 3,766 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 and restore
Rating: |  Discuss |   Briefcase | 3,361 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,352 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 8,900 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 | 4,280 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 | 2,173 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 and restore
Rating:  Rate this |   Briefcase | 3,160 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)