How do you resize a data file?
Answers were Sorted based on User's Feedback
Answer / guest
alter databse datafile 'location of datafile' resize 2000M
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 13 Yes | 3 No |
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 |
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
I lost one datafile i dont have backup how can you recover that???
Explain materialized views and how they are used.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
which background process invoke at the time of upgradation tell me???
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is the difference between online backup & offline backup?
What questions might be they ask in managerial round in capgemini.
Explain about your sql server dba experience? : sql server DBA
How do you open a cluster administrator? : sql server DBA
now one user in online.now i want drop him..how do u drop him?
If CPU is very slow What can u do to speed up?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)