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

Content with tags Backup / Restore, SQL Server 7 Rss

   Items 1 to 20 of 39    Older >>
 

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 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,492 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 / restore
Rating: |  Discuss |   Briefcase | 3,318 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 8,860 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,198 reads

Differential Backup Store Procedure for SQL Server 2000

The Store Procedure can be use for generating Differential Backup datewise in SQL Server 2000.  Read more...
By Swapnil Tawde 2009/07/14 | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 714 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 / restore
Rating: |  Discuss |   Briefcase | 3,318 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,198 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 8,860 reads

Building Automated Backups

Backups are the foundation of any well run database server, or even any computer system. Numerous articles have been written about SQL Server backups and new author Paulo Luis brings us a new twist on building automated backups using devices.   Read more...
By Paulo Luis 2006/08/29 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 12,685 reads

Stored procedure: Determine last database backup

You have many SQL Servers to administer and you just want to know when the last backup was taken for each database on each instance. This stored procedure will help.  Read more...
By Additional Articles 2006/04/13 | Source: Other | Category: backup / restore
Rating:  Rate this |   Briefcase | 3,876 reads

Push FTP with SQL Server

DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.   Read more...
By Steve Jones 2005/07/01 (first published: 2001/11/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 36,503 reads

Recovery to a Point in Time

This is one of the very useful features in SQL Server 2000 and if you ever have the need to perform this actiom, you will appreciate the knowledge in this article.   Read more...
By Grant Fritchey 2005/06/15 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 13,023 reads

Restoring to a Point In Time

One of the lesser used features of SQL Server 2000, but the capability to restore your databases to a particular point in time can be a valuable skill. Kathi Kellenberger takes a moment to explain how this feature works and how you can use it in your environment.   Read more...
By Kathi Kellenberger 2005/06/14 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 16,977 reads

Implementing a Flexible Backup Strategy

SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.   Read more...
By Eli Leiba 2004/10/19 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 11,098 reads

Backup Scenarios for successful SQL Server Restores and Recovery

SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan.   Read more...
By Bilal Ahmed 2004/06/29 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 17,532 reads

Review of Lumigent Log Explorer v4

Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does.   Read more...
By Christoffer Hedgate 2004/02/13 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 7,754 reads

From the soapbox: Does anyone know what disaster recovery is?

New Author! Written as a rant, this article covers a couple basic issues that STILL tend to get overlooked in a lot of places. It's run to rant sometimes but we plan to maintain our focus and continue to keep these a small percentage of our content. Let us know what you think.   Read more...
By James Luetkehoelter 2004/01/28 | Source: SQLServerCentral.com | Category: rants
Rating: |  Discuss |   Briefcase | 6,210 reads

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: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,734 reads

Integrating SQL LiteSpeed in your existing Backup Infrastructure

This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration.   Read more...
By Jeremy Kadlec 2003/05/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,347 reads

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: |  Discuss |   Briefcase | 18,204 reads
   Items 1 to 20 of 39    Older >>
 
Tags
administration (16)    
miscellaneous (9)    
configuring (8)    
strategies (8)    
disaster recovery (dr) (7)    
replication (6)    
t-sql (6)    
indexing (5)    
programming (5)    
performance tuning (4)    
sql-dmo (4)    
dts (3)    
availability (2)    
installation (2)    
monitoring (2)    
security (2)    
sql server 2005 (2)    
stored procedures (2)    
triggers (2)    
user defined function (udf) (2)    
visual basic 6 (2)    
ado (1)    
advanced querying (1)    
backup / recovery (1)    
differential backup (1)    
distributed queries (1)    
english query (1)    
openxml (1)    
other (1)    
product reviews (1)    
rants (1)    
restore (1)    
reviews (1)    
updategrams (1)    
xml (1)    
xsl (1)