Craig,

I have been working for a financial company for over 10 years as a system analyst. During those years I have managed many SQL server both in production and dev...

Thank you. The thing is that it is not the problem with transaction log but db file. We use simple recovery

Yan

It is physical hardware, not vmware. I know that they use legado to backup everything. They may also image the server, well, I don't know how frequently.

Thank you guys.. That company is a big company.

Yan

Hi Sameer Raval,

Thank you for the help, I will look the article.  I also believe that something wrong with the file because I had a problem to transfer the file, it...

Thank you.  I tried that. 

May be something wrong with the file itself. There was a problem during the transfer over the server.

By the way, we got the new controller,...

Hi Screejith,

I copied the back up file to the local server, and the path in sql is correct. as below:

Restore database imagedb1

from disk = 'D:\DATA\MSSQL\BACKUP\imagedb1.bak'

with recovery, replace, nounload,

move 'imagedb1_data' to...

Hi Remi:

I double checked the time of the jobs:  optmizations: run at 1:00 am each Sunday.  Integrity runs at 12:00 am each sunday.

Yan

Hi Remi:

This morning I checked the db size and found out that the free space has been jumped from 4.9g to 6.2g. The data size is hardly changed.   During weekend, only...

Hi Remi:

Thanks, I will.

Yan

Hi Steve:

I do have the "Check Database Integrity" on the Integrity tab checked. 

Thanks

Yan

Hi Steve:

Yes, I do have the "Check Database Integraity" on the Integrity tab.  Thanks

Yan

Remi:

Not that big, I did not record the growth weekly.  It is 8.0g now, last year this time, it was around 6.5g.  The database is kept growing on one hand, and on...

Hi Remi:

Ha...ha..ha..  sorry for the last time, called you the wrong name.

The database auto-grow setting is set to 10% with "unrestricted file growth".

If I only run the shrink job,...

Hi Carpal:

Thank you for giving me the link, I read it through.  However, I don't use "Text" datatype but "varchar", so I don't have to rebuild the tables, right?

The problem...