The only main difference between scale-out deployments and single nodes that pertains to this article is that on the SSL cert, when doing scale out, you either have to make...

I think I can take this one... any requirement on it ? like all in one server, ssrs and core db on different boxes, Scale-out deployments or single server ?

Sounds good ! was thinking on that approach and then another one also (most likely different article ) showing the $$$ associated with both and how/when to choose based on...

On a similar matter, are you interested in an article on when to use a traditional SQL Server (vm in azure) vs SQL Databases in Azure ? I can take...

Hi Eric,

No, I didn't fail over the resources on the last server. That will be handled by the service pack installation process as it will failover automatically the instances, so...

That is completely true, it would have been quicker if I slipstream the service pack into the installation files. I didn't face it that way because not all companies follow...

Hi Seth,

what I use for backup compression is LiteSpeed. It's a 3rd party tool that compress and encrypts the backups pretty good... I've seen SQL backups of 15 GB become...

Hi Nemo,

A simple question but usually helps. Do you have permission on SSRS to deploy reports ?

cheers,

Alejandro

Hi Mark,

can you provide the output of this ?

RESTORE FILELISTONLY FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\DBNAME.BAK'

thanks,

Alejandro

Hi,

I experienced a similar situation, and sadly it went away before I could find the exactly root cause of that. In my case, I've seen this errors using AD accounts....

Hi Prasanna,

All the security of the database is stored on the db itself, so if you restore / attach a database, all the permissions are restored as well. The usual...

Hi Prasanna,

If you're downgrading SQL from Ent to Std, then you must first get a backup of all your DBs (which I assume you have). Then, you can script all...

Hi there,

The service pack has nothing to do with SQL being Ent or Std, but being 32 bit or 64 bit. If you have installed SQL 32 bit, then the...

Hi there,

did you try to perform the backup outside the desktop folder ?

cheers

Hi iain,

If you're running windows XP you can't change the application pool settings on IIS Manager... I think that you'll be able to do that using IIS resource kit and...