Reindexing causes the log file to grow approx 1.5 times the size of the database file. Why are you reorganizing AND rebuilding the indexes? Reorganizing is the same as defragging...

Sanjeev,

Two bits of advice for you.

1. Do not use all uppercase. ALL UPPERCASE INDICATES SHOUTING. We don't like being shouted at

2. Show us...

There are WAY TOO many things that could cause slowness. You don't give enough information for us to really help you.

What was happening on the Server?

-were any applications...

1. To use Windows Authentication, the domains must trust each other. That means that the Windows Logins must be able to be authenicated by the domain controller (or wherever the...

You can't view the Transaction Logs in SQL Server without a third-party tool.

The one I see most DBAs suggest/recommend is Lugiment's Log Explorer. However, I do believe you can only...

Who is the database owned by? (In Enterprise Manager, right click on the database, select properties). What permissions do you have on the database?

-SQLBill

Is this a remote server or a SAN drive?

Can you manually ensure that it is connected?

-SQLBill

OOOOOOOOOOOOOOOOOOOOO.....Look at your Log file name extension.

.mdf.ldf

That could be the error right there.........typo's can cause all kinds of problems.

2nd typo is in the E:\scipts....folder name. Shouldn't it be E:\scripts?????

-SQLBill

I would say the same as Shawn, it appears to be a permission issue. How are you running the script? Manually from Query Analzyer or as a job?

Manually from...

Is AWE configured? run sp_configure and look for the AWE row. It should show 0,1,1,1

If it shows 0,1,0,0 then AWE was not configured. Run

sp_configure 'awe', 1

reconfigure with override

If...

Could be a problem with Enterprise Manager. You can reinstall the Client Tools from the install disk (make sure you select ONLY the Client Tools). You will get...

I would suggest trying:

1. change the disk location

or

2. delete the existing backup

Do one of those then re-run the backup to see if the issue is resolved. This may...

Can you post your backup script?

-SQLBill

Why are you dropping the user if you are going to re-add them with the same permissions?

Are they orphaned and you are trying to resolve that? If so, just...

You don't need to set the recovery mode to full to make a full backup. If you aren't doing transaction log backups, set the recovery mode to simple. That...