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 193    Older >>
 

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: backup / recovery
Rating: |  Discuss |   Briefcase | 4,066 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,435 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: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 102 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,018 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,592 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,847 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,822 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,150 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,531 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,582 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,121 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,862 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,862 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,822 reads

Change SQL Startup Parameters with PowerShell

Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...  Read more...
By eric.humphrey 2011/04/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,292 reads

Streamlining granular recovery for SharePoint, with Red Gate and Metalogix

We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:  Read more...
By Additional Articles 2011/02/23 | Source: Other | Category: backup / restore
Rating:  Rate this |   Briefcase | 1,743 reads

SQL Azure - Creating backups and copies of your databases

As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?  Read more...
By Additional Articles 2011/02/10 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,108 reads

A Full Backup can Impact a Log Backup–MCM Prep

In the early days of SQL Server you could not run a log backup while a full backup was running....  Read more...
By Steve Jones 2011/02/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,712 reads

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore  Read more...
By Press Release 2011/01/27 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,881 reads
<< Newer    Items 21 to 40 of 193    Older >>