SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tags Backup and Recovery, Miscellaneous, Programming Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 7, 2000 (3)     Replication (2)     ADO (1)     Strategies (1)    
Administering (2)     SQL-DMO (2)     Availability (1)     T-SQL (1)    
Configuring (2)     Visual Basic 6 (2)     Disaster Recovery (1)    
   Items 1 to 3 of 3   
 

Another Disaster (Almost)

Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.   Read more...
By Andy Warren 2003/01/14 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 6,881 reads

Review of Real-World SQL-DMO

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!   Read more...
By Andy Warren 2002/11/19 | Source: SQLServerCentral.com | Category: Administering
Rating: (not yet rated) |  Discuss |  Briefcase | 5,163 reads

Restoring Using DMO - Getting File List and No Recovery

Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code!   Read more...
By Andy Warren 2002/10/15 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 8,159 reads
   Items 1 to 3 of 3