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
How to view existing indexes on an given table using sp_help?
What is the importance of three tier architecture?
Why use triggers?
What is ms sql server index?
How many types of objects are there?
What do you mean by tablesample?
Do you know what are the restrictions that views have to follow?
How to sort the query output with order by clauses in ms sql server?
what is the primary use of the model database? : Sql server administration
How to list all columns in a table using odbc_columns()?
What are the main sources of data?
How to verify a user name with sqlcmd tool?
What is model database in sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What are the advantages of partitioning?