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,355 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,369 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,905 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,156 reads

backup database

By VM-723206 2010/09/22 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 3,286 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,865 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,938 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,629 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,254 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,205 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,156 reads

Named Pipes

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

Backups

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

Tail Log Backups

By Site Owners 2008/04/17 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 3,770 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,369 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,355 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,905 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,417 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,297 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,249 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)