u sure u havent done log shipping or mirroring??

u sure u havent done log shipping or mirroring??

http://msdn.microsoft.com/en-us/library/aa337552.aspx

http://msdn.microsoft.com/en-us/library/ms188659.aspx

Hope this will help

CHECK THE SHARED FOLDER IN SECONDARY also...IT MIGHT BE THE ERROR WITH THE ALERT..

Also check the logshipping status by querying the tables monitoring log shipping

Thanks alot calvo..

I tried that but when i connect to sqlcmd its showing server in single user mode cannot connect..

What to do?? Can u please answer?

I tried net start mssqlserver...

Thanks for the reply calvo ,

But am not able to access the sqlcmd ..I am able to start sql server in single user mode ...its showing failed for user domain\administrator..

U checked the share folder on primary??

Thanks Gian,

Will try that and let u know..

I really appreciate the help u have provided..Thanks alot man

Can u please let me know how can i monitor that??

I am not able to start the SQL Browser its throwing error always...

I tried that under all possible accounts but no use

Thanks Gianluca,

But still am in same situation 🙁

I have only one instance now..

C:\Program Files\Microsoft SQL Server\90\Shared>sc query | findstr /I "SQL"

DISPLAY_NAME: SQL Server Integration Services 10.0

SERVICE_NAME: MSSQLFDLauncher

DISPLAY_NAME: SQL Full-text Filter Daemon Launcher (MSSQLSERVER)

SERVICE_NAME: MSSQLSERVER

DISPLAY_NAME: SQL Server (MSSQLSERVER)

SERVICE_NAME:...

ya thats the location

I have remove 2008 R2 and now installed 2008 but when i tried right click and start on sqlbrowser.exe its showing sql server 2008 r2 console..

anything to do with...