SQL Server Science
Technical Articles for the DBA / Developer
Home » backup

Storing Backups Locally? You have no Backups!

2019-02-22 · by Hannah Vernon · in recovery

Me, being nice! You’ve got business critical data stored in your SQL Server, don’t you? And you’re taking backups of those databases, right? But where are you storing those backups? If you’re storing backups locally,…

Modify device path for multiple Backup Devices

2019-01-18 · by Hannah Vernon · in maintenance, tools

Backup Devices provide a nice way to permanently configure the backup location, enabling BACKUP DATABASE to look like:

Transact-SQL
1
BACKUP DATABASE [xyz] TO [backup-device-name];

When you create a Backup Device, you specify the physical location where backups will actually be…

Backup Performance Testing

2018-07-25 · by Hannah Vernon · in performance, tools

Reliable database backups are perhaps the single most important aspect of a Database Administrator’s job. The business risk from data-loss that can occur without a reliable database backup are substantial enough to bring many smaller…

subscribe now for updates
Stay up-to-date with the latest posts as they happen!
* = required field
unsubscribe from list

Search

Categories

  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Internals
  • maintenance
    • patching
  • performance
  • recovery
  • reporting
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Cart
  • Checkout
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • My account
  • Privacy Policy
  • Shop

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2023 SQL Server Science