MS SQL 2005 - Moving transaction log to another drive

Business Central/NAV Technical Forum
1

hi,

MS SQL Server 2005

Drive E: location of Data and transaction log (RAID 5)

Drive D: new drive (RAID 1)

i want to move the transaction log to Drive D.

recovery model is FULL.

What is the step/procedure of moving transaction log to another drive within the server?

thank you.

2

http://support.microsoft.com/kb/224071

If you are uncomfortable with T-SQL scripts, you can also use the UI in SSMS. Right click the database and select ‘Detach’. Move the files to the other folder, and then right click ‘Databases’ and select ‘Attach’. You can browse to the files in there.

Of course before you do anything, you take a full backup yes?

You need to change the RAID config of your E drive to RAID 10. RAID 5 is the worst configuration for ERP databases, and especially for NAV databases.

3

thank for the quick reply.

i will do FULL backup before i move the transaction log location.

RAID 5 if what our NAV Provider setup to our server for Data/Transaction log.

what will happen in RAID 5 config?

4

http://en.wikipedia.org/wiki/Standard_RAID_levels

http://www.youtube.com/watch?v=TuwjadbtUCY - good explanation of the difference, only don’t listen to him when he gets so excited about RAID 5. It sounds like he is selling that controller. Even with a dedicated controller, performance on RAID 5 is crap for NAV databases.

Do a little searching on this forum and mibuso, you might find a number of interesting posts about this topic.

5

thanks for the advise.

is there a way i can migrate from RAID 5 to RAID 1+0?

HP DL380G6

HP Smart Array P410i/256 MB Controller (RAID 0/1/1+0/5/5+0)

thanks in advance!

6

You’ll have to get in touch with your NAV partner to set that up.