Ok good,

But check this situation , I done this and i am facing this problem,

I am having a Database named Database1 . I just created SP's, Tables,Functions ect on it...

Hi The Query provided above is working finely, But i am confused whats going in the query and what's happening there in it?

Can u pls explain me about the query...

Thank u for providing me the code above

Can u pls explain me what the code is going on? and what @sql value i hav to provide to...

HI thank u for u r valuable solution.

Let me know how to Restore a DB using Log transaction files?

Give me a Practical situation and step by step procedure?

Thank's a...

One more Question ,

1)What is the use of Log shipping transaction ?

2)Can we restore a corrupted database by using these log shipping transaction files?

3)Tell me the procedure...

Thank u for u r suggestions ,

Let me know this one ---- Suppose my DB gets corrupted(after taking the backup)? For restoring the database which files i required to have?...

Hi , tahnk u for u r suggestion , but i donno what a Sqllitespeed means, can u tell me about that thing elaborately

thank u

HI Very good options are given by u all as for of the discussion of "How to split one MDF file into two"

Yeah tell me one thing , that how...

Hi asheshad thank u for u valuable answer,

but can u tell me what is the exact meaning of low free, high free also

Thank You ,

Thank you for ur supporting

Let me know that whats the .trn file represents.I hav not seen a file having such type of extention.

HI reddy thanks a lot for u r valuable answers.

My final doubt is --

Which files are required for restore when a DB gets corrupted (means .mdf, .ldf files or only...

Hi Reddy,

Thank u for u r reply.See i am a person who is started learning SQL DBM and...

Hi sreenu,

U hav received the...

venu_ksheerasagaram (4/16/2009)

---

Hi friends

Here...

I am not using the Minatenence plan whizard. I just create a new MP by right click the Maintenance tab and selecting New Maintenence plan tab.

Tell me exactly what "Did...