How do you resize a data file?

Question Posted / guest

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

More DB Administration Interview Questions

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

What would you use to improve performance on an insert statement that places millions of rows into that table?

Oracle 11g new features?

how will you see when the database was started using sql prompt?

What is the difference between dropping a database and taking a database offline? : sql server DBA

You have just compiled a PL/SQL package but got errors, how would you view the errors?

How to determine the service pack currently installed on SQL Server?

when does an alert gets signaled?

what is the use of recording information about current session?

What view would you use to look at the size of a data file?

what is ora 600?

What are the recovery models for a database? : sql server DBA

For more DB Administration Interview Questions Click Here