Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving SQL LDF (Log) Files Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2014 10:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:00 AM
Points: 6, Visits: 103
I know this is going to sound like a daft question but want to be safe

Working with a customer we are planning to move SQL Log files (.LDF) to another drive.
NOW what differs here is the drive is going to be the same...this is also in a VM environment.

Here is the plan...
1. We stop SQL Server Replication
2. We stop the SQL Server and SQL Agent service
3. Take the existing HDD offline (lets say this is G drive) which holds the LDF files.
4. Move the files on here to a new drive and bring the drive on line
5. Rename the Drive as before and same security and same drive letter so lets say G drive again.
So we now have a new drive attached BUT it has the same drive letter and volume name and permissions as before.

6. We bring the SQL Server/Agent services on-line
7. Bring Replication online again.
8. Job finished users can connect again.

So the daft question...will this work i.e. the move of LDF to a new drive but with drive leters and volume names the same?

Thanks Steve
Post #1557091
Posted Tuesday, April 1, 2014 10:29 AM This worked for the OP Answer marked as solution


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
As long as the drive letter and path are absolutely identical, and SQL has full access to the folder, that will work fine.
Take a backup first, for paranoia sake.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1557103
Posted Tuesday, April 1, 2014 10:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:00 AM
Points: 6, Visits: 103
Thanks so much we have to work with our customer on this so we will instruct them to make sure Permissions/Drive Letters/Volume names are all correct and as before to stop conflicts.

... and oh yes backup is a must so will be doing that.

Cheers and thanks for a quick reply ,

Steve
Post #1557109
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse