Hi,

What is the easiest way to move
a database (data files and log files) from
one location to another (same server)
for SQL Server 2008.

Thanks in advance

bob123 (bob123 (AT) gmail (DOT) com) writes:
ALTER DATABASE MOFIDY FILE.

See Books Online for details.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

OK thanks

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> a écrit dans le message de news:
Xns9D2CC632151C2Yazorman (AT) 127 (DOT) 0.0.1...

Hi

You can detach the database and simply copy the mdf, ldf files to a the new
server

"bob123" <bob123 (AT) gmail (DOT) com> wrote