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

Content with tags SQL Server 2005, Disaster Recovery (DR) Rss

   Items 1 to 9 of 9   
 

Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005

In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options?  Read more...
By Additional Articles 2008/12/31 | Source: MSSQLTips.com | Category: restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,201 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,111 reads

Rebuild Master

By Site Owners 2008/05/01 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 3,615 reads

Rebuild Master

By Site Owners 2008/04/22 | Category: disaster recovery (dr)
Rating: (not yet rated) |  Discuss |   Briefcase | 4,216 reads

Blogs: • How does daylight savings time affect disaster recovery?

We're featuring some interesting blog posts that we think have information you need to know. This one is from Paul Randal of SQL Skills, former storage engine lead for SQL Server. Do you know how the daylight savings time change will affect your computers?  Read more...
By 2007/10/17 | Source: Other | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 1,830 reads

Restore your SQL Server database using transaction logs

Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.  Read more...
By Additional Articles 2007/10/15 | Source: Builder.com | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 3,723 reads

Database Snapshots

In the first part of his series on SQL Server Availability, new author Kumar Parthasarathi brings us a look at Database Snapshots in SQL Server 2005.   Read more...
By Kumar Part 2006/09/21 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 10,373 reads

Copying Database Backups to an Alternative Location

Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.  Read more...
By Additional Articles 2006/09/08 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 4,309 reads

SQL Server 2005 High Availability

Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.   Read more...
By Steve Jones 2006/05/24 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 16,243 reads
   Items 1 to 9 of 9   
 
Tags
strategies (3)    
administration (2)    
backup / restore (1)    
bcp (1)    
common language runtime (clr) (1)    
export (1)    
high availability (ha) (1)    
restore (1)    
sql server 7 (1)    
sqlclr (1)