Hi,

There is a default trace available You can use the sys.traces table to see the max file size and no of file allowed before recycling of error logs using the...

Hi

Can you try creating a DTS/SSIS package to transfer the data from your source server to destination? And schedule the package in an agent job to run every hour...

Alan you are Most welcome!!... Many a times when copying a data from Excel or flat files, Its the datatype mismatch issue which bothers us the most... Good Day..!!

To view the Sql Server Error Logs, go to Sql Server Agent Node in SSMS object Explorer and expand it -> Expand the Error Logs node -> Double click "Current"...

Hi,

Do you get any errors while the import is going on or it just gets hanged?

Also, can you try running the Profiler while you are performing this task and check...

Dear Sir,

I am facing the same issue but the scenario in my case is that I have detached a few databases and My Full BAckup maintenance Plan has specific databases...