I solved my own problem....sometimes that's the best way.

I realized I had not completed a build/deploy/process on the cube because it was a brand new one. It was saying...

Paul - thanks for clearing that up...I guess I need to do more research before posting 😀

I see now that the transaction log backup performs a truncation of any inactive...

Oh ok....I just assumed it was set to Full since it was a Production system. Thanks for clarifying.

Sounds like you just need to do a transaction log backup which will decrease the size of the log files. Do you have a regularly scheduled transaction log backup...

Great! Glad you figured it out....and thanks for posting your solution.

From BIDS, try going to File menu and choose "Save Copy of Package As" option (there's two Save as options....choose Save Copy". Then you'll get a "Save Copy of...

Gail,

Ok...I was afraid that was the case. Thanks for your help with this...I really appreciate it. I have 3 other dbs that I need to attempt to recover,...

Returns following message....guess its bad then????

Server: Msg 8966, Level 16, State 1, Line 1

Could not read and latch page (1:219) with latch type SH. sysobjects failed.

I was not able to attach the database at all. So I created a blank database with the same name, stopped the service, replaced the blank mdf with my...

Ok...I think I'm not so lucky. I've followed your blog post and have gotten the database into an Emergency State on the server. When I try to view...

Yes...that's how we actually got the mdf and ldf. The server went down and they were able to retrieve the files from the server backups, we just didn't have...

Gila,

Was wondering if you would be able to help with a similar problem with a 2000 db in my post from today:

http://www.sqlservercentral.com/Forums/Topic938934-5-1.aspx

I see the OP never responded with...

Yes, very interesting...thank you. Always good to know whats "really" going on.

Brad - just a couple ideas I have on File System deployment vs. msdb is:

1) I don't really like having packages floating out there on the server - seems...

TerryS - Thats funny! Glad I'm not the only one. That wasn't me in that training but sounds like he was a smart man! 😀