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

How would you extract DDL of a table without using a GUI tool?

2446


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2416


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

2141


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3706


What are the different types of database compression introduced in sql server 2008? : sql server DBA

1047


what is logical system in sap basis

1587


Where would you look for errors from the database engine?

2802


what is the role of dip user in our database?

2369


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?

1923


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2407


what is ora 24313?what is the procedure to exclude that error?

2523


How do you troubleshoot errors in a sql server agent job? : sql server DBA

1057


how can you create a user-defined lock?

967


suppose you want to audit specific activities on sensitive data. How can you achieve that?

960


when does an alert gets signaled?

994