I installed SQL Server 2005 and then I used the following to try and move my system Databases around (per internal requirements):ALTER DATABASE MSDB MODIFY FILE ( NAME = MSDBData , FILENAME = 'E:\MSSQL\AML\DataFiles' )ALTER DATABASE MSDB MODIFY FILE ( NAME = MSDBLog , FILENAME = 'F:\MSSQL\AML\LogFiles' )ALTER DATABASE Model MODIFY FILE ( NAME = ModelDEV , FILENAME = 'E:\MSSQL\AML\DataFiles' )ALTER DATABASE Model MODIFY FILE ( NAME = ModelLog , FILENAME = 'F:\MSSQL\AML\LogFiles' )ALTER DATABASE TempDB MODIFY FILE ( NAME = TempDEV , FILENAME = 'G:\MSSQL\AML\TEMPDB' )ALTER DATABASE TempDB MODIFY FILE ( NAME = TempLOG , FILENAME = 'G:\MSSQL\AML\TEMPDB' )
notice that in my 'Alter' statements, I left off the FILENAMES!!!!I now SQL Server will only start in recovery mode from a Command prompt and someone suggested that I force-start sql server and then just rerun my CORRECTED statements. Problem is, I can start sql server in recovery mode but then i can open a new query window..any suggestions? can I start a query window without opening management studio?
Botched SQL Server 2005 Install
Posted - 2008-03-18 : 08:25:57
