Thanks for all your help. I have moved system files around and never had this kind of problem.. I will uninstall my sharepoint instance and start again. ...

from the CMD window, I issued:

SQLCMD - s Server\sharepoint

USE master

GO

ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'H:\MSSQL\Server\Sharepoint\TEMPDB')

GO

ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME =...

I am able to connect to the instance using SQLCMD and re-issue my commands.. and when I restart the instance.. it actually CREATES the new tempdb files in the new...

Not really sure what to do at this point..

C:\Users\>sqlcmd -s Servername

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd:...

I tried Gail's suggestion:

Start SQL from the command line with the flags -f -T3608

sqlservr.exe -f -T3608

That will start SQL in restricted mode, won't recover any databases. You'll be able...

Thanks Guys!!

I did start the instance using this command from the command prompt

E:\Microsoft SQL Server\MSSQL.3\MSSQL\Binn>sqlservr.exe -f -T3608 Servername

2011-01-14 11:42:41.55 Server A self-generated certificate was successfully

...

Thank you so much for the reply. what I ended up doing was

Select distinct path from ArticleSection

except

Select distinct path from Article

I found 3 rows that...

we are not going to 2008 because we have too many legacy apps that are not certified for 2008

Just a thought.. but we recently moved several DB Servers (SQL Server and DB2) to a new Hosting Company.

What I did was install 7Zip on each Server (source and...

Thank you. I missed that in the drop-down.. and your link helped : )

Thank you : )

I beleive that their are already exact copies of all of the other Server in the mix.. DNS, Domain Controllers, etc.. The last peice is to get our...

2003 R2 Enterprise Edition (64bit)

Thank you!!!

Do you think I should only take the Cluster Group offline or should the the Disk Group and MSDTC group also be taken offline?

Same here.. very rusty : )