How do you resize a data file?
Answers were Sorted based on User's Feedback
Answer / guest
alter databse datafile 'location of datafile' resize 2000M
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / monal
in SQL Server 2005:
ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)
| Is This Answer Correct ? | 9 Yes | 8 No |
when does an alert gets signaled?
What are the steps you will take, if you are tasked with securing an SQL Server?
Explain an ORA-01555
What the different components in replication and what is their use? : sql server DBA
why we use cursors
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the importance of a recovery model? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
i had backup last manday.now i need back monday to now ..how do get backup?
what r the types of backup?
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
What is dbcc? : sql server DBA
Oracle (3253)
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)