I will advise you stick with your current standard server deployment topology which can be enhance overtime when you start looking into seperating interactive report processing from scheduled report...

Absolutely. I am working on a new plan now.

Thanks for your input - really appreciated.

costa,

I am not sure while but somehow this is a part of the maintenance plan in the dmz I inherited in the last few weeks. Basically the db's are set...

Go back to the server properties window. On the general tab page you will see a list of SSAS server properties. At the bottom of the page Select "Show Advanced...

select 'BACKUP LOG ' + @dbname + ' WITH TRUNCATE_ONLY'

exec ('dbcc shrinkdatabase (' + @dbname + ',TRUNCATEONLY)')

SSAS security is based on windows authentication only meaning security can only be assigned to local users and groups and domain users and groups; unlike the SQL Server database engine...

The link below can get you started.

http://msdn.microsoft.com/en-us/library/aa906003(SQL.80).aspx

Thanks

costa

The only solution that I am aware of is transperant data encryption in MSSQL2008. This solution performs real-time i/o encryption and decryption of data and log files. The msdn link...

Thanks Gail.

skhan,

It sounds to me like you need to restore a backup copy of your report server encryption key. Did you backup a copy of the encryption key prior to the...

Great lesson learned...

Thanks Gail, John. Your inputs are very much appreciated.

Thanks,

Yes the instance was restarted, sorry I wasn't clear about that.

Gail,

Thanks.

So you will advise to leave the application offline until the the database is fully recover, correct?

John,

The application is off and you're right because I restarted the service and when it came back online the state is now "recovering". The thing is the application needs to...

Correct. Also please note that you can have more than two occurrances of the ID.