April 1, 2009 at 3:13 pm
I am trying to create a copy of the production DB on a different server to run the Report Server. First I thought I would create a subscription/publish setup to duplicate the DB. That didn't work and when I asked the Support for the application, they said it wasn't possible and it would void all support if I did do it. Next I thought I would do TLog Shipping. It was working until I came across a few views that would not work because of some missing procedures. Some of the missing procedures I found were Extended Stored Procedures in the master DB. I copied them over, but still some views were missing something. So I thought, Hey, I'll copy the DB in order to copy of any Stored Procedures and see if that does the trick, then I'll do TLog Shipping to maintain it. But when I try to Copy Database, I get the following error.
Executed as user: SQLDB-04\SYSTEM. Process is terminated due to StackOverflowException. The return value was unknown. The process exit code was -2147023895. The step failed.
I can't find jack on StackOverflowExceptions, except to contact Miscrosoft Support.
Does anyone here know, or maybe have an alternate solution to setting up a replica of the production DB?
April 1, 2009 at 4:48 pm
What are you trying to copy here? Application DB or master?
Why don't you copy and restore the DB and then carry on from there?
April 2, 2009 at 7:20 am
I am trying to replicate the Application DB, but the application has modifications to the Master DB as well. I have tried to copy, but I keep getting this error:
Executed as user: SQLDB-04\SYSTEM. Process is terminated due to StackOverflowException. The return value was unknown. The process exit code was -2147023895. The step failed.
April 2, 2009 at 9:12 am
you could make a backup of the database then take that back-up to where ever and restore it.
also...
how many tables do you need copied? if it's only a few (and yes i know this is a odd way of doing it) open the table to see the data, hilight it all and dump it into and excel spread sheet and then move it into a new database. I had to do tht in a pinch once to move some data from an express version to an express version, granted it was only some dev's work that they didn't want to lose but they needed a new instance of the database, the excel sheet held the data for me till i was able to put it where the dev needed it.
don't know if either of these would help you.
[font="Comic Sans MS"]Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic[/font]
April 2, 2009 at 9:57 am
The tables I can copy. I start running into problems when I try to copy the views. The views are using udf and uxp procedures and it looks like the uxp files are calling on some dll files that go with the application. The udf files are in the database I am trying to copy. The uxp files are on the master database, but I think I recreated them all. I think my problem lies with the dll files, but that doesn't explain why I cannot use the copy database function.
Anyways, it looks like something for me to tinker with for a while.
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply