SQLAndy

Blog Post

Not Enough Time

I’ve been thinking about my goals for 2010, ones that I’ve set and adjusted a couple times, and thinking more...

2010-12-07

534 reads

Blog Post

IT Education Part 1

Like many in IT I’m self taught, starting with DOS and batch files, then proceeding through QuickBasic, Visual Basic in...

2010-12-06

619 reads

Blog Post

LiveWriter 2011

I recently upgraded to LiveWriter 2011 while upgrading to the final version of LiveMesh. After the upgrade I noted the...

2010-12-01

339 reads

Blog Post

PASS Update #48

It’s the end of November and this will probably be my last update on PASS for the year as things...

2010-11-29

1,562 reads

Blog Post

TechEd 2011

TechEd will be in Atlanta next year, May 16-19, 2011 at the Georgia World Conference Center. I went this year...

2010-11-29

1,533 reads

Blogs

Monday Monitor Tips: AI Query Analysis

By

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

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

AI: Blog a Day – Day 7: Vector and Vector Databases

By

Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...

Read the latest Blogs

Forums

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Restoring On Top I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Restoring On Top I

Visit the forum

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 REPLACE

See possible answers