Hi All,

I created a job from right click database-all tasks-backup database and it works. So maybe there is a bug in the maintenance plan. Can anyone explain it?...

Hi All,

Thanks for your reply.

It is on local server disk. I checked the permissionfor both sql server services and agent, even diak permission. My user name is...

Thanks a lot, I find out the version.

Robert

Thanks for your response.

The table only has two columns. I set data type as char. the text file in fact is numbers. I use DTS to transfer.

The table has about...

Thanks for your response.

The table only has two columns. I set data type as char. the text file in fact is numbers. I use DTS to transfer.

The table has about...

My DB is in full recovery mode. For some reason(say after optimizing) the trans log file grows too large, there is no romm to do transaction log backup, so I...

I am sorry, when I query I forgot ''.

Now it's no problem. It's really a funny mistake. Thank you as well.

Robert

Long time ago I rebuilt indexes on largest table with filfactor 80%. Now I run optimizing every Sunday morning with 20% free space checked. But after optimizing the .mdf...

Allen and Greg,

Thank you guys very much.

These scripts all work! Great!!

Robert

Try to run:

Restore database 'dbname' with recovery

from QA

Robert

Thanks for all your response.

1. The coming weekend I will launch a profiler.

2.Before, Monday morning first I should delete some files to release some disk spaces. Then I did...

To my knowledge, the .ldf grows so big is

normal. It could be 1.2 times database size.

but I can't understand why the .mdf file grows so large.

Another basic question: For...

Those are .mdf and .ldf files. The .mdf file is allocared so big with 35 GB free.

I back up database when the backup completed then delete old backup so only...

No.

Only thing I didn't mention is during the optimizing process our sys admin is doing veritas backup. because the transaction log file is full, so the veritas backup is failed.

I...

If you create maintenance plan from EM, you might selected integrity check, then selected include indexes and attempt to repair any minor problems. Repairing need database in sigle user mode....