Que and Ans - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Que and Ans

Author

Topic

shubhada
Posting Yak Master

117 Posts

Posted - 2007-04-16 : 04:15:15

1. what will happen when .mdf and .ldf file of any database is deleted ?

2. what will happen when only .ldf file of any database is deleted ?

3. how I can see the contain of any log file?

4. what are the daily task of any SQL server DBA?

5. I have two database one at offshore and 2nd is at onsite.
How I can synch these two database using internet?

6. what is replication ? purpose of replication?
how you will synch the replic database with the original database?

Plz tell me the answer of the above questions.

SQLTeam

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-16 : 04:23:41

Preparing for an interview, I guess!!

1. The DBA gets fired !

2. The DBA gets final warning but manages to keep his job

3. There are some third-party tools available plus you can use undocumented DBCC LOG command

4. Keeping an eye on nutty users, participating in geeky forums, writing blogs about how their smart strategies saved company's million dollars etc.

5. using internet? why?

6. Don't you know that already???

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-16 : 04:37:53

Can you even delete mdf and ldf files while sql server service is running?

Peter Larsson
Helsingborg, Sweden

shubhada
Posting Yak Master

117 Posts

Posted - 2007-04-16 : 05:17:17

these are some interview question.

for 1 que, I think it is not possible to delete .mdf and .ldf file. is it correct?

one more question what will happen in the following scenoria
suppose my SQL server is not running and I deleted .ldf file for one database.
what will happen when Server will up?????

SQLTeam

shubhada
Posting Yak Master

117 Posts

Posted - 2007-04-16 : 05:23:49

8. I have one table as follow
col1 col2
----- -----------
A 10
A 15
B 15
B 5
C 25
D 2

I want the record those have the aggregates greater than 20

SQLTeam

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-16 : 05:33:57

Post expected output, please!

Let me give you a hint: Use GROUP BY with SUM() and HAVING clause. Sufficient I guess.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources