November 5, 2010 at 9:50 am
Hello,
I am trying to copy a database from a SQL 2005 machine to a SQL 2008 machine, using the copy database wizard. I've configured the credential and the proxy etc but its constantly failing with a log full error. I made a backup of the DB and the logs, shrunk the logs until there was only 50mb of them with another 1.5GB to grow, but its still failing with log full error. I've used the copy database deature loads of time without problem.
What am I not doing or not doing correctly?
Thank you,
D.
November 5, 2010 at 1:52 pm
Two things come to mind. First, make sure you have sufficient disk space on the 2008 server. If you run out of disk space, you will get this error. I would say, free up enough space to be more than twice the size of the 2005 DB and log files combined.
Also, make sure you are sysadmin on the servers. I suppose you might get this error if permissions are not high enough on 2008. I have seen secondary error messages display that are not necessarily the root cause.
November 5, 2010 at 2:30 pm
Do you have the log set to not grow beyond a certain point? I think this wizard has to actually bulk move all data, so that's a lot of log space being used.
November 5, 2010 at 3:12 pm
why are you using the copy database method? Why not backup\restore or detach\attach?
---------------------------------------------------------------------
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply