I have a need to copy a database from one SQL Server instance to another and to this end I use the SMO Transfer.TransferData object/method.
This has always worked OK against SQL Server 2008 but I have just tried it against my new SQL 2008 R2 server and I get an error saying that the .mdf file for my database could not be found - the path listed is correct, accessible and the file exists.
I am just trying to go back and re-install the standard SQL Server 2008 to see if I can still get it to work with that version.
Do you need an updated version of the SMO DLL for this to work with 2008 R2 and if so would it niot have been installed as part of 2008 R2?
If I build against this SMO library will I still be able to work with a 2005/2008 database server as I do not know what database my clients will use - I support 2005 on.