Vardecimal Storage Format and its implications on Backup/Recovery

re: Vardecimal Storage Format and its implications on Backup/Recovery

rsocol — Thu, 11 Jan 2007 23:12:53 GMT

I understand why it's needed to switch to simple recovery mode when you disable vardecimal storage format. But why is it needed for enabling it ? The log backups would be marked with the new version while vardecimal storage is enabled, so they would not able to be restored on SP1, right ?

Razvan

re: Vardecimal Storage Format and its implications on Backup/Recovery

Sunil Agarwal — Thu, 11 Jan 2007 23:56:19 GMT

RavzanL You are right. It is not needed for enabling. I read my BLOG again and I does not say that. Can you please clarify..

thanks

re: Vardecimal Storage Format and its implications on Backup/Recovery

rsocol — Tue, 16 Jan 2007 14:40:45 GMT

Books Online SP2 Dec CTP says:

"Databases using vardecimal storage format must be set to the simple recovery model."

This is in the "vardecimal storage format" topic (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/b4a37f9c-3b71-43bd-b64e-2bfb5c5817ba.htm), in the "Limitations" section.

If this is an error in the documentation, please make sure that it will be corrected in the next version of BOL.

Razvan

SQL Server 2005 SP2 では、decimal, numeric データ型利用時のディスクスペースが減る !? vardecimal とは.

河端善博の .TEXT でウェブログ — Wed, 07 Feb 2007 15:42:44 GMT

SQL Server 2005 SP2 では、decimal, numeric データ型利用時のディスクスペースが減る !? vardecimal とは.