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 |
Give the stages of instance startup to a usable state where normal users may access it.
what is ora 600?
What command would you use to encrypt a PL/SQL application?
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what is the difference between off-line back up and on-line back up in ibm db2 udb?
When a user process fails, what background process cleans up after it?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is incremental checkpoint?
What the different topologies in which replication can be configured? : sql server DBA