Move NAV SQL Log File to another drive

itinkiam

Sorry if this is posted, but I couldn't find it. I've got a simple SQL 2005, single file database which includes the .mdf,.ndf and .ldf. I need to move the log file. I've found the following online:

Detach the database
use master
go
sp_detach_db 'mydb'
go


Move the file(s) and Reattach the database
use master
go
sp_attach_db 'mydb','E:\Sqldata\mydbdata.mdf','E:\Sqldata\mydblog.ldf'
go

:-k Question - perhaps obvious, do I change the attach statement to include the .ndf? I'll only be moving the .ldf.

thanks in advance

ara3n

I've attached databases manually through the GUI and in the intermediate process you can specify the log file. The scrip will look like this.

USE [master]
GO
CREATE DATABASE [WIDE] ON 
( FILENAME = N'C:\temp\SQL\WIDE_Data.mdf' ),
( FILENAME = N'F:\WIDE_Log.ldf' ),
( FILENAME = N'C:\temp\SQL\WIDE_1_Data.ndf' )
 FOR ATTACH
GO

garak

you can also do this in the Guid in the contextmenu if you click on the database self.

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]

bbrown

Create the new log file, then use ShrinkFile (with Move) on the old file. Then drop the old file.