Information générale
Catégorie:
Bases de données
>>When and why do you see the need for attaching/detaching databases?
>>Regards,
>>Viv
>
>The accountant (= accountant(s) + employees) decides to work on my data today (customer 27, year 2008). If (say) 00027_2008.mdf is not attached, it has to be attached to the sql server instance so he can work on it.
>
>If another employer wants to work on my data at the same time, the 00027_2008.mdf does not have to be attached since it already is. So he can simply connect to it.
>
>When the last person is done with 00027_2008.mdf, it has to be detached from the sql server instance [ we are talking about thousands of databases ]
Why not leave them all attached?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement