Search this blog
The Current Book – The Phoenix Project (re-reading)
-
18 Year MVP Awardee
Tags
- administration
- AI
- AIExperiments
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- encryption
- Flyway
- Friday Poll
- FWTips
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- Microsoft
- misc
- monitoring
- networking
- PASS
- Performance
- powershell
- presentations
- Redgate
- Redgate Monitor
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- words
- work
Search this blog
Steve’s Tweets
Tweets by way0utwestOlder Posts
Meta
Tag Archives: Backup/Recovery
A Full Backup Includes Everything (with a caveat)
Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something is in the database when the data reading portion of the backup concludes, it’s in there. Note that “in there” … Continue reading
Posted in Blog
Tagged administration, Backup/Recovery, sql server, syndicated
Comments Off on A Full Backup Includes Everything (with a caveat)
Accidently Kicking a Database into the Restoring State
I learn new things all the time. This was one that actually stunned me. Huge props to Gail Shaw for posting a note about this in a thread. Run this code: CREATE DATABASE MyRestoreTest ; GO USE MyRestoreTest go BACKUP … Continue reading
Backups and Consistency
I wrote about transactional consistency recently. Why do we need this? Imagine that I have an orders table and an ordersdetail table in my database. The orders table has the order header (date, customer, etc) and the detail table includes … Continue reading
How SQL Server Full Backups Work
I’m writing this in support of a few talks I give that talk about backups. This is how I see things and it’s based on things I’ve learned over time. Some of this comes from a great explanation on Technet … Continue reading
Posted in Blog
Tagged Backup/Recovery, sql server, syndicated
Comments Off on How SQL Server Full Backups Work
Voice of the DBA 