Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore a .DAT file
Message
From
06/07/1999 02:49:00
 
 
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Miscellaneous
Thread ID:
00235316
Message ID:
00237639
Views:
27
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform