1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

How can you enable a trace for a session?

1 Answers  

how can you initialize log miner?

0 Answers   Oracle,

Explain about your sql server dba experience? : sql server DBA

0 Answers  




What would you do with an "in-doubt" distributed transaction?

0 Answers  

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

What type of index should you use on a fact table?

1 Answers  

Oracle 11g new features?

2 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

What the different types of replication and why are they used? : sql server DBA

0 Answers  

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories