Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

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

0 Answers  

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

Give two examples of referential integrity constraints.

2 Answers  

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

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

0 Answers  

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

For more DB Administration Interview Questions Click Here
Categories