Answer Posted / hemant shrimali (dba)

alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;

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

1106

---

how can you schedule a job in database?

1103

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3401

---

how can you initialize log miner?

1135

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1192

---

How would you go about verifying the network name that the local_listener is currently using?

3207

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1928

---

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

1094

---

What are the different sql server versions you have worked on? : sql server DBA

1007

---

What authentication modes does sql server support? : sql server DBA

1203

---

What is dcl? : sql server DBA

1253

---

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

1055

---

what is the use of recording information about current session?

1046

---

what is the use of ocr?

1025

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2056

---