Yep!!! I only use maintenance plan every month. But my space isn't enough.

I don't have budget to buy the new one. Please advise if i need to reduce sizing every...

Thanks for your advice.

My meta-data size (.mdf) is 93.7 GB and log file (.ldf) is 30 GB. When i imported many images in sql per week. I have log file...

Many thanks for your advice. It's perfect solution.

Error :

[SQL Native Client]Named Pipes Provider: Could not open a connection

to SQL Server [2].

[SQL Native Client]Login timeout expired

[SQL Native Client]An error has occurred while establishing a

connection to the server....

Can you give me an example code as follow as my code!!! Thanks.

Thanks for your reply.

I debug step by step and then i found as below.

1. use DM_SCNYLDMS03_docbase ==> pass

2. IF OBJECT_ID ('auditrec', 'view') IS NOT NULL DROP VIEW auditrec ...