Hi Vince,

Thanks for the script, but i was unaware that all other services needed to be stopped prior to execution and have run into a problem. I think that one or several of the Alter Database commands failed to execute. The script moved the mysqlsystemresource files to the new location (same as where the master files are located), but when i try to start sql server, it appears that sql server is still looking for the resource db in the default install location on the c drive. Is this a simple fix? If so, could you or anyone else give me a hand with this.

Here are the last few lines from the latest errorlog:

2009-12-22 14:32:17.81 spid7s Starting up database 'mssqlsystemresource'.

2009-12-22 14:32:17.81 spid7s Error: 17207, Severity: 16, State: 1.

2009-12-22 14:32:17.81 spid7s FCB::Open: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf'. Diagnose and correct the operating system error, and retry the operation. /* ***** THESE FILES WERE MOVED TO D:\SQLServer ***** */2009-12-22 14:32:17.81 spid7s Error: 17204, Severity: 16, State: 1.

2009-12-22 14:32:17.81 spid7s FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf for file number 1. OS error: 2(The system cannot find the file specified.).

2009-12-22 14:32:17.81 spid7s Error: 5120, Severity: 16, State: 101.

2009-12-22 14:32:17.81 spid7s Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf". Operating system error 2: "2(The system cannot find the file specified.)".

2009-12-22 14:32:17.81 spid7s Error: 17207, Severity: 16, State: 1.

2009-12-22 14:32:17.81 spid7s FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.

2009-12-22 14:32:17.81 spid7s File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf" may be incorrect.

2009-12-22 14:32:17.82 spid7s Error: 945, Severity: 14, State: 2.

2009-12-22 14:32:17.82 spid7s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

2009-12-22 14:32:17.84 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

TIA,

Tim