Can I do one thing that I will install the default instance on both the machine and one extra instance on mirror server ,the I will create the ODBC...

Dear Gila,

Thanks,Some sites are blocked and not opening like google books, etc. and internet is slow today also.

I have configured the witness server also in Mirror Server. But can you please tell how the application will connect to another database...

Thanx Ashish

I have also the single database but I want automatic connectivity of application to database if primary server fails..Guide me for this...

In database Mirroring can I have a virtual IP...

Please tell fast..

Actually we were trying to install the sql server cluster but thats not possible bcoz it is in production of...

Dear Standsted,

Thanks for reply , but can u check the links as

http://support.microsoft.com/kb/327518

http://technet.microsoft.com/en-us/library/cc758523(WS.10).aspx

Dear Standsted,

Thanks for reply , but can u check the links as

http://support.microsoft.com/kb/327518

http://technet.microsoft.com/en-us/library/cc758523(WS.10).aspx

Thanks,to clear my confusion.

Thanks to all but Adiga has got my point and one thing is annoying where that backup command is...?

Suppose from a long time we havent taken the full and txn log backup,and now we are not able to do the even dbcc shrink as well as no full...

Thanx for response

I have already written using the http UrLs.

http://10.1.96.56/Reports

http://10.1.96.56/Reportserver

Dear Brain,

Thanx to reply..

I am explaining suppose..I have started it at today 9-12-09.Now I have the backup of up to 23-12-09.

Now on 24-12-09 automatically the backup of 9-12-09 will be...

Dear Parthi and Kinda Port is 8443 not 8433

I have tried to do this but I am getting error as:

TITLE: Microsoft SQL Server Management Studio

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

Create failed for Database 'tests'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

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

ADDITIONAL INFORMATION:

An exception occurred while...

Dear Gila...

Thanks..Actually this is a critical scenario and to make changes in a running scenario is risky.

Have u the steps one by one in GUI form or any help...