February 15, 2013 at 8:06 am
Hi Friends,
I have an requirement to detach and attach the Live databases. Please suggest me how to do it.
Thank you in advance. 🙂
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:
http://qa.sqlservercentral.com/articles/Administration/65896/
---------------------------------------------------------------------
February 15, 2013 at 8:40 am
Thank you 🙂
February 15, 2013 at 11:42 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply