Thanks for all your responses.

Yes, the users and managers are aware of this problem. Unfortunately, the company cannot afford more storage other than the 2TB they buy every 3 months...

Thanks.

We can't run a full weekly backup because we don't have enough storage for the gigantic backup file, besides, when it was just 10TB we tried to run it and...

Thanks GSquared. The script is useful but what what I need is to force the provider to be OLEDB and not SQL native client... do you know what is the...

I changed my database recovery mode to simple and I see a better performance in I/O and memory utilization. Some of my processes are 50% faster.

Jeffrey,

I just checked and yes, AWE is enabled, but I don't see the /PAE switch in the boot.ini

how can I add that and how it would benefit the memory utilization?

Thanks

Jeffrey,

I am new in SQL server, can you explain a little bit AWE and point where can I check if it is enabled?

Thanks!.

Thanks for your responses.

Since I delete the transaction log backup files every 2 hours (because of lack of storage capacity), I can't restore to a point in time, so I...

I delete the transacton log backups after 2 hours because we don't have the storage capacity.

So, the recovey mode has nothing to do with performance?, I thought that when...

I found some information on how to do this and it is way too complicated for a large database with 80 filegroups (and growing!). So I think I will create...

Actually, we are setting up a disaster recovery site, so I need to restore the filegroups from tape backups, assuming the production database is down. Also, some of the tables...

How can I do that?