Interested to Buy Any Domain ? << Click Here >> for more details...
If we shrink the Databse and Files, how much size is
decreased?
- 1 Answers
- 3757 Views
- TCS, I also Faced
- E-Mail Answers
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 execute the cursor queries with "open" statements?
Why transaction is important?
How to provide default values to stored procedure parameters?
Detail about the hardware which is supported by SQL server?
How do I trace a query in sql server?
How to use the inserted and deleted pseudo tables?
List the advantages of using stored procedures?
Difference between uniqe index and uniqe constraint?
What is difference between inner join and join?
What are the different normalization forms?
How to create a ddl trigger using "create trigger" statements?
How to use values from other tables in update statements in ms sql server?
How adventureworkslt tables are related?
What is the stuff and how does it differ from the replace function?
Can we install sql server 2016 on windows 7?
