If we shrink the Databse and Files, how much size is
decreased?
Answer Posted / lmr
The primary data file cannot be made smaller than the size
of the primary file in the model database.
for eg. while creating a db having size 10 MB
N GREW 100MB
then max the can be shrunk to 10MB.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is local temp table?
What is the difference between insensitive and scroll cursor?
How you can add messages to the nt event log from within a stored procedure?
Do you know what is xpath?
What is create command?
What are four major operators that can be used to combine conditions on a where clause?
What is the usage of the sign function?
What is index, cluster index and nonclustered index?
What is collation sensitivity?
Explain the architecture of ms sql reporting service?
What are the 2 types of classifications of constraints in the sql server?
What is built-in/administrator?
What is the difference between upgrade and migration in sql server?
How to insert data into an existing table?
What are transactions and its controls?