Recreate detached database file from a backup

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Sure. Just restore the backup, then detach!

Andy

Bengt Mr or Mrs. 500 Points: 569 More actions · Answer 2

So, it is not possible to "skip" the restore and get the detached files directly?

Bengt

nigelrivett SSCertifiable Points: 5472 More actions · Answer 3

Nope - well not obviously.

You can code the detach directly after the restore so it's done immediately.

Why do you want to do it?

Cursors never.
DTS - only when needed and never to control.