January 6, 2009 at 4:20 am
Hi,
I am working on Copy Database Using Wizard, I am getting an error, if we write the error into a logfile.txt , i am not able to findout the exact error. in fact the DB gets created but neither of the objects like Table, Sps and other information is not getting created.
So please help in this.
I have a doubt while configuring or seting up CopyDatabase Wizard Should all the Servers be under a single domain and the SQL Server agents should be running under a single account.
With Regards
Dakshina Murthy
January 6, 2009 at 7:17 am
Could you provide the contents of the log?
January 6, 2009 at 9:24 pm
Hi ,
Here i am attaching the errorlog, pls do help me
January 7, 2009 at 12:44 am
Can you verify if all the steps were correctly followed while copying the database. Like the wizard shows the objects that needs to be copied like:Logins\Stored procedure\jobs\packages etc.
You have to further check the properties of each and make sure you select the required options, eg: recreate an object if exists or overwrite it or else to skip the errors, etc.
As you say that there are no objects visible, I suggest you to copy the database once again and cross check the above options.
Else if you are not very particular about the method you use to copy the database, I would suggest to use Import\Export wizard for the same, which is pretty simple.
January 7, 2009 at 5:51 am
Your problem appears to be right here
failed with the following error: "Could not find server 'ErrorLog' in sysservers.
It looks like you have a stored procedure called "GenerateErrorHandling" which utilizes a linkedserver called "ErrorLog".
Try creating that linkedserver on the server that you are trying to copy the database to, and see if that works.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply