Blogs

SQL Server Essentials for Oracle DBAs: (12) Backup and Recovery

Posted: Dec 28, 2012 at 9:11 AM
By: JeffKoch
Avg Rating: 5

(1)
2,411 Views
reddit

Tweet

43 minutes, 17 seconds

format
< > embed
+ queue

Sign In first to access your queue.
Close

Sorry, video was not added to the queue, an error occurred. Please Contact Us and let us know.
Close

Embed code for this video

Copy the code above to embed our video on your website/blog.

Video format

Option selected may change based on video formats available and browser capability.

Auto
Use our suggested format for this video.
Smooth Streaming
Adaptive bitrate streaming - little buffering but lower video quality at times of low bandwidth. Silverlight 5 required
Progressive
Traditional buffered video format. Silverlight 5 required
HTML5
For browsers that support H.264 MP4 or WebM video playback such as:
IE9+, Firefox 4+, Chrome 5+, or Safari 4+.
Flash
For browsers that have the Adobe Flash Player plugin installed.

Download

Right click “Save as…”

MP3 (Audio only)

File size
39.6 MB
MP4 (iPod, Zune HD)

File size
237.5 MB
Mid Quality WMV (Lo-band, Mobile)

File size
106.3 MB
High Quality MP4 (iPad, PC)

File size
523.8 MB
Mid Quality MP4 (WP7, HTML5)

File size
364.6 MB
High Quality WMV (PC, Xbox, MCE)

File size
449.6 MB

Module 12 lists the types of errors encountered in a database and the various mechanisms that are available to safeguard against these errors. This module discusses various types of backups and recovery methods available. This module also covers Oracle’s Recovery Manager (RMAN) and the equivalent functionality available in SQL Server Management Studio.

[02:30] - Backup methods
[08:35] - Recovery model
[14:30] - Recovering from database errors
[20:28] - Maintenance plan backup

Full course outline:

Mod 01: Database and Instance
Mod 02: Database Architecture
Mod 03a: Instance Architecture Part 1
Mod 03b: Instance Architecture Part 2
Mod 04: Data Objects
Mod 05: Data Access
Mod 06: Data Protection
Mod 07: Basic Administration
Mod 08: Server Management
Mod 09: Schema Management
Mod 10: Database Security
Mod 11: Data Movement
Mod 12: Backup and Recovery
Mod 13: Performance Tuning
Mod 14: Scalability and High Availability
Mod 15: Monitoring

Follow the Discussion

Follow
Oops, something didn't work.

Try again?

Sign In to be begin to follow these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.

Getting "follow" information

Stop following these comments

Start following these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.

Removing your "follow"

Setting up your "follow"

Did you know you can
sign up for email notifications?
- Subscribe to this comments

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.