How to move the file of a database to other folder | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to move the file of a database to other folder

Hi,<br /> I want to move the log file of a database to other folder,this database has only one filegroup<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />rimary.<br /> Please help me,and show me the code.<br /> <br /><br /> [:I][<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />][}<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]I am new hand,I enjoy lose my face.<br /><br /><br />Jelly is here.
If you want to move the ldf and mdf file then dettach the database, move your files are attatch the database by selecting the mdf file in it’s new location.
Cheers
Shaun World Domination Through Superior Software
This procedure, (sp_attachdb and sp_detachdb) in explained well in the Books Online. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com
]]>