USE master

ALTER DATABASE myDatabase SET offline

ALTER DATABASE myDatabase MODIFY FILE (name=myDB_filename, FILENAME='X:\New_Path\myDatabase.mdf')

ALTER DATABASE myDatabase MODIFY FILE (name=myDB_logname, FILENAME='X:\New_Path\myDatabase_log.ldf')

** Physically move the files at this point to their new locations specified...

Arrg ... so simple! Thanks - that's perfect.

I was having a very similar problem importing csv files into SQL 2008 R2 through SSIS from a fileshare accessed by a UNC path.

The package worked perfectly from BIDS and...

Hi guys ...

When it says the snapshot has been marked as inactive, it's because the snapshot needs to run on it's own schedule in the background (and seems to ignore...