Yes sir!! During the night, I thought about writing a query within TFS and see if I can pull out all the info I have on deployments....see if I...

You are on the money!! We have lowside and highside servers. We have database code and app code. We have modules for db/app. He wants to...

Thank you Randy!!!!! Especially for your SPEEDY reply!!

What was your fix on this?? I have a build server that is schema only. I just tried to back it up and got a message that...

Thank you Dan!! Off I go to read.....

I can hear the gears turning!!!!

Me as well Perry, I re-read what you told me. I just didn't get the MANUALLY MOVE/DELETE part...I was thinking this script would do it for me! My...

OK...breaking down the script into sections worked. I modified the name, took DB offline, changed path of the files, moved the files, brought DB back online, checked for proper...

Gotcha!! Ok, that is next!! Revamp code again, re run and move files.....CHECK!!

Thank you Lynn!!

OK Lynn, restored all back to original....and the database opens fine!!

Lynn....no, I haven't manually moved the files. I was hoping to be able to do it by script, as it has to be done on several servers. I...

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...

Thank you for the suggestion. I will switch things up and hit it again. Yes, the F: drive is where all my data files are, it is those...

OOPS!! Obviously didn't look at the date. You are correct.....

Greengiant....is there some special knowledge I need to move data from a table in a db to an xls?? I get conversion errors and it won't work. Can't...