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

Articles with tag Backup / Restore Rss

Search for any content tagged backup / restore

<< Newer    Items 21 to 40 of 198    Older >>
 

Free eBook: SQL Server Backup and Restore

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.  Read more...
By Press Release 2013/01/25 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,878 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 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,502 reads

SQL Server Backup Questions We Were Too Shy to Ask

During presentations about doing database backups and restores, there seem to be two two types of questions that are commonly asked, Those that come from the floor during the presentation, and those that are asked in private afterwards. These are sometimes more interesting, and challenging to answer well.  Read more...
By Additional Articles 2012/12/11 | Source: SimpleTalk | Category: backup / restore
Rating:  Rate this |   Briefcase | 3,160 reads

Free eBook: SQL Server Backup and Restore

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.  Read more...
By Press Release 2013/01/25 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,878 reads

Simplified Restores with SQL Server 2012 Recovery Advisor

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.  Read more...
By Jonathan Kehayias 2012/06/27 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,757 reads

Instant File Initialization and restores

Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.  Read more...
By Johan Bijnens 2012/05/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,078 reads

Partial Backup and Restore

Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.  Read more...
By Additional Articles 2012/05/15 | Source: SimpleTalk | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,453 reads

Replace existing Database? JFDI!

Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…  Read more...
By Tony Davis 2012/04/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

How to create a database backup using visual studio

This article describes how to backup a database using a C# Windows Form.   Read more...
By Daniel Calbimonte 2012/03/30 | Source: SQLServerCentral.com | Category: c#
Rating: |  Discuss |   Briefcase | 8,009 reads

Backing Up a SQL Server Database Directly Onto a Remote Server

Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy  Read more...
By Additional Articles 2011/12/22 | Source: SQL Server Performance | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,034 reads

Automating Daily Checks with Powershell

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...
By Warren Campbell 2011/12/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 10,650 reads

Automatically Scripting Out Permissions for Cross Environment Restores

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...
By Warren Campbell 2011/12/05 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 4,873 reads

Initialize SQL Server replication using a database backup

You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.  Read more...
By Additional Articles 2011/09/08 | Source: MSSQLTips.com | Category: transactional replication
Rating:  Rate this |   Briefcase | 2,934 reads

SQL Server Restore Tutorial

What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.  Read more...
By Additional Articles 2011/08/19 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,163 reads

Backup to multiple files for faster and smaller SQL Server backup files

Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.  Read more...
By Additional Articles 2011/07/29 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,565 reads

SQL Server Database Backup and Restore Failure Notifications

SQL Server ships with native alerts that can be configured to notify an operator when a backup or restore failure occurs. This chart shows the SQL Server 2000 backup and restore alerts.  Read more...
By 2011/07/22 | Category: sql server 2000
Rating: (not yet rated)  Rate this |   Briefcase | 2,641 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,134 reads

SQLServerCentral Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA

Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software. This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.   Read more...
By Press Release 2011/05/26 (first published: 2011/05/23) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,888 reads

SQLServerCentral Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA

Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software. This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.   Read more...
By Press Release 2011/05/26 (first published: 2011/05/23) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,888 reads

Backup and Restore of an Analysis Services Database

One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.   Read more...
Rating:  Rate this |   Briefcase | 2,833 reads
<< Newer    Items 21 to 40 of 198    Older >>