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://www.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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply