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 is the difference between online backup & offline backup?

3 Answers   CSC,

---

Explain an ORA-01555

2 Answers  

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

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

0 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

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 do you understand by fine-grained auditing?

0 Answers   Oracle,

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---