Will it not truncate the log files?

Transaction Log Backups should do the trick (assuming database is in FULL recovery model).

@aurato: Thank you very much for posting the link for Jeff's Interview. I owe you.

All@SSC: It’s irrelevant to this thread but can you please provide me pointers for such interviews....

Yup, I missed that part but not entirely. OP didn’t mention it explicitly but it’s a fair assumption and I agree with you.

I probably put myself in his shoes (or...

It could be a hardware issue but my question is still valid. If I query (or backup) on database with images, I shouldn’t expect much performance. OP mentioned he is...

Please read the articles Jason has already suggested. It will guide you on, what you are looking for.

Query on view will hit main database every time. Will it not consume the bandwidth? I believe that’s the main issues here.

Ugly Solution:

•Create a dummy database.

•Create the table that matches with Image_table in your main database.

•Export the data into dummy database.

•Clean the data (Images) in main database.

•Create FULL backups for these...

& the Web resource: http://openlearn.open.ac.uk/mod/oucontent/view.php?id=399373&section=1.2

The system table’s structure remains same irrespective of server edition. The features availability is dependent on the edition (license / key). These are two independent facts.

You should use following syntax for Create Database statement in SS2K5.

CREATE DATABASE database_name

[ ON

[ PRIMARY ]...

Also, Security Measures are based on trust model. If we can’t rely on Administrators (which we shouldn’t) of your application / database then we can’t rely on anyone.

I am aware...

If you are an Everything DBA (Hybrid DBA) then AD management falls in your bucket. I believe AD Management is out-of-scope to DBA roles (in general). However it’s a nice...

If somebody can login to Application Server & read configuration files, he can delete website as well (worst scenario).

SQL Server Logins are manageable for Web Applications. Few logins (Logical Grouping...

Please alter your script with following & let us know the result.

--IF @@ROWCOUNT = 2

IF 1 = 1