How Can we do Detach and Attach a Live database in sql 2005

Question

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

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

george sibbald SSC Guru Points: 104210 More actions · Answer 1

would need to know what you are trying to acheive by doing this but perhaps you should read this:

---------------------------------------------------------------------

AAKR SSCommitted Points: 1586 More actions · Answer 2

SSCommitted

Points: 1586

February 15, 2013 at 8:40 am

Thank you 🙂

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

You can't detach a database with users actively connected to it. You'll have to kick them off first. No choice there.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt