Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the system database in sql server 2008?

1097


Explain indexed views and partitioned view with their syntax.

1195


How do we synchronize On-Premise SQL server with SQL Azure?

124


ow to bring suspect mode datbase online from scratch

1859


What do you understand by triggers?

979


What is standby servers? Explain types of standby servers.

1058


Can sql servers link to other servers?

1141


How do you improve the performance of a SQL Azure Database?

137


Explain activity monitors

1132


What function does a database engine serve in the sql server?

1083


Will the writetext statement activate a trigger?

1156


what purpose does the model database serve? : Sql server database administration

1028


What is merge replication?

1151


what are cursors? : Sql server database administration

1106


Can multiple columns be used in sql group by clause in ms sql server?

1119