SQL Server Backup and Restore - things you need to know

Sponsored by - IDERA

Webcast Abstract

SQL Server offers many options for backing up your data and your databases. It’s important to make sure you have the right backup strategy in place, but the real key is knowing how to recover your data and databases when the time arises.

In this educational webcast, we will look at several techniques that you need to be familiar when there is a need to recover your data. This may be for disaster recovery or maybe just to build or refresh a development or test environment. Some of the topics that we will cover include:

• Database recovery models
• Database backup options
• Data import / export
• Generating scripts
• Dealing with orphaned logins
• Restoring TDE databases
• Restoring transaction logs
• Using differentials when restoring
• Restoring on the same server
• Restoring on a different server
• Recovering an object or data from a backup
• Using backups to create a test or dev environment
• and more.

Speaker - Ray Barley

Ray Barley is a Principal Architect at RDA Corporation and has been writing articles for MSSQLTips.com since 2008.

To access materials please fill out the form below.

First Name*

Last Name*

Email*

Address*

City*

State

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Puerto Rico Virgin Islands Guam Alberta British Columbia Manitoba New Brunswick Newfoundland Northwest Territories Nova Scotia Nunavut Ontario Prince Edward Island Quebec Saskatchewan Yukon Other

Postal Code*

Country*

United States Canada Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia-Herzegowina Botswana Bouvet Island Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Cape Verde Cayman Islands Chad Chile China Christmas Island Colombia Comoros Congo (Democratic Republic) Congo Cook Islands Costa Rica Cote d'Ivoire Croatia Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Finland France French Guiana French Polynesia Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Iran Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldova, Republic of Monaco Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island North Korea Norway Oman Pakistan Palau Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Poland Portugal Qatar Reunion Romania Russian Federation Rwanda Saint Kitts and Nevis Saint Lucia Samoa (Independent) Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Korea Spain Sri Lanka St. Helena Suriname Swaziland Sweden Switzerland Taiwan Tajikistan Tanzania Thailand Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Tuvalu Uganda Ukraine United Arab Emirates United Kingdom Uruguay Uzbekistan Vanuatu Vatican City Venezuela Viet Nam Western Sahara Yemen Zambia Zimbabwe Other

Phone*

Industry*

Accounting Advertising/Marketing/PR Aerospace & Defense Agriculture Apparel Associations Automotive Banking & Securities Biotech Call Center Outsourcing Construction Consulting Consumer Goods & Services Education Energy, Chemical, Utilities Financial Services - Other Food & Beverage Furniture Government - Federal Government - State & Local High Tech - Hardware High Tech - ISP High Tech - Other Home & Garden Hospital, Clinic, Doctor Office Hospitality, Travel, Tourism Insurance Legal Manufacturing Medical, Pharma, Biotech Mining Other Pharmaceuticals Printing & Publishing Real Estate Recreation Retail Software - Finance Software - Healthcare Software - Other Support Outsourcing Telecommunications Textiles Transportation & Distribution VAR/Systems Integrator

Organization*

Title*

Application Developer Back up Administrator C- Level (CEO, CFO, CIO, CMO, CSO, CTO Data Analyst Database Administrator DBA Manager Developer eCommerce/eBusiness Manager Exchange/Mail Administrator Help Desk Staff/Manager Infrastructure Architect/Manager IT Applications Manager IT Architect IT Consultant IT Director/VP IT Manager IT Security Director Java Developer Network Administrator Network Manager Non IT Director/VP Other Partner Project Manager Security Officer Software Engineer Student System Administrator Systems Analyst/Architect Systems Engineer Virtualization Administrator

# of SQL Servers*

Organization Size

1-99 1-99 100-499 500-999 1,000-1,999 2,000-4,999 5,000-9,999 10,000-19,999 20,000+

Save Details

Signup for our newsletter

By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.