@ sujeet

Run this query against your database and see the results. The UsedSpaceMB will give you an idea as how much will be the .bak file too (they should be...

@ chris

Checking integrity and updating stats should be done after the shrinking of the database.

Regards,

Sushant

@ sais

As san droid said, backing up the db might affect the shrinking too...

The script which you should run to shrink the mdf files :-

USE dbname

GO

DBCC SHRINKDATABASE(N'dbname', 10, TRUNCATEONLY)

DBCC SHRINKDATABASE(N'dbname',...

@ sais

How much free space does your mdf file contain?

Shrinking is not a good method as the database is not read only and so again it will increase,

If you...

@ john

create a maintenance plan task with just a maintenance cleanup task.

In that,

select delete files of following types:-

maintenance plan text reports

File location:-

search folder and delete files based on...

Did it run now or not?

You may be running this every month, but usually it got run under 600 secs (10 mins) but now, maybe due to more data or...

change it to 0 and then again run the stored proc

Regards,

Sushant

which sql server version are you running?

@ harita

You need to increase the remote query timeout option in SSMS

SSMS-->prop-->connections-->remote qery timeout--> wats the value??

Regards,

Sushant

@ harita

When do you get this error, while running a proc?

Can you check if your sql services are running?

Or see errors in sql logs?

Regards,

Sushant

@ t loganatham

What is the recovery model for the database?

What was the last time you perfomed a backup of your transaction logs.?

Regards,

Sushant

@subbbkarth

As gail said, use this script to know which indexes need rebuilding, and perform on them only.

use database

GO

SELECT a.index_id, name, avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(), OBJECT_ID(N'Production.Product'),

NULL, NULL,...

@ sais

Which is hte recovery model for your database and also

did you perform any maintenance jobs before your file sizes again increase?

When was the last time you perfomed a backup...

I checked the output of that query;

In the name column, it says dbname.mdf

but in the physical name column, it says c:\dbname.bak

How did it happen automatically, it changed from .mdf...

where are you backing up the database --locally or across a network?

Are you backing up when there is no/less users on the database?

You can back up using a 3rd party...