How do you resize a data file?

Question Posted / guest

2 Answers
14200 Views
I also Faced
E-Mail Answers

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

when does an alert gets signaled?

0 Answers Oracle,

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

Explain an ORA-01555

2 Answers

What the different components in replication and what is their use? : sql server DBA

0 Answers

why we use cursors

1 Answers

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?

0 Answers

What is the importance of a recovery model? : sql server DBA

0 Answers

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers Infozech, Wipro,

what r the types of backup?

5 Answers CSC,

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers iGate,

What is dbcc? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here