Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
2019-05-08
256 reads
Backup and restore
A Self-Serve System that Allows Developers to Refresh Databases (Part 1)
Empower developers to refresh their own test systems with production backups.
2019-05-02
6,730 reads
Using Backup Encryption with an External Certificate
Learn how to load an external certificate into SQL Server to encrypt your backups.
2019-04-25
4,520 reads
5 reasons why backup and restore doesn’t cut it in dev and test
The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.
2019-04-24
VLF truncation in SIMPLE recovery model
I recently presented a session on log file management where I discussed monitoring and managing the logical segments of the transaction log known as Virtual Log Files, or VLFs....
2019-04-12
Generate Restore Database Commands
Restoring a database backup from one server to another, or from one database to another on the same machine, often requires MOVE ... TO ... commands. For databases with...
2019-04-05
2018-09-04 (first published: 2018-08-23)
321 reads
2018-07-24
877 reads
2018-06-25
906 reads
2018-02-22
809 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers