February 2, 2010 at 10:50 am
Hi,
We have a 3 node A/A/P cluster setup with SQL Server 2005 EE x64 with SP3. We have 1 instance on node1 and 3 instances on node2 and node3 is passive.
For instance1:
The .mdf file of MASTER, MODEL, MSDB database is on D drive (drive for data files) and
the .ldf file of MASTER, MODEL, MSDB database is on E drive (drive for log files)
and for the rest of the instances also mdf and ldf files are on different drives.
Is having ldf file of MASTER database on different drive (ldf file of MASTER databases has moved from the original drive(D) where it was initially installed) will block the Upgrade to SQL Server 2008?
thanks
February 2, 2010 at 12:34 pm
I don't believe you'll hae any issue running the upgrade because of the location of the (moved) master.ldf file. I have heard of issues with detached .mdf/.ldf files, but I always recommend reading through any kb article associated with a SQL product prior to upgrading.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
February 3, 2010 at 11:56 am
I want to move back the ldf files of MASTER, MODEL & MSDB to the original location (D drive).
Could you please advice me what are the steps I need to go through.
thanks
February 3, 2010 at 12:33 pm
BOL and msdn have specific articles and examples for doing that.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply