How do you resize a data file?

Answers were Sorted based on User's Feedback



How do you resize a data file?..

Answer / guest

alter databse datafile 'location of datafile' resize 2000M



Regards
Abhinav Phadnis

Is This Answer Correct ?    13 Yes 3 No

How do you resize a data file?..

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

Post New Answer

More DB Administration Interview Questions

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


what is ora 600?

1 Answers  


What command would you use to encrypt a PL/SQL application?

1 Answers  


how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  






What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  


what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,


When a user process fails, what background process cleans up after it?

1 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


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?

0 Answers   HSBC,


what is incremental checkpoint?

1 Answers   CTS,


What the different topologies in which replication can be configured? : sql server DBA

0 Answers  


Categories