george sibbald (2/4/2013)
my preferred method would be the alter database commandALTER DATABASE yourdb
(
NAME = logicalfilename,
FILENAME = N'c:\t1dat2.mdf' --for example
);
then offline the database, actually rename the physical file and online the database again.
take a backup first whatever way you do it!
(backup\restore with move is in fact another option)
If this is a SQL 2008 database server, I'd go that route too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events