cannot connect using Enterprise Manager after moving tempdb
Posted on 2006-05-28
I execute the following command to move tempdb to the other drive. After I was done, I rebooted the server but found I could not extend the server node in the Enterprise Manager although the green arrow indicates it is running. The status bar shows: "Establishing connection to SQL Server and checking Windows security...". In windows Task manager, SQL Server enterprise Manager's status is "Not Responding." Please help!!
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\tempdb.mdf')
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'E:\templog.ldf')