How to get more information (details) when an error occurs during creation of a tracing database?

An error occurred while attempting to unload the database 'xxx'.
***** SQL error: Syntax error near '' on line 2

How to determine what was really going wrong in the above procedure?

asked 27 Jul '11, 12:09

Martin's gravatar image

Martin
8.8k126163250
accept rate: 14%


You can manually create a tracing database with dbunload -n -k.

-n ensures that no data is loaded into the tracing database (not that it would do any harm, it just consumes needless space) -k populates a table that maps schema objects from between the production and tracing databases

If you run this dbunload, you can dbinit a database and run the reload script yourself to see where the syntax error is being generated.

permanent link

answered 28 Jul '11, 22:14

Dan%20Farrar's gravatar image

Dan Farrar
43143
accept rate: 80%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×12
×11

question asked: 27 Jul '11, 12:09

question was seen: 1,925 times

last updated: 28 Jul '11, 22:14