Thanks for your help. This is not going to be much fun because I have 13 SharePoint dbs and I currently have the full nightly backups and the 9:00am...

Hi George,

Just letting you know the final outcome is that I have the database down to 26 gb now!! I am ecstatic!! And auto shrink is turned off...

I fixed it by manually dropping and recreating the indexes. I thought the following did the same thing.

SET QUOTED_IDENTIFIER ON

exec sp_MSforeachtable

@command1 = "Print '?'",

@command2 = "DBCC DBREINDEX ('?')"

Wouldn't...

Thanks George. I got the table counts and re-indexed the smallest tables (up to 2500 rows) at 95, the next group were tables w\up to 5000 rows at 90...

Thanks for all of your responses.  This is excellent advice that I will implement. 

Also, it's comforting to know that we are not the only b'ass ackwards shop around!!  

Thanks Sugesh, that took care of it!

Here's something to think about if you are going to switch recovery to simple and then back to full.  I had the same idea to get around this problem.  It...

If there are any PeopleSoft databases on your server - beware - the "sa" password is encrypted in each one.

Thanks Norman...............interesting choice I have here.

I will give that a try.

Thanks! 

Another one to check out is the "i3 for Sql Server" product from Veritas. 

You can map the drive where the file you want to restore is (on another box) to the server that is running Enterprise Mgr and restore from that.  Just hope your...