Thanks All,

I got the point , that I should keep the schedule as

On in weekend night Full backup

daily At night deff. backup

And depending on data loss Accepted, log backup(In minuts).

Thaks

muthukkumaran for responce,

May I keep

One Full Backup Weekly at Weekend Night

One Defferential Daily at Night

And Trans.LogBackup On Every one Hrs.

is it OK?

thanks

Thanks Vihsal,

I Answered the Same (Above in quote) but, He...

Hi

Say Hey Kid

Actualy It was typing mistake

I meen 'One Terebite Plus Database,

Thanks

Hi

No, not than one witness in Database miraring. As per my expe.

Thanks

Hi

Thank You Lowell;

for quick response. I got the Clear Answer which is'NOT' thanks!

Hi

I think there is...

amit-1143912 (10/1/2010)

---

I have simple sql query with 8 tables of which 3 tables have 30, 60 and 80 lakhs of records

I have applied inner joins on tables to which 35...

forco02 (10/5/2010)

---

I have a 4 step job defined in SQL Server Agent, all steps are set to "Quit the job reporting failure" and on success "go to next step" each...

Hi

marc, in my openion, just falow Michael Valentine Jones's comment

Hi

Is it a SSIS package schedule. If so check the step next to MSDBLog backup.

hi

Krasavita

Krasavita, Just I want to what is in your mind, are you really want to delete the Database?

Just Fallow the Gail Shaw comment,...

Geoff's above query should work.

Hi

Can you post your's wretten query. You can also use Export wizard.

hi

Paul,

this link may use full for you:

http://msdn.microsoft.com/en-us/library/ms143506.aspx#SE32