[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Metadata query failed

Posted on 2007-04-02
7
Medium Priority
?
1,125 Views
Last Modified: 2012-05-05
I am running SQL 2005 on 2 seperate servers.  I am attempting to do a Snapshot replication from Server A which is setup as a publisher and distributor.  Server A is suppose to pushe the subscription to server B.  When attempting to create the intial snapshot I recive and error that reads metadata query failed.  Any help would be appreciated.
0
Comment
Question by:Steve_Rogers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 18841951
Try creating two snapshots with different set of tables. and apply service pact 1 on both server if not there. also check that the user by which your sql agent is running and mssql service is running is same.
0
 

Author Comment

by:Steve_Rogers
ID: 18842945
I have tried creating a snapshot of individual tables including a few of the tables that the snapshot hsa blown up on before and it creates fine.  The server is currently running MS SQL 2005 sp2 so I am already past service pack 1.  The agent and service are both running using an SQL service account set up in AD.
0
 

Author Comment

by:Steve_Rogers
ID: 18843773
Below is an export from the error log, i am hoping that the additional detail will help.


04/03/2007 10:49:11,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,2,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Run agent.,,2007-04-03 14:49:21.41 Source: Replication<nl/>2007-04-03 14:49:21.41 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.41 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.41 Message Code: 0<nl/>2007-04-03 14:49:21.41  <nl/>2007-04-03 14:49:21.41 [88%] The replication agent had encountered an exception.<nl/>2007-04-03 14:49:21.41 Source: Replication<nl/>2007-04-03 14:49:21.41 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.41 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.41 Message Code: 0<nl/>2007-04-03 14:49:21.41  <nl/>2007-04-03 14:49:21.47 [88%] The replication agent had encountered an exception.<nl/>2007-04-03 14:49:21.47 Source: Replication<nl/>2007-04-03 14:49:21.47 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.47 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.47 Message Code: 0<nl/>2007-04-03 14:49:21.47,00:00:15,0,0,,,,0
04/03/2007 10:49:11,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,2,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Run agent.,,The replication agent has been successfully started. See the Replication Monitor for more information.,00:00:00,0,0,,,,0
04/03/2007 10:49:10,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,1,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Snapshot Agent startup message.,,Executed as user: BEACHSYS\rtw. The step succeeded.,00:00:01,0,0,,,,0
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 28

Expert Comment

by:imran_fast
ID: 18849211
Ok the user by which the services are running should be Administrator on the Machine and should have sysadmin access on sql server.
0
 

Author Comment

by:Steve_Rogers
ID: 18850497
Issue has been resolved had nothing to do with users.  Found problem to be binary data fields within fields.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22527512
PAQed with points refunded (125)

Computer101
EE Admin
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question