As I think you are already aware - there was an issue with the autogrow setting being converted to a very large number. If you have already patched beyond...

So, was that the problem and is it now resolved? Or, are you still having the issue?

Who recommended truncating the transaction log?

Are you performing regular and frequent transaction log backups? If not, why are you running in full recovery model?

Once you issued that command, you...

To add to what Gail has asked, I also ask why you want to shrink your database. If this is because of some unusual activity, don't use SHRINKDATABASE -...

Check the properties of the database and see if the database is set to auto close. Also, check to see if it is set to auto shrink. If...

iqtedar (12/16/2009)

---

thanks everyone for the reply. I have two instances running on it and i have set 2 and 16 gb min/max for one and 2 and 8 gb min/max...

If you are limited on space, I would be very careful with creating multiple database snapshots. Remember, each snapshot stores the changes in the database since the snapshot was...

Go to the Maintenance Plan folder, open the folder and find the maintenance plan. Right-click on that plan and select View History.

In that viewer - find the job that...

I have seen these kinds of issues when the connection information is different from what SSMS is using. You end up with multiple plans in cache - one for...

How to do what? Create a new SSIS project in BIDS and Add Existing items to the project. When...

They are not stored in the file system - maintenance plans are stored in MSDB. You can...

It is all true, except for running maintenance plans which are really just specialized SSIS packages. Maintenance plans as of SP2 (I believe it was this, could have been...

The easiest and most efficient method would be to recreate the maintenance plan. It can't be that hard to recreate - and you could have been done with it...

Just to make sure you understand - the service pack shuts down and restarts services as it is upgrading to the newer version. Even if you get away with...

I don't think there will be any issues with that configuration - since the OS's are comparable. All database mirroring is concerned about is the version of SQL Server...