|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, February 08, 2012 10:51 AM
Points: 1,010,
Visits: 654
|
|
BOL 2000
"sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation. If more than 16 files must be specified, use CREATE DATABASE with the FOR ATTACH clause."
|
|
|
|
|
One Orange Chip
Group: Administrators
Last Login: Today @ 5:12 PM
Points: 29,500,
Visits: 11,680
|
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Sunday, February 27, 2011 10:31 PM
Points: 23,
Visits: 92
|
|
Is there any risk in using sp_detach in production database? I would like to move some of my data file in different array partition to have more disk space. I'm just worried about the uncommitted transaction in my production database.
If i have a downtime schedule let say tomorrow at 8:00 am then i detach my database at 8:30 am. What will happen to the transactions? Is the sp_detach will not delete the uncomitted transcation then this will comit after sp_attach? i know the transaction is in logs, I just want to make sure that i will not do anything wrong in my data.
Thanks for the expert advice.
|
|
|
|
