Sir,

I have a doubt that we have erp for this vendor is
using sql server 7.0 for normal databases and for their
databases database compentence level is 6.5 in this
scenario how the backup will work. In 6.5 database pages
is connected in doubly linked list, but in 7.0 it was with
singly linked list as per the books, in this case how the
architecture will work whether it will use 7.0 version
features or 6.5 features

Report this post to a moderator

The database compatibility level does not affect the physical structure
of the database, it changes available features and behavior.
Consequently, normal SQL 7 backup/recovery procedures can be used
regardless of the compatibility level.


Hope this helps.


Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Rushendra" <mr@amararaja.co.in> wrote in message
news:132ad01c21e8c$2f727480$9b
e62ecf@tkmsftngxa03...
> Sir,
>
> I have a doubt that we have erp for this vendor is
> using sql server 7.0 for normal databases and for their
> databases database compentence level is 6.5 in this
> scenario how the backup will work. In 6.5 database pages
> is connected in doubly linked list, but in 7.0 it was with
> singly linked list as per the books, in this case how the
> architecture will work whether it will use 7.0 version
> features or 6.5 features
>
>

Report this post to a moderator