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 |
What are commonly used mssql functions in php?
What is database replication?
how to get the salary in descending order with out using the keyword desc in sql
what is datawarehouse?
How network traffic be reduced by using the stored procedure?
what is the importence of the trigger in sqlserver2000?
What is the purpose of sql profiler in sql server?
Normalization and denormalization
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What is “asynchronous” communication in sql server service broker?
What does the on update no action do?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)