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

Articles with tags Administering, SQL Server 7, 2000, Configuring, Backup and Recovery Rss

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

Miscellaneous (6)     Disaster Recovery (2)     User-Defined functions (2)     Performance Tuning and Scaling (1)    
Indexing (4)     DTS (2)     ADO (1)     SQL-DMO (1)    
Replication (4)     Installation (2)     Distributed Queries (1)     UpdateGrams (1)    
Strategies (3)     Programming (2)     English Query (1)     Visual Basic 6 (1)    
T-SQL (3)     Security (2)     Monitoring (1)     XML (1)    
Availability (2)     Stored Procedures (2)     OpenXML (1)     XSL (1)    
Basic Querying (2)     Triggers (2)     Performance Tuning (1)    

Search for any content tagged Administering & SQL Server 7, 2000 & Configuring & Backup and Recovery

   Items 1 to 8 of 8   
 

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: Installation
Rating: (not yet rated) |  Discuss |  Briefcase | 17,325 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: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 6,805 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,135 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2002/07/31 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 7,850 reads

Maintenance Plans - Backups and Removing Old Files

Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean!   Read more...
By Andy Warren 2002/06/10 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 7,066 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: Installation
Rating: (not yet rated) |  Discuss |  Briefcase | 6,289 reads

Maintenance Plans - Behind the Scenes

Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!   Read more...
By Andy Warren 2002/05/27 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 9,168 reads

SQL Maintenance Plans - Under the Covers!

In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!   Read more...
By Andy Warren 2002/05/21 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 7,818 reads
   Items 1 to 8 of 8