Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore a .DAT file
Message
De
06/07/1999 02:49:00
 
 
À
05/07/1999 08:14:50
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Recouvrement
Divers
Thread ID:
00235316
Message ID:
00237639
Vues:
28
Thank you very much Mike. Yes, you need to set "Single User" on.
I just wonder, what will happen after shrinking the database? Will the size
stays permanently? Is this the "size" that we declare the database devices
at the initial part before creating the database?

Another question, when will the "Expand" and "Shrink" of databases be required?
Thanks again.

>You're using 6.5 right? In 6.5 you use the DBCC SHRINKDB command. You'll have to set either the DBO Use Only or Single User database properties. I don't remember which. You can also shrink the database using the SEM which will set the correct database property for you.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform