Answer / guest

alter databse datafile 'location of datafile' resize 2000M



Regards
Abhinav Phadnis

Answer / monal

in SQL Server 2005:

ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Explain materialized views and how they are used.

0 Answers  

---

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

0 Answers   Oracle,

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

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

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

If CPU is very slow What can u do to speed up?

1 Answers  

---