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

Content with tags Programming, Backup / Restore Rss

   Items 1 to 5 of 5   

VBScript Class to Return Backup Information

The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.   Read more...
By Bruce Szabo 2003/08/28 | Source: | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,734 reads

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: | Category: administration
Rating: |  Discuss |   Briefcase | 7,034 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: | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 5,245 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: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,480 reads

VBScript Classes to Query SQL Server for Backup Information

A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.   Read more...
By Bruce Szabo 2002/08/22 | Source: | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,103 reads
   Items 1 to 5 of 5   
sql server 7 (5)    
sql-dmo (4)    
miscellaneous (3)    
administration (2)    
configuring (2)    
disaster recovery (dr) (2)    
replication (2)    
strategies (2)    
visual basic 6 (2)    
ado (1)    
availability (1)    
t-sql (1)