pmadhavapeddi22 (6/17/2014)

---

Hi,

I have tried taking the backup with the following t-sql commands

case I

-----------------------------------------------------

backup database XTEST_DB to disk

='c:\XTEST_DB.bak' with compression

backup database XTEST_DB to disk

='c:\XTEST_DB.bak'

-----------------------------------------------------

Both the backups are successful. first backup is with compression and next one is normal backup, both existed in the same media set.

but when I use like the below ,

case II (like the QOTD order)

-----------------------------------------------------

backup database XTEST_DB to disk

='c:\XTEST_DB.bak'

backup database XTEST_DB to disk

='c:\XTEST_DB.bak' with compression

-----------------------------------------------------

Then I am getting the error that both cannot co-exist

My question is , if both cannot co-exist, second case also should fail , why the first case is successful and where as the second one is not ?