Not sure if changing the recovery model of the database to bulk logged would help in any way, as you are shipping the logs, but if the reindex job finishes...

Why would you want to free up space by getting rid of data? As there are processes running on the database that need space to run

Thanks!!

Well, we have decided not to put the actual video into the database, as we want to have control over the amount of data that actually goes into the database....

Database Mail process shuts itself down after a certain period of inactivity. The default value is 10 minutes, which can be changed via Database Mail Configuration Wizard (can be found...

Right click on you server, click on properties and go to the security tab. You can change the authentication mode here. You would require to restart SQL server for this...

Yes- I do believe I need to catchup a lot :hehe: with the encryption feature on SQL. I think this is the right time I do it.

Thanks Gail...

Gail: what if I were to encrypt a single column on request from one of our clients..

1.How is the process supposed to work?

2.How would the process of querying the table...

For 1$ I could give you an advice..set up jobs that alert you with disk space or any errors reporting in the errorlog.

We use an application like 'appmonitor' that queries...

check the error logs..look in Database Mail folder of the error logs. Lets see what you find..

Thanks!

2008-12-07 02:57:08.74 spid57 SQL Server has encountered 398 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\xyz\efg_NDX\efgNDX2.NDF] in database [xyz] (8). ...

I don't see any suggestions yet, is there a separate section on this site to discuss Clustering or any other site you people know of that would help me find...

We use a general domain\OurNameSQLServer account with SysAdmin privilege...

Yes, I restore to a point in time before the update..Thanks!!

Guess what my server admin tried installing it on our production env and the updates failed. When he brought it to my knowledge I researched on it to find out...

Helps posting links..:hehe:

http://support.microsoft.com/KB/948110