If we shrink the Databse and Files, how much size is
decreased?



If we shrink the Databse and Files, how much size is decreased?..

Answer / 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

More SQL Server Interview Questions

What is sql server replication? : sql server replication

0 Answers  


explain different levels of normalization? : Sql server database administration

0 Answers  


What happens when unicode strings concatenate with non-unicode strings?

0 Answers  


New concepts of sql server 2005 use in your project.

0 Answers   TCS,


Where do you find the default Index fill factor and how to change it?

0 Answers  






What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,


what command is used to create a table by copying the structure of another table?

7 Answers  


Explain what is analysis service repository?

0 Answers  


can a database be shrunk with users active? : Sql server administration

0 Answers  


What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,


if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  


What is a rollup clause?

0 Answers  


Categories