SQL7 / SQL2000 compatibility

[Saravan Paramashivan]

I have table with about 2 million rows. Everyday about 18000 rows are inserted. The table contain events for site security system so archiving is neccessary. I would appreicate any help or ideas. Thanks in advance.

[axel]

Hi,

I made devlopment with SQL7

I installed SQL2000

I hoped that my databases converted in SQL2000 can work with SQL7 on an other station
after doing

exec sp_dbcmptlevel 'ilgadmin',70
exec sp_dbcmptlevel 'webmine',70

It can't work !!!

Is there a solution on this way ????? An other option that I missed ?????

Thanks to your answers

Best regards

Axel

Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:logmetrixaseintellilogwebminewebmine_Log.L DF' is not a valid database file header. The PageAudit property is incorrect.
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:logmetrixaseintellilogilgadminilgadmin_Log .LDF' is not a valid database file header. The PageAudit property is incorrect.

[paul]

can't be done. sql2k was quite a re-write and uses different file structures


------------
axel at 3/26/01 5:02:32 AM

Hi,

I made devlopment with SQL7

I installed SQL2000

I hoped that my databases converted in SQL2000 can work with SQL7 on an other station
after doing

exec sp_dbcmptlevel 'ilgadmin',70
exec sp_dbcmptlevel 'webmine',70

It can't work !!!

Is there a solution on this way ????? An other option that I missed ?????

Thanks to your answers

Best regards

Axel

Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:logmetrixaseintellilogwebminewebmine_Log.L DF' is not a valid database file header. The PageAudit property is incorrect.
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:logmetrixaseintellilogilgadminilgadmin_Log .LDF' is not a valid database file header. The PageAudit property is incorrect.