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...

How do you resize a data file?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2346


How do you trace the traffic hitting a sql server? : sql server DBA

1628


what is the role of dip user in our database?

2461


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

1108


what is the diffrence between core dba and apps dba?

2624


What are the operating modes in which database mirroring runs? : sql server DBA

1238


What is the difference between clustered and non-clustered index? : sql server DBA

1141


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

2042


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2686


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

1934


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2553


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.

1794


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2013


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

1036


What are the different ways you can create databases in sql server? : sql server DBA

1191