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

Question

Post reply

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

SSC Guru

Points: 104210

February 15, 2013 at 8:33 am

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: 397721 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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software