Join Martin Guidry for an in-depth discussion in this video Performing an SQL backup with PowerShell, part of SQL Server 2012: Designing Database Solutions.
- Some administrators really like the command line…interface of PowerShell.…Other administrators really don't like it.…I believe that at a minimum every administrator…should know how to perform some emergency steps…on a SQL server using the command line interface.…The idea here is that if a server is so broken…that the graphical interface will no longer function.…There's still a chance you could get to a command line tool…and issue a few commands to either fix the server,…or more likely just to perform one last backup…so that you can then restore to a different server.…
So I feel that every administrator should know…how to perform a backup using the command line tools.…I'm gonna demonstrate that to you now…here inside of the PowerShell interface.…First I'll import the sqlps module.…Now I'm just going to use the cd command…to set the appropriate base location.…It's basically the name of my server and my instance.…This might be slightly different for you.…Now the command is fairly simple,…it's Backup-SqlDatabase.…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.