I’ve recently been moving servers and when I moved the databases, I was unable to re-attach them with a different path for the filestream folder. Â The following blog post has a solution -
Posts Tagged ‘2008’
Re-attaching SQL Server 2008 databases with Filestreams in a different path
Wednesday, July 7th, 2010SQL Management Studio 2008 Import/Export Data (Replacement for DTS)
Wednesday, July 1st, 2009The old SQL Enterprise Manager used to have something called Data Transfer Services, which allowed you to transfer data between SQL Server and a different database using ODBC. Â This was curiously lacking in SQL Server Management Studio 2005 (at least the Express one) unless I missed it.
However, in the 2008 version, you can right click on a database, select All Tasks and there are options for Import Data and Export Data, which open an appropriate wizard to guide you through the process.