What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

Explain the concept of the DUAL table.

3 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  

---

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

4 Answers   Wipro,

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

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

0 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---