Home > SQL Server Learning Center
EMAIL THIS
 Learning Center:  Backing up SQL Server
Last Updated: Nov 21, 2005 
Backing up and restoring your SQL Server is an essential component of database management. This collection of tips, expert responses and advice will give you the resources you need to implement and test your backup and recovery.
>> Click here to ask Back up and Recovery expert Greg Robidoux a question.
Step-by-Step Guide: How to properly back up a SQL Server

(09 Nov 2005)

Edgewood Solutions' Greg Robidoux offers a three-part guide for putting together a SQL Server backup process -- planning, testing and implementation.

Read Full Story
ADVICE:
>> Selecting a SQL Server backup model
TIP :Greg Robidoux looks at some of the components to help define a backup strategy as well as the different backup options that ...
>> Faster SQL Server backups in 10 steps
TIP :Faster SQL Server backups can be achieved with these 10 steps. Learn methods which include backing up to disk, writing to ...
>> Backup and recovery enhancements in SQL Server 2005
TIP :SQL Server 2005 backup and restore has new features worthy of your attention. Backup and recovery expert Greg Robidoux talks ...
>> Troubleshooting SQL Server backup and restore dilemmas
TIP :SQL Server backups and restores don't always go smoothly. Edgewood Solutions' Greg Robidoux identifies five common backup and ...
>> SQL Server backups made easy using Maintenance Plans
TIP :If you're new to SQL Server and not sure how to set up backups, Maintenance Plans may be the way to go.
>> SQL Server backup and restore, part II: Best practices
TIP :Always select the SQL Server recovery model and backup options that provide the most flexibility. This tip offers best ...
>> SQL Server backup and restore, part I: The basics
TIP :This indepth tip analyzes the various options available for your backup and recovery process with SQL Server 2000.
>> SQL Server backup and recovery mistakes
TIP :Commom SQL Server backup and recovery mistakes are identified by expert Greg Robidoux.
>> Use backup/restore to move or copy databases between instances of SQL Server
TIP :At some point, almost every SQL Server administrator faces the prospect of copying or moving a database from one instance to ...
>> Backup fails when different users are using the network
ASK THE EXPERTS :I've used SQL DMO object to take a complete backup at a scheduled time to a network computer. It works fine if all of the ...
>> Backup data to domain/network drive
ASK THE EXPERTS :I am a new DBA and support Microsoft's Retail Management System (RMS). RMS uses MSDE at each retail location to collect data ...
>> SQL Server database backup and restore in different servers using DTS
ASK THE EXPERTS :I need to restore a database in a different server than it was backed up in. I need to do this three times each day, so I ...
>> SQL Server primary database backup options
ASK THE EXPERTS :I am not an expert when it comes to SQL databases. I have two active SQL servers (two separate machines with their own static ...
>> Best practices for backing up the master, model, and msdb databases
ASK THE EXPERTS :What are the best practices for backing up the master, model, and msdb databases?
>> Error backing up SQL Server 2000 database
ASK THE EXPERTS :I get the following error when I try to back up the SQL Server 2000 database that has about 40 GB in the Windows 2000 ...
>> More information on backups and re-indexing
ASK THE EXPERTS :I've inherited the backup jobs from the previous Database Administrator and they are not "normal" jobs as far as I can tell. ...
>> Restoring a database without a backup
ASK THE EXPERTS :How do I restore a database on SQL Server 7.0 using .mdf, .ldf and .ndf files? I have no backup database available, but I do ...
>> Replicating and backing up logs without overwriting previous ones
ASK THE EXPERTS :I would like to know best practices for replicating and backing up logs without overwriting previous logs, while maintaining ...
LEARNING TOOLS:
>> Checklist: Backing up SQL Server

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
SQL Server Backup and Recovery
SQL Server Mailbag: Data restoration and DB property management
Achieving high availability and disaster recovery with SharePoint databases
How to 'do' SQL Server disaster recovery
The keys to database backup protection for SQL Server
Choosing a SQL Server disaster recovery solution
Licensing a standby server for SQL Server replication
Can I encrypt and restore a database backup in SQL Server 2005?
SQL Server errors, failures and other problems fixed from the trenches
Get SQL Server log shipping functionality without Enterprise Edition
SQL Server 2008 backup compression pros and cons
SQL Server Backup and Recovery Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
rollback  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

> SQL Server restore how-tos
> Learning Center: Top 10 SQL Server security tips
> SQL Server 2005 data mining
> SQL Server 2005 security
> Database design decisions
View All Topics

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts