This is a new error associated to BACKUP related issues and to be specific first time on this environment. There was no setting of BACKUP COMPRESSION enabled on the SQL 2008 instance which is used by a 24/7 application, by default after the installation backup compression is off. The default behavior...
Posted to
SQLMaster
by
Satya Jayanty
on
10-11-2010
Filed under:
Filed under: best practices, dba, #SQL Server, #DBA, #TSQL, BRH, compatibility, sql server 2008, execution, enterprise edition, backup, sp_configure, compression
Excepts from a conversation between Sumit and Leena, that I overheard last week. Don’t know who they are?? Never mind, I will introduce them later! Leena : “Sumit, I am playing with the FILESTREAM access level and I am bit confused as I am getting a ‘3’ while querying!” Sumit : “I warned you not to play...