Thanks Gail....I thinks it requires half day for rebuild the system DBs...

Initially Should I added new log in msdb and master databases in place of rebulid?

Thanks, I have opened it in MSDN forum..

http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/fc5469e5-5245-468e-bb54-bc4f0012b53b

Thanks.a.lot

I am able to login in Sharepoint service but I am not confirm about the Team foundation service as TFS service is running but in browsing it is giving error...

Gail I want to discuss this:

These are the initial errors which I was getting are below:

1.

Shrink failed for LogFile 'MSDBLog'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Shrink+LogFile&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception...

I have the .bak files of all databses.

I have remove the database engine service and reinstall the sql server database engine service due to which I have login in the...

Thanks Gail,

I am getting below error If I am starting sql server service as normal without any trace.

Windows could not start the sql server on local computer For more information...

Please find the error:

The following error I am getting:

Windows could not start the sql server on local computer For more information review the sytem event log ,If this is a...

The server is only starting using -t 3608 not with -m -c

Why??

This is 2008 R2 standard edition and if any account has not permitted from the logins of sql server to access sql serve then it cannot access and login in...

for sqlcmd every user is giving 18456 on cmd

Can u show the way to enter into the sqlcmd

Gila Thanks,

It has been started but when I am going to login it is now allowing and giving error 18456 and same for sqlcmd ...how to add second log file...Please...

My error log file is:

2011-11-07 14:33:05.15 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)

Mar 29 2009 10:27:29

Copyright (c) 1988-2008 Microsoft Corporation

Standard...

Ashish I have rebuild my system databases using

http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

1. I have copy paste new master,msdb,model data and log files.(Old files I have)

2. Now I have started my server using...

I am getting error when I am trying to shrink the log file:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Shrink failed for LogFile 'MSDBLog'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Shrink+LogFile&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An...