ALTER DATABASE MyDB MODIFY FILE (NAME = PrimaryData, NEWNAME = MyDB );

ALTER DATABASE MyDB MODIFY FILE (NAME = PrimaryData_log, NEWNAME = MyDB _log);

GO

ALTER DATABASE MyDB SET OFFLINE;

GO

-- Physically move the file to a new location.

-- In the following statement, modify the path specified in FILENAME to

-- the new location of the file on your server.

ALTER DATABASE MyDB

MODIFY FILE ( NAME = MyDB_log,

FILENAME = 'F:\MSSQL.1\MSSQL\Data\MyDB _Log.ldf');

GO

ALTER DATABASE MyDB

MODIFY FILE ( NAME = MyDB,

FILENAME = 'F:\MSSQL.1\MSSQL\Data\MyDB.mdf');

GO

ALTER DATABASE MyDB SET ONLINE;

GO

--Verify the new location.

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N'MyDB')

--AND type_desc = N'LOG';

OK...above is the revamped code. At the end, where I verify the new location, it says it is moved to the F: drive!! Wussupwifdat!!

I am erroring out all over...says the files don't exist....until the end, and they show up in sys.master_files!