|
|
|
SSC Eights!
 
Group: General Forum Members
Last Login: Yesterday @ 5:29 AM
Points: 938,
Visits: 468
|
|
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."
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166,
Visits: 6,925
|
|
Is that more than 16 data files? Or is it with log files?
sp_attach_db has hardcoded 16 file limit because of the parameters. Look at the code. If you're doing more than that, someone must have modified your procedure.
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 1:04 AM
Points: 19,
Visits: 76
|
|
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.
|
|
|
|
