May 27, 2002 at 5:52 am
Following error-messages come up when I restore a replicated (publisher) db
from sql7 sp2 to sql2k sp2 :
Processed 117944 pages for database 'DPublisherDb', file 'Dalzdotcom_Data'
on file 1.
Processed 61744 pages for database 'DPublisherDb', file 'Dalzdotcom_Data_2'
on file 1.
Processed 1 pages for database 'DPublisherDb', file 'Dalzdotcom_Log' on file
1.
Converting database 'DPublisherDb' from version 515 to the current version
539.
Database 'DPublisherDb' running the upgrade step from version 515 to version
524.
Database 'DPublisherDb' running the upgrade step from version 524 to version
525.
Database 'DPublisherDb' running the upgrade step from version 525 to version
526.
Database 'DPublisherDb' running the upgrade step from version 526 to version
527.
Database 'DPublisherDb' running the upgrade step from version 527 to version
528.
Database 'DPublisherDb' running the upgrade step from version 528 to version
529.
Database 'DPublisherDb' running the upgrade step from version 529 to version
530.
Database 'DPublisherDb' running the upgrade step from version 530 to version
531.
Database 'DPublisherDb' running the upgrade step from version 531 to version
532.
Database 'DPublisherDb' running the upgrade step from version 532 to version
533.
Database 'DPublisherDb' running the upgrade step from version 533 to version
534.
Database 'DPublisherDb' running the upgrade step from version 534 to version
535.
Database 'DPublisherDb' running the upgrade step from version 535 to version
536.
Database 'DPublisherDb' running the upgrade step from version 536 to version
537.
Database 'DPublisherDb' running the upgrade step from version 537 to version
538.
Database 'DPublisherDb' running the upgrade step from version 538 to version
539.
To achieve optimal performance, update all statistics on the 'DPublisherDb'
database by running sp_updatestats.
Server: Msg 207, Level 16, State 3, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'excluded_cols'.
Server: Msg 207, Level 16, State 3, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'excluded_col_count'.
Server: Msg 207, Level 16, State 1, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'vertical_partition'.
Server: Msg 207, Level 16, State 1, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'identity_support'.
Server: Msg 207, Level 16, State 1, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'destination_owner'.
Server: Msg 207, Level 16, State 1, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'verify_resolver_signature'.
Server: Msg 207, Level 16, State 1, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'allow_interactive_resolver'.
Server: Msg 207, Level 16, State 1, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'fast_multicol_updateproc'.
Server: Msg 207, Level 16, State 1, Procedure sysmergeextendedarticlesview,
Line 3
Invalid column name 'check_permissions'.
Server: Msg 3165, Level 16, State 1, Line 1
Could not adjust the replication state of database 'DPublisherDb'. The
database was successfully restored, however its replication state is
indeterminate. See the Troubleshooting Replication section in SQL Server
Books Online.
RESTORE DATABASE successfully processed 179689 pages in 280.987 seconds
(5.238 MB/sec).
Where should I find this "Procedure sysmergeextendedarticlesview" ?
Jobi
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 27, 2002 at 6:22 am
I don't see it anywhere, possibly its undocumented and resides in a dll? Or just code that exists within the restore code.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply