Hi Everyone,

I bought LiteSpeed Backup, I am using it for SQL 2000 Server. Interesting thing is some function are similar with SQL 2005 maintenance plan.

However, let me get to the...

Hi Gila,

According from 'dbcc checkdb (dbname) with no_infomsgs.' , you said run

that command before backup run. But my questions is, what do we do if I already setup a job...

Hi Terry and Jack,

So, what I need to do? Just run xpstmp.txt in SQL 2000 query analyser? What does it do?

Leo

Hi Jack,

I am getting 'xp_sendmail : Either there is no default mail client or the current mail client cannot fulfill the messaging request ....'

I think I haven't installed outlook where...

Hi Jack,

Do I need to supply run_date and run_time?

Leo

Hi Jack,

Thanks. What a good one.

Leo

Hi Gila,

Thanks for helping me out. As you said -

***Run checkDB with no options to check the database for corruption. If you do have corruption it's better to restore from...

Hi Gila,

Have you got a code for Index Rebuild with full scan? I am using SQL 2000.

Thanks.

Alan and Steve,

What do you mean? -

*** Also, if you are running in simple mode, you can't easily recover your database except from the last full backup. If you lost...

Hi Lynn and Jack,

So I shouldn't shrink or backup log ..... with tuncate_only for my Databases :w00t: . 35GB for Data and 20GB for Log when I look at the...

Hi Guys,

Sorry, I want to understand something clearly about shrinking the backup log.

What is difference between -

right clk db ,select tasks--> shrink--> their select Log

AND

Backup Log with...

Hi Tandy,

As rbarryyoung explained, you need to make sure you have a separate index on every column that you can search on.

I have change something in your code, Please give...

That explained all..............

Thank you.

Leo

Hi Michael,

I have the same situation, My Senior DBA told me that he use WITH (NOLOCK) on every query in Store Procedure and he said that for the better performance.

Why...

Thank You.