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 are the system database in sql server 2008?
Explain indexed views and partitioned view with their syntax.
How do we synchronize On-Premise SQL server with SQL Azure?
ow to bring suspect mode datbase online from scratch
What do you understand by triggers?
What is standby servers? Explain types of standby servers.
Can sql servers link to other servers?
How do you improve the performance of a SQL Azure Database?
Explain activity monitors
What function does a database engine serve in the sql server?
Will the writetext statement activate a trigger?
what purpose does the model database serve? : Sql server database administration
What is merge replication?
what are cursors? : Sql server database administration
Can multiple columns be used in sql group by clause in ms sql server?